[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 187 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ramirez, Abigail, S,15859 | 74.14 | 0.00 | 0.00 | 0.00 | 74.14 |
| Gonzalez, Molly,16370 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Reed, Kaylee, R,17371 | 151.92 | 0.00 | 0.00 | 0.00 | 151.92 |
| Peterson, Julia, P,16497 | 132.71 | 0.00 | 0.00 | 0.00 | 132.71 |
| Hughes, Riley,29284 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Gonzalez, Jackson, S,14480 | 194.94 | 0.00 | 0.00 | 0.00 | 194.94 |
| Griffin, Jason, L,11200 | 1267.11 | 0.00 | 0.00 | 391.08 | 876.03 |
| Nelson, Adam, B,27402 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Bell, Gabrielle,22373 | 5976.32 | 0.00 | 3578.27 | 0.00 | 2398.05 |
| Hughes, Samantha,27215 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Rodriguez, Richard,12969 | 180.79 | 0.00 | 0.00 | 0.00 | 180.79 |
| Lal, Kyle,17360 | 122.18 | 0.00 | 0.00 | 0.00 | 122.18 |
| Prasad, Donald,15413 | 318.92 | 0.00 | 0.00 | 123.98 | 194.94 |
| Martinez, Jonathan,13303 | 66.25 | 0.00 | 0.00 | 0.00 | 66.25 |
| Evans, Alexandra,24322 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Taylor, Madison, A,11802 | 215.29 | 0.00 | 0.00 | 127.96 | 87.33 |
| Flores, Emily,13206 | 163.19 | 0.00 | 0.00 | 69.97 | 93.22 |
| Parker, Katherine,13268 | 289.70 | 0.00 | 0.00 | 68.97 | 220.73 |
| Watson, Devin, A,18875 | 114.95 | 0.00 | 0.00 | 0.00 | 114.95 |
| Sharma, Samuel,27725 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Ramirez, Garrett, M,17388 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Bailey, Marcus, L,18329 | 146.53 | 0.00 | 0.00 | 23.78 | 122.75 |
| She, Kenneth,16096 | 212.01 | 0.00 | 0.00 | 80.96 | 131.05 |
| Henderson, Ashley,11185 | 1381.37 | 0.00 | 0.00 | 232.80 | 1148.57 |
| Barnes, Fernando,11300 | 1390.55 | 0.00 | 0.00 | 248.38 | 1142.17 |
| Sharma, Thomas, A,18637 | 121.94 | 0.00 | 0.00 | 0.00 | 121.94 |
| White, Abigail, T,15866 | 145.82 | 0.00 | 0.00 | 38.88 | 106.94 |
| Thomas, Emily,21803 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Jenkins, Megan, R,12074 | 261.38 | 0.00 | 0.00 | 0.00 | 261.38 |
| Chen, Jackson, S,27075 | 1371.95 | 0.00 | 782.99 | 0.00 | 588.96 |
| Rubio, Ruben, D,18871 | 86.96 | 0.00 | 0.00 | 86.96 | 0.00 |
Generated 2025-11-06 21:19:11.695 UTC