[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 46 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Anderson, Destiny,12895 | 336.65 | 0.00 | 0.00 | 37.27 | 299.38 |
| Lewis, Seth,26782 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Price, Jeremy,25989 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Chapman, Nancy, E,11276 | 840.15 | 0.00 | 0.00 | 66.26 | 773.89 |
| Mr., Smith, Jeff,29283 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Thomas, Thomas,21629 | 2624.08 | 0.00 | 0.00 | 2049.10 | 574.98 |
| Rodriguez, Richard,12969 | 180.79 | 0.00 | 0.00 | 0.00 | 180.79 |
| Howard, Morgan, T,22971 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Scott, Allison,14497 | 804.48 | 0.00 | 0.00 | 0.00 | 804.48 |
| Stewart, Katherine, Z,22901 | 5971.33 | 0.00 | 3578.27 | 0.00 | 2393.06 |
| Hughes, Nathan, B,12113 | 4737.53 | 0.00 | 0.00 | 2294.99 | 2442.54 |
| Simmons, James,19884 | 4588.45 | 0.00 | 3399.99 | 0.00 | 1188.46 |
| Peterson, Brian,12892 | 419.47 | 0.00 | 0.00 | 156.27 | 263.20 |
| Walker, Hunter,27100 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Diaz, Trevor, B,20519 | 54.96 | 0.00 | 0.00 | 0.00 | 54.96 |
| Griffin, Xavier,22877 | 5962.34 | 0.00 | 3578.27 | 0.00 | 2384.07 |
| Stewart, Alex, M,20084 | 63.15 | 0.00 | 0.00 | 0.00 | 63.15 |
| Green, Gabrielle, M,21815 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Reed, Megan, A,18118 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Richardson, Caitlin, T,23057 | 6021.82 | 0.00 | 3578.27 | 0.00 | 2443.55 |
| Sun, Arturo, C,11498 | 557.54 | 0.00 | 0.00 | 12.94 | 544.60 |
| Jackson, Charles, P,11277 | 1305.66 | 0.00 | 0.00 | 237.82 | 1067.84 |
| Bell, Garrett, J,14265 | 161.23 | 0.00 | 0.00 | 0.00 | 161.23 |
| Long, Jordan,19988 | 4555.47 | 0.00 | 3399.99 | 0.00 | 1155.48 |
| Phillips, Haley, B,28079 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Anderson, Lucas,29266 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Nelson, Sean,11841 | 307.97 | 0.00 | 0.00 | 0.00 | 307.97 |
| Morris, Chase, F,26789 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| White, Miguel, S,13988 | 195.52 | 0.00 | 0.00 | 0.00 | 195.52 |
| Washington, Caroline, D,23114 | 5996.32 | 0.00 | 3578.27 | 0.00 | 2418.05 |
Generated 2025-11-06 06:01:31.463 UTC