[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1031 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Macagno, Maurizio, J,14701 | 3001.02 | 0.00 | 0.00 | 2181.56 | 819.46 |
| Jenkins, Taylor,22791 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Cook, Steven, J,27053 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Ruiz, Derrick, C,12634 | 6787.76 | 0.00 | 0.00 | 2071.42 | 4716.34 |
| Xu, Rafael, A,21885 | 4641.85 | 0.00 | 0.00 | 2181.56 | 2460.29 |
| King, Bailey, A,20171 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Li, Marshall,12687 | 6805.47 | 0.00 | 0.00 | 2071.42 | 4734.05 |
| She, Colin, M,15139 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Brooks, Eduardo, F,15320 | 3152.96 | 0.00 | 0.00 | 782.99 | 2369.97 |
| Green, Evan, M,15322 | 3152.95 | 0.00 | 0.00 | 782.99 | 2369.96 |
| Ross, Ryan,16428 | 3021.02 | 0.00 | 0.00 | 2181.56 | 839.46 |
| Ruiz, Danny,24456 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Xie, Terrence,16199 | 6917.59 | 0.00 | 0.00 | 2181.56 | 4736.03 |
| Young, Savannah,25971 | 2749.32 | 0.00 | 0.00 | 2181.56 | 567.76 |
| Jai, Jack,26327 | 4433.17 | 0.00 | 0.00 | 2049.10 | 2384.07 |
| Bryant, Aaron,12067 | 133.96 | 0.00 | 0.00 | 0.00 | 133.96 |
| Peterson, Alexa,17188 | 3350.42 | 0.00 | 0.00 | 1000.44 | 2349.98 |
| Smith, Allen,14072 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Kapoor, Ronald,14192 | 9451.91 | 0.00 | 0.00 | 2181.56 | 7270.35 |
| Zhou, Edwin,14965 | 2753.82 | 0.00 | 0.00 | 2181.56 | 572.26 |
| Butler, Nicole, J,14081 | 3451.74 | 0.00 | 0.00 | 1000.44 | 2451.30 |
| Sanchez, Gabriella, G,25492 | 1764.96 | 0.00 | 0.00 | 0.00 | 1764.96 |
| Parker, Thomas,27399 | 84.46 | 0.00 | 0.00 | 0.00 | 84.46 |
| Wilson, Dylan, C,15309 | 1622.47 | 0.00 | 0.00 | 782.99 | 839.48 |
| Jones, Anna, A,29045 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Pal, Tamara,12689 | 6846.92 | 0.00 | 0.00 | 2071.42 | 4775.50 |
| Ramos, Alberto,12239 | 6901.42 | 0.00 | 0.00 | 2071.42 | 4830.00 |
| Cox, Katherine,28984 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Hayes, Angela,21325 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Harris, Austin,28577 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Coleman, Fernando, E,21250 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
Generated 2025-12-24 07:13:20.215 UTC