[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 236 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Baker, Sean, T,24778 | 2858.49 | 0.00 | 2181.56 | 0.00 | 676.93 |
| Cooper, Stephanie,24976 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Long, Caleb, P,25046 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Thomas, Charles,25094 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Griffin, Madison, A,25093 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Richardson, Victoria, C,24817 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Gray, Brianna,24960 | 3008.82 | 0.00 | 2443.35 | 0.00 | 565.47 |
| Turner, Andrea, A,20209 | 3268.55 | 0.00 | 2049.10 | 0.00 | 1219.45 |
| Martin, Morgan,24832 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Jai, Adam,25095 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Huang, Kristen,25100 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Carter, Luis, E,25883 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Murphy, Dalton, N,27043 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Cook, Steven, J,27053 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Young, Savannah,25971 | 2749.32 | 0.00 | 0.00 | 2181.56 | 567.76 |
| Perry, Olivia,20375 | 4438.38 | 0.00 | 0.00 | 2071.42 | 2366.96 |
| Morgan, Isaiah,18978 | 118.73 | 0.00 | 0.00 | 0.00 | 118.73 |
| Lee, Ethan, J,22359 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Thompson, Xavier, R,15761 | 192.41 | 0.00 | 0.00 | 0.00 | 192.41 |
| Hughes, Anna,19705 | 2341.97 | 0.00 | 0.00 | 0.00 | 2341.97 |
| Flores, Devin, A,15559 | 172.04 | 0.00 | 0.00 | 0.00 | 172.04 |
| Gonzales, Nathan, M,12107 | 222.23 | 0.00 | 0.00 | 0.00 | 222.23 |
| Jackson, Charles, P,11277 | 1305.66 | 0.00 | 0.00 | 34.99 | 1270.67 |
| Powell, Jasmine, A,11505 | 846.77 | 0.00 | 0.00 | 0.00 | 846.77 |
| Gonzales, Trevor, K,16085 | 143.53 | 0.00 | 0.00 | 0.00 | 143.53 |
| Russell, Caleb,23552 | 103.48 | 0.00 | 0.00 | 0.00 | 103.48 |
| Jenkins, Austin, D,15748 | 296.91 | 0.00 | 0.00 | 0.00 | 296.91 |
| Hayes, Dalton, C,18882 | 2322.28 | 0.00 | 0.00 | 0.00 | 2322.28 |
| Edwards, Hailey,24258 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Jones, Dalton, T,18951 | 2334.97 | 0.00 | 0.00 | 0.00 | 2334.97 |
Generated 2025-12-24 05:42:19.175 UTC