[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SKIP 0 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Diaz, Lance, A,25323 | 1714.97 | 0.00 | 0.00 | 0.00 | 1714.97 |
| Robinson, Justin, A,23289 | 34.98 | 0.00 | 0.00 | 34.98 | 0.00 |
| Gonzalez, Isaac, E,17165 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Tang, Alisha, A,12869 | 32.60 | 0.00 | 0.00 | 32.60 | 0.00 |
| Rai, Katrina, W,16418 | 27.28 | 0.00 | 0.00 | 27.28 | 0.00 |
| Price, Arianna, W,24662 | 2493.54 | 0.00 | 0.00 | 2493.54 | 0.00 |
| Sun, Ronnie, J,21648 | 548.98 | 0.00 | 0.00 | 548.98 | 0.00 |
| Henderson, Kaitlyn, J,12132 | 9716.00 | 0.00 | 0.00 | 5022.96 | 4693.04 |
| Simmons, Miguel, D,26250 | 156.27 | 0.00 | 0.00 | 156.27 | 0.00 |
| Turner, Judith, A,26552 | 47.96 | 0.00 | 0.00 | 0.00 | 47.96 |
| Watson, Katelyn, B,21477 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Sharma, Zachary, C,17562 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Butler, Angelica,16556 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Yang, Clayton, C,25145 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Campbell, Sophia,11829 | 130.94 | 0.00 | 0.00 | 53.99 | 76.95 |
| Davis, Joseph, E,13352 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Hall, Maria,14385 | 1777.88 | 0.00 | 0.00 | 1000.44 | 777.44 |
| Harris, William,29048 | 4355.61 | 0.00 | 3578.27 | 0.00 | 777.34 |
| Zeng, Lisa, R,19480 | 1934.75 | 0.00 | 0.00 | 782.99 | 1151.76 |
| Vazquez, Kendra, L,22458 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Torres, Theodore,13577 | 9450.32 | 0.00 | 2181.56 | 0.00 | 7268.76 |
| Dominguez, Kari, S,17789 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Murphy, Kaitlyn, M,23817 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Ross, Jeremiah, L,15403 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Jai, Misty, A,17935 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Morris, Victoria, A,11688 | 5967.23 | 0.00 | 3578.27 | 2388.96 | 0.00 |
| Ms., Wright, Amanda,26317 | 2862.74 | 0.00 | 0.00 | 2862.74 | 0.00 |
| Romero, Brandi,19381 | 1953.47 | 0.00 | 0.00 | 1953.47 | 0.00 |
| She, Cassie,21031 | 597.95 | 0.00 | 0.00 | 597.95 | 0.00 |
| Sai, Virginia,27222 | 11.94 | 0.00 | 0.00 | 11.94 | 0.00 |
| Cook, Amanda, S,11279 | 44.57 | 0.00 | 0.00 | 2.29 | 42.28 |
| Griffin, Emily,19657 | 756.26 | 0.00 | 0.00 | 0.00 | 756.26 |
| Peterson, Zoe,13978 | 4775.30 | 0.00 | 0.00 | 2443.35 | 2331.95 |
| Young, Gabriel, C,25401 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Rivera, Olivia, N,17669 | 624.95 | 0.00 | 0.00 | 0.00 | 624.95 |
| Rodriguez, Jeremy, L,17464 | 1784.96 | 0.00 | 0.00 | 0.00 | 1784.96 |
| Washington, Dylan, A,20673 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Kelly, Katelyn, L,11260 | 81.26 | 0.00 | 0.00 | 42.28 | 38.98 |
| Harris, Emma, H,17554 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Flores, Jordan,17035 | 58.98 | 0.00 | 0.00 | 58.98 | 0.00 |
| Jimenez, Monique, C,28391 | 32.60 | 0.00 | 0.00 | 32.60 | 0.00 |
| Subram, Janelle,25672 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Hayes, Caleb,11650 | 128.97 | 0.00 | 0.00 | 74.98 | 53.99 |
| King, Lucas, L,13341 | 141.98 | 0.00 | 0.00 | 141.98 | 0.00 |
| Saunders, Darren, A,16221 | 588.96 | 0.00 | 0.00 | 588.96 | 0.00 |
| Jai, David,23483 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| White, Nathan, G,22361 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Lu, Amy, A,20464 | 22.93 | 0.00 | 0.00 | 0.00 | 22.93 |
| Bailey, Gabriella, A,15505 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Mr., Sandberg, Mikael,13566 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Rubio, Dana,19311 | 4640.26 | 0.00 | 0.00 | 1000.44 | 3639.82 |
| Moreno, Stacy,26513 | 2848.76 | 0.00 | 0.00 | 2071.42 | 777.34 |
| Hernandez, Daisy,25307 | 1759.97 | 0.00 | 0.00 | 0.00 | 1759.97 |
| Zimmerman, Henry,22192 | 84.97 | 0.00 | 0.00 | 0.00 | 84.97 |
| Rivera, Lauren, C,21317 | 108.95 | 0.00 | 0.00 | 0.00 | 108.95 |
| Hill, Hailey,19669 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Shan, Donna, J,17426 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Parker, Sophia, E,15895 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Powell, Logan, H,13761 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Sanders, Christina,22310 | 93.97 | 0.00 | 0.00 | 0.00 | 93.97 |
| Pearson, Simon,13472 | 2518.98 | 0.00 | 0.00 | 0.00 | 2518.98 |
| Chander, Carly, C,26961 | 1268.84 | 0.00 | 0.00 | 0.00 | 1268.84 |
Generated 2025-11-03 14:06:26.276 UTC