[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 45 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Perez, Charles,26693 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Foster, Alyssa, I,14875 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Green, Gabriella, C,28035 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Edwards, Amber, B,20517 | 76.97 | 0.00 | 0.00 | 0.00 | 76.97 |
| Deng, Damien, A,16873 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Hill, Eric, G,25256 | 67.93 | 0.00 | 0.00 | 67.93 | 0.00 |
| Wilson, Daniel, K,14281 | 4746.30 | 0.00 | 0.00 | 0.00 | 4746.30 |
| Stewart, Lucas, J,29341 | 98.97 | 0.00 | 0.00 | 0.00 | 98.97 |
| Murphy, Caitlin, L,14910 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Harris, Destiny, M,13710 | 2341.46 | 0.00 | 0.00 | 0.00 | 2341.46 |
| Flores, Zachary, H,23376 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Yang, Thomas, A,14108 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Rodriguez, Brianna, J,22267 | 4167.23 | 0.00 | 3578.27 | 0.00 | 588.96 |
| Thomas, David,16836 | 3193.79 | 0.00 | 0.00 | 0.00 | 3193.79 |
| Li, Kevin, S,25188 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Robinson, Ian, D,13852 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Hernandez, Jamie,27283 | 119.98 | 0.00 | 0.00 | 119.98 | 0.00 |
| Wilson, Eduardo,15323 | 804.47 | 0.00 | 0.00 | 0.00 | 804.47 |
| Thomas, Isabella, M,27265 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Foster, Kayla,19693 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 |
| Mehta, Carmen, C,27436 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Lee, Ethan, J,22359 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Peterson, Julia, P,16497 | 132.71 | 0.00 | 0.00 | 0.00 | 132.71 |
| Rivera, Kaitlyn, R,15490 | 4813.52 | 0.00 | 0.00 | 0.00 | 4813.52 |
| Washington, Ian, M,24664 | 4368.58 | 0.00 | 3578.27 | 0.00 | 790.31 |
| Jones, Nicole,14504 | 112.27 | 0.00 | 0.00 | 0.00 | 112.27 |
| Sara, Ivan, L,25090 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Rodriguez, Julia, A,26488 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Hughes, Miranda,26678 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gonzales, Trevor, K,16085 | 143.53 | 0.00 | 0.00 | 14.98 | 128.55 |
Generated 2025-11-06 04:02:21.580 UTC