[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 35 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lee, James, J,28817 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Torres, Haley, W,23283 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Moore, Jennifer, A,21759 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Perez, Jonathan, R,23455 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Rogers, Shelby,11712 | 127.80 | 0.00 | 0.00 | 32.60 | 95.20 |
| Griffin, Cassidy,26496 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Wilson, Grace,17539 | 205.92 | 0.00 | 0.00 | 0.00 | 205.92 |
| Powell, Elijah, E,23113 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
| Collins, Isaac,26077 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Gill, Robyn, J,12765 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Thompson, Xavier, R,15761 | 192.41 | 0.00 | 0.00 | 0.00 | 192.41 |
| White, Nicole,16731 | 155.91 | 0.00 | 0.00 | 0.00 | 155.91 |
| Butler, Dalton, A,13345 | 4759.51 | 0.00 | 0.00 | 0.00 | 4759.51 |
| Bell, Garrett, J,14265 | 161.23 | 0.00 | 0.00 | 0.00 | 161.23 |
| Taylor, Marcus, A,18944 | 146.94 | 0.00 | 0.00 | 0.00 | 146.94 |
| Sanders, Melissa, R,24284 | 4837.34 | 0.00 | 3578.27 | 0.00 | 1259.07 |
| Carter, Jason,11724 | 210.09 | 0.00 | 0.00 | 71.58 | 138.51 |
| Powell, Spencer,14904 | 468.12 | 0.00 | 0.00 | 0.00 | 468.12 |
| Mitchell, Alexandra,14455 | 218.93 | 0.00 | 0.00 | 0.00 | 218.93 |
| Campbell, Alex,11984 | 4730.32 | 0.00 | 0.00 | 0.00 | 4730.32 |
| Simmons, Elizabeth, A,21461 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Ward, Angela, M,27756 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Jenkins, Samantha,11331 | 1290.33 | 0.00 | 0.00 | 0.00 | 1290.33 |
| Evans, Jordan,29209 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
Generated 2025-12-22 04:46:46.184 UTC