[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 77 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Thomas, Isabella, M,27265 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Allen, Allison, A,19757 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Barnes, Dalton, C,17858 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Scott, Gabrielle,27061 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ramos, Kristi,15176 | 4703.03 | 0.00 | 0.00 | 0.00 | 4703.03 |
| Adams, Kyle, E,18812 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Smith, Zachary, W,23783 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Mitchell, Lucas, C,19829 | 4533.45 | 0.00 | 3374.99 | 0.00 | 1158.46 |
| Rubio, Jaime, R,15007 | 209.83 | 0.00 | 0.00 | 0.00 | 209.83 |
| Russell, Fernando,27084 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Cook, Joan,23554 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Bradley, Evan,18506 | 101.94 | 0.00 | 0.00 | 0.00 | 101.94 |
| Hall, Jose, J,17601 | 225.42 | 0.00 | 0.00 | 0.00 | 225.42 |
| Moore, Taylor, A,19987 | 4564.45 | 0.00 | 3374.99 | 0.00 | 1189.46 |
| Rivera, Rachel, S,28996 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Russell, Isabella, A,11507 | 645.78 | 0.00 | 0.00 | 0.00 | 645.78 |
| Russell, Melanie, B,15478 | 182.83 | 0.00 | 0.00 | 38.88 | 143.95 |
| Hughes, Stephanie,26316 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Sanders, Paige,25287 | 2983.34 | 0.00 | 2443.35 | 0.00 | 539.99 |
| Martinez, Andrew, C,11530 | 523.81 | 0.00 | 0.00 | 78.48 | 445.33 |
| Moore, Seth,13851 | 2331.95 | 0.00 | 0.00 | 0.00 | 2331.95 |
| Evans, Connor, J,15402 | 131.55 | 0.00 | 0.00 | 0.00 | 131.55 |
| Harris, Natalie,23682 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Parker, Jordan,21621 | 2616.86 | 0.00 | 0.00 | 2049.10 | 567.76 |
| Henderson, Jackson, A,22121 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
| Wright, Robert, C,15889 | 4848.03 | 0.00 | 0.00 | 0.00 | 4848.03 |
| Howard, Alexandra,20736 | 3194.58 | 0.00 | 0.00 | 2049.10 | 1145.48 |
| Martinez, Jill,24235 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Ye, Alisha, J,22008 | 4141.23 | 0.00 | 3578.27 | 0.00 | 562.96 |
| Bryant, Rachel,22019 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Adams, Kaitlyn, A,11869 | 239.60 | 0.00 | 0.00 | 0.00 | 239.60 |
| Foster, Aaron,15566 | 4912.47 | 0.00 | 0.00 | 0.00 | 4912.47 |
| James, Richard, D,15760 | 109.23 | 0.00 | 0.00 | 0.00 | 109.23 |
| Mitchell, Evan, R,24731 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Young, Kaylee, S,13756 | 298.49 | 0.00 | 0.00 | 0.00 | 298.49 |
| Hernandez, Marcus,18595 | 2329.99 | 0.00 | 0.00 | 0.00 | 2329.99 |
| Gonzales, Trevor, K,16085 | 143.53 | 0.00 | 0.00 | 0.00 | 143.53 |
| Long, Rachel,28283 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Green, Eric,27380 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Hall, Elizabeth, L,13474 | 339.48 | 0.00 | 0.00 | 0.00 | 339.48 |
| Coleman, Logan,18686 | 91.95 | 0.00 | 0.00 | 0.00 | 91.95 |
| Collins, Charles, B,29041 | 628.45 | 0.00 | 0.00 | 0.00 | 628.45 |
| Yang, Jordan, K,14458 | 133.95 | 0.00 | 0.00 | 0.00 | 133.95 |
| Hernandez, Eduardo, J,18919 | 300.94 | 0.00 | 0.00 | 0.00 | 300.94 |
| Ramirez, Sydney,26700 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Nath, Alison, J,17116 | 1764.96 | 0.00 | 0.00 | 0.00 | 1764.96 |
| Brooks, Mariah,21620 | 2620.40 | 0.00 | 0.00 | 2071.42 | 548.98 |
| Adams, Hailey, M,12154 | 4798.53 | 0.00 | 0.00 | 0.00 | 4798.53 |
| Thompson, Tyler,27502 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Sanders, Angel,16219 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Liu, Arturo,13222 | 150.41 | 0.00 | 0.00 | 0.00 | 150.41 |
| Powell, Blake, J,22371 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Chen, Luis, G,21252 | 94.45 | 0.00 | 0.00 | 0.00 | 94.45 |
| Rogers, Sean, G,18685 | 124.46 | 0.00 | 0.00 | 0.00 | 124.46 |
| Foster, Antonio,12795 | 108.54 | 0.00 | 0.00 | 28.99 | 79.55 |
| White, Emily, M,15917 | 4679.06 | 0.00 | 0.00 | 0.00 | 4679.06 |
| King, Aaron, L,11739 | 4758.03 | 0.00 | 0.00 | 2359.98 | 2398.05 |
| Campbell, Jordan,13290 | 111.89 | 0.00 | 0.00 | 0.00 | 111.89 |
| Thomas, Dalton,23009 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Allen, Madeline,29240 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
Generated 2025-12-22 06:02:39.650 UTC