[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 1001 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| James, Morgan, E,23245 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Martin, Brianna, M,23583 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Jones, Zachary, J,27285 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Green, Gabriella, C,28035 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Sanders, Mason, G,23459 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| James, Adrian, C,25340 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Henderson, Jeremiah, D,18961 | 2369.96 | 0.00 | 0.00 | 0.00 | 2369.96 |
| Jackson, Hannah, G,13143 | 2404.97 | 0.00 | 0.00 | 0.00 | 2404.97 |
| Malhotra, Brenda,13391 | 2405.47 | 0.00 | 0.00 | 0.00 | 2405.47 |
| Young, Kaylee, S,13756 | 298.49 | 0.00 | 0.00 | 58.47 | 240.02 |
| Alexander, Paige, W,18604 | 59.25 | 0.00 | 0.00 | 37.27 | 21.98 |
| Flores, Luke, L,24733 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Gonzalez, Madeline, B,18922 | 2326.96 | 0.00 | 0.00 | 0.00 | 2326.96 |
| Parker, Jordan,21621 | 2616.86 | 0.00 | 0.00 | 2049.10 | 567.76 |
| Nelson, Katherine,28021 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Peterson, Gabrielle, D,24310 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Phillips, Luis, G,20734 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Mitchell, Xavier, L,26533 | 1629.41 | 0.00 | 0.00 | 1000.44 | 628.97 |
| Morgan, Abigail, C,24431 | 4334.60 | 0.00 | 3578.27 | 0.00 | 756.33 |
| Hayes, Dalton, C,18882 | 2322.28 | 0.00 | 0.00 | 0.00 | 2322.28 |
| Gonzalez, Jackson, S,14480 | 194.94 | 0.00 | 0.00 | 0.00 | 194.94 |
| Watson, Olivia, S,13860 | 93.85 | 0.00 | 0.00 | 14.98 | 78.87 |
| Parker, Amanda,18081 | 51.97 | 0.00 | 0.00 | 0.00 | 51.97 |
| Russell, Jacqueline,18391 | 100.96 | 0.00 | 0.00 | 78.98 | 21.98 |
| Alexander, Luke,29043 | 2447.05 | 0.00 | 0.00 | 2447.05 | 0.00 |
| Long, Chloe,16784 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Moore, Wyatt, F,18971 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Turner, Sean,22732 | 4133.24 | 0.00 | 3578.27 | 0.00 | 554.97 |
| Diaz, Hailey, W,11693 | 2294.99 | 0.00 | 0.00 | 2294.99 | 0.00 |
| Chen, James, D,11641 | 303.20 | 0.00 | 0.00 | 21.49 | 281.71 |
| Long, Morgan, H,21352 | 2625.39 | 0.00 | 0.00 | 2071.42 | 553.97 |
| Rogers, Bryce,17402 | 2304.98 | 0.00 | 0.00 | 0.00 | 2304.98 |
| Edwards, Eric,24627 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Reed, Morgan, E,28779 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Roberts, Amanda,17175 | 2334.98 | 0.00 | 0.00 | 0.00 | 2334.98 |
| Foster, Trevor, J,28964 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Thomas, Charles,25094 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Patterson, Grace, M,27560 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Butler, Jonathan,26180 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Roberts, Thomas, J,21939 | 4163.24 | 3578.27 | 0.00 | 0.00 | 584.97 |
| Smith, Samuel, D,23083 | 49.90 | 0.00 | 0.00 | 0.00 | 49.90 |
| Barnes, Blake, A,17865 | 1789.97 | 0.00 | 0.00 | 0.00 | 1789.97 |
| Coleman, Joan, W,26699 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Powell, Jack, J,18411 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Carter, Jose, H,12532 | 235.72 | 0.00 | 0.00 | 0.00 | 235.72 |
| Young, Adam,12984 | 200.20 | 0.00 | 0.00 | 37.29 | 162.91 |
| Campbell, Lucas,29329 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Diaz, Aidan, L,23846 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Powell, Sydney, M,14886 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Johnson, Ian, E,21732 | 83.47 | 0.00 | 0.00 | 0.00 | 83.47 |
| Peterson, Alex, M,13423 | 132.90 | 0.00 | 0.00 | 0.00 | 132.90 |
| Perry, Dalton, A,16149 | 192.04 | 0.00 | 0.00 | 0.00 | 192.04 |
| Adams, Carlos,19822 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Jenkins, Melissa, R,15997 | 4746.34 | 0.00 | 0.00 | 0.00 | 4746.34 |
| Chen, Luis, G,21252 | 94.45 | 0.00 | 0.00 | 94.45 | 0.00 |
| Moreno, Meredith, D,22285 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Stewart, Olivia, B,18749 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Foster, Isabelle,26377 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Garcia, Kaitlyn, J,26310 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Ross, Aaron, N,11888 | 2376.96 | 0.00 | 0.00 | 2376.96 | 0.00 |
| Luo, Jodi,29213 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Miller, Eduardo,14561 | 158.84 | 0.00 | 0.00 | 49.97 | 108.87 |
Generated 2025-11-06 06:28:49.719 UTC