[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 63 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Peterson, Brian,12892 | 419.47 | 0.00 | 0.00 | 156.27 | 263.20 |
| Robinson, Emily,12183 | 228.42 | 0.00 | 0.00 | 54.96 | 173.46 |
| Williams, Ian, M,17558 | 1750.47 | 0.00 | 0.00 | 0.00 | 1750.47 |
| Jai, Samuel, L,16358 | 87.95 | 0.00 | 0.00 | 39.99 | 47.96 |
| Edwards, Amber, B,20517 | 76.97 | 0.00 | 0.00 | 0.00 | 76.97 |
| Patterson, Jeremy,13027 | 2319.26 | 0.00 | 0.00 | 0.00 | 2319.26 |
| Bailey, Marcus, L,18329 | 146.53 | 0.00 | 0.00 | 23.78 | 122.75 |
| Sharma, Kathryn,20740 | 140.94 | 0.00 | 0.00 | 0.00 | 140.94 |
| Flores, Megan, N,23074 | 6021.82 | 0.00 | 3578.27 | 0.00 | 2443.55 |
| Yuan, Carly,19839 | 194.96 | 0.00 | 0.00 | 0.00 | 194.96 |
| James, Richard, D,15760 | 109.23 | 0.00 | 0.00 | 3.99 | 105.24 |
| Griffin, Julian, M,11328 | 4718.04 | 0.00 | 0.00 | 2319.99 | 2398.05 |
| Bradley, Jocelyn,23022 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Gonzalez, Gabriella, Z,15872 | 235.54 | 0.00 | 0.00 | 0.00 | 235.54 |
| Rogers, Paige, H,17125 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Ward, Stephanie, A,27429 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Lal, Caleb, R,15868 | 74.46 | 0.00 | 0.00 | 0.00 | 74.46 |
| Martinez, Wyatt, R,22881 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
| Ware, Dennis, L,23725 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Richardson, Nathaniel,12089 | 4710.03 | 0.00 | 0.00 | 2316.97 | 2393.06 |
| Roberts, Amanda,17175 | 2334.98 | 0.00 | 0.00 | 0.00 | 2334.98 |
| Price, Stephanie,25892 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Adams, Carlos,19822 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Lopez, Carlos,18617 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Yang, Aaron, C,25196 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Diaz, Gabrielle,14893 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Campbell, Alex,11984 | 4730.32 | 0.00 | 0.00 | 2329.98 | 2400.34 |
| Reed, Sean, L,14597 | 4803.31 | 0.00 | 0.00 | 0.00 | 4803.31 |
| Allen, Allison, A,19757 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Clark, Emily, R,12086 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Alexander, Julia, J,15291 | 889.47 | 0.00 | 0.00 | 0.00 | 889.47 |
Generated 2025-11-04 13:43:09.852 UTC