[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 62 < SKIP 94 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Prasad, Erick, E,28786 | 127.95 | 0.00 | 0.00 | 0.00 | 127.95 |
| Zhang, Heather,16654 | 3056.32 | 0.00 | 0.00 | 0.00 | 3056.32 |
| Taylor, Taylor,15905 | 4899.02 | 0.00 | 0.00 | 0.00 | 4899.02 |
| Brooks, Paige,22232 | 5985.31 | 0.00 | 3578.27 | 0.00 | 2407.04 |
| Watson, Olivia, S,13860 | 93.85 | 0.00 | 0.00 | 14.98 | 78.87 |
| Adams, Haley, M,24786 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Thompson, Blake,18390 | 141.96 | 0.00 | 0.00 | 0.00 | 141.96 |
| Johnson, Ian, E,21732 | 83.47 | 0.00 | 0.00 | 0.00 | 83.47 |
| Jai, Jose,12944 | 164.21 | 0.00 | 0.00 | 0.00 | 164.21 |
| Mitchell, Alexandra,14455 | 218.93 | 0.00 | 0.00 | 0.00 | 218.93 |
| Scott, Kaitlyn, A,12159 | 218.91 | 0.00 | 0.00 | 0.00 | 218.91 |
| Gomez, Briana, A,28784 | 43.98 | 0.00 | 0.00 | 0.00 | 43.98 |
| Thompson, Ethan,19989 | 4495.48 | 0.00 | 3374.99 | 0.00 | 1120.49 |
| Perez, Savannah, J,17036 | 176.95 | 0.00 | 0.00 | 0.00 | 176.95 |
| Davis, Daniel,11711 | 999.22 | 0.00 | 0.00 | 0.00 | 999.22 |
| Powell, David, W,26615 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Cox, Lucas, J,25393 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Bryant, Nathan,21450 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Hall, Kyle, J,17491 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Russell, Ian, T,24746 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Barnes, Dalton, C,17858 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Green, Mackenzie, C,28073 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Barnes, Jeremy,21446 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Coleman, Jennifer, L,27298 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Henderson, Jackson, A,22121 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
| Robinson, Julia,28121 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Isla, Julian, A,13732 | 108.96 | 0.00 | 0.00 | 4.99 | 103.97 |
| Lazecky, Petr,25864 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Coleman, Stephanie,22264 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| James, Emma,12781 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Stewart, Sara,17347 | 119.72 | 0.00 | 0.00 | 0.00 | 119.72 |
Generated 2025-12-23 03:59:24.469 UTC