[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 22 < SKIP 1000 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Alexander, Ryan, J,14078 | 839.48 | 0.00 | 0.00 | 839.48 | 0.00 |
| Coleman, Destiny, W,12122 | 4814.04 | 0.00 | 0.00 | 0.00 | 4814.04 |
| Jones, Zachary, J,27285 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Turner, Jeremiah, F,19207 | 791.32 | 0.00 | 0.00 | 0.00 | 791.32 |
| Campbell, Natalie, L,11512 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
| Roberts, Rebecca,28000 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Washington, Emma,19123 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Hughes, Eduardo,15564 | 188.52 | 0.00 | 0.00 | 0.00 | 188.52 |
| Morris, Seth,18959 | 2341.46 | 0.00 | 0.00 | 0.00 | 2341.46 |
| Ross, Natalie, J,12916 | 261.22 | 0.00 | 0.00 | 0.00 | 261.22 |
| Bryant, Kyle,23164 | 4807.10 | 0.00 | 3578.27 | 0.00 | 1228.83 |
| Murphy, Emma,19844 | 5807.93 | 0.00 | 3374.99 | 0.00 | 2432.94 |
| Jackson, Victoria,27019 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Powell, Jack, J,18411 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Turner, Mary,22015 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| King, Morgan,19681 | 1179.97 | 0.00 | 0.00 | 0.00 | 1179.97 |
| Gonzalez, Gabriella, Z,15872 | 235.54 | 0.00 | 0.00 | 0.00 | 235.54 |
| Baker, Robert, A,27300 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Evans, James, C,20665 | 4408.56 | 0.00 | 0.00 | 2049.10 | 2359.46 |
| Flores, Miguel,19750 | 77.25 | 0.00 | 0.00 | 0.00 | 77.25 |
| Jones, Samantha,18317 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Wright, Jennifer,26505 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Garcia, Kaitlyn, J,26310 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Blue, Melanie, L,17861 | 1749.96 | 0.00 | 0.00 | 0.00 | 1749.96 |
| Shan, Logan,18677 | 60.96 | 0.00 | 0.00 | 29.99 | 30.97 |
| Powell, Ian,26085 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Watson, Cole, A,21768 | 4118.26 | 3578.27 | 0.00 | 0.00 | 539.99 |
| Shan, Gabriel, T,27731 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Sanchez, Faith,27049 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Perry, James,19205 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Bryant, Isabella, L,22995 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
Generated 2025-12-23 14:30:51.852 UTC