[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 546 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lee, John,19801 | 193.01 | 0.00 | 0.00 | 0.00 | 193.01 |
| Ma, Tiffany,21577 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Turner, Mary,22015 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Parker, Natalie, A,25104 | 3018.33 | 0.00 | 2443.35 | 0.00 | 574.98 |
| Foster, Antonio,12795 | 108.54 | 0.00 | 0.00 | 66.26 | 42.28 |
| Reed, Catherine, M,20380 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Griffin, Jack, L,17686 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| King, Jordan, C,11020 | 2316.97 | 0.00 | 0.00 | 2316.97 | 0.00 |
| Washington, Emma,19123 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Ross, Kaitlyn,16121 | 614.47 | 0.00 | 0.00 | 0.00 | 614.47 |
| Williams, Sydney, J,15334 | 848.47 | 0.00 | 0.00 | 0.00 | 848.47 |
| Martin, Madison, C,20492 | 71.97 | 0.00 | 0.00 | 71.97 | 0.00 |
| Peterson, Christina,28976 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Robinson, Dylan, L,14724 | 81.53 | 0.00 | 0.00 | 0.00 | 81.53 |
| Garcia, Alexandra, J,14107 | 819.46 | 0.00 | 0.00 | 819.46 | 0.00 |
Generated 2025-11-06 02:47:11.931 UTC