[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 86 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Stewart, Alex, M,20084 | 63.15 | 0.00 | 0.00 | 0.00 | 63.15 |
| Perry, Christian,24671 | 4354.60 | 0.00 | 3578.27 | 0.00 | 776.33 |
| Clark, Zachary, J,23893 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Reed, Michelle,28046 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Diaz, Hunter, S,27242 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Alexander, Thomas,20760 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Thames, Bernard,23803 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Prasad, Molly,24392 | 4329.61 | 0.00 | 3578.27 | 0.00 | 751.34 |
| Morris, Chase, F,26789 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Lopez, Bailey, R,18557 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Gonzales, Kayla,21494 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Zhang, Nathan, L,29104 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Gonzalez, Gabriella, Z,15872 | 235.54 | 0.00 | 0.00 | 0.00 | 235.54 |
| Bryant, Nathan,21450 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Gonzalez, Jackson, S,14480 | 194.94 | 0.00 | 0.00 | 0.00 | 194.94 |
| Williams, Austin,20354 | 32.22 | 0.00 | 0.00 | 0.00 | 32.22 |
| Hernandez, Haley, L,11769 | 478.95 | 0.00 | 0.00 | 0.00 | 478.95 |
| Cook, Steven, J,27053 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Turner, Jose,11784 | 272.69 | 0.00 | 0.00 | 0.00 | 272.69 |
| Harris, Jacob, G,23679 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Cooper, Angela,19526 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Ramirez, Richard, C,28239 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Jackson, Edward,29042 | 2420.34 | 0.00 | 0.00 | 2420.34 | 0.00 |
| Watson, Olivia, S,13860 | 93.85 | 0.00 | 0.00 | 14.98 | 78.87 |
| Green, Kaylee, C,26185 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Baker, Mason, A,13270 | 2394.95 | 0.00 | 0.00 | 0.00 | 2394.95 |
| Russell, Elijah, M,11835 | 4772.30 | 0.00 | 0.00 | 2319.26 | 2453.04 |
| Young, Julia, J,27414 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Generated 2025-12-22 03:08:39.295 UTC