[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SKIP 0 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gonzales, Brittany,21710 | 4187.23 | 3578.27 | 0.00 | 0.00 | 608.96 |
| Green, Isabella,26620 | 699.10 | 699.10 | 0.00 | 0.00 | 0.00 |
| Roberts, Thomas, J,21939 | 4163.24 | 3578.27 | 0.00 | 0.00 | 584.97 |
| Ye, Alisha, J,22008 | 4141.23 | 3578.27 | 0.00 | 0.00 | 562.96 |
| Mitchell, Lucas, C,19829 | 4533.45 | 3374.99 | 0.00 | 0.00 | 1158.46 |
| Brown, Isabella, L,26692 | 1266.86 | 0.00 | 699.10 | 0.00 | 567.76 |
| Miller, Joseph, A,22713 | 4148.19 | 0.00 | 3578.27 | 0.00 | 569.92 |
| Brooks, Makayla,22252 | 6047.32 | 0.00 | 3578.27 | 0.00 | 2469.05 |
| Howard, Morgan, T,22971 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Stewart, Katherine, Z,22901 | 5971.33 | 0.00 | 3578.27 | 0.00 | 2393.06 |
| Henderson, Jordan, C,22996 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Flores, Megan, N,23074 | 6021.82 | 0.00 | 3578.27 | 0.00 | 2443.55 |
| Bryant, Kyle,23164 | 4807.10 | 0.00 | 3578.27 | 1228.83 | 0.00 |
| Brooks, Isaac, M,23385 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Ortega, Byron,23306 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Flores, Zachary, H,23376 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Ware, Dennis, L,23725 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Jackson, Joseph, R,23592 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
| Alexander, Ashley, J,20007 | 4495.48 | 0.00 | 3374.99 | 0.00 | 1120.49 |
| Rodriguez, Morgan,23730 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Coleman, Benjamin, F,23486 | 5343.23 | 0.00 | 3578.27 | 0.00 | 1764.96 |
| Anderson, Megan, A,23859 | 4153.25 | 0.00 | 3578.27 | 574.98 | 0.00 |
| Diaz, Aidan, L,23846 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Martin, Brianna, M,23583 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Rodriguez, Joshua, A,23511 | 4843.11 | 0.00 | 3578.27 | 0.00 | 1264.84 |
| Campbell, Evan, W,24342 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Chander, Wayne, S,24344 | 4329.61 | 0.00 | 3578.27 | 751.34 | 0.00 |
| Ms., Coleman, Abigail, C,23868 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Jones, Madison,24661 | 4181.76 | 0.00 | 3578.27 | 603.49 | 0.00 |
| Perry, Christian,24671 | 4354.60 | 0.00 | 3578.27 | 0.00 | 776.33 |
| Long, Caleb, P,25046 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Murphy, Olivia, V,20206 | 3204.58 | 0.00 | 2049.10 | 0.00 | 1155.48 |
| Griffin, Madison, A,25093 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Gray, Brianna,24960 | 3008.82 | 0.00 | 2443.35 | 565.47 | 0.00 |
| Turner, Andrea, A,20209 | 3268.55 | 0.00 | 2049.10 | 0.00 | 1219.45 |
| Hughes, Julia,25061 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Jai, Adam,25095 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Ross, Haley, T,25361 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Huang, Kristen,25100 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Price, Jocelyn, D,25875 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Chen, Jackson, S,27075 | 1371.95 | 0.00 | 782.99 | 0.00 | 588.96 |
| Sanders, Alexandra,25911 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Hayes, Arianna,25991 | 2845.52 | 0.00 | 0.00 | 2181.56 | 663.96 |
| Blanco, Randall,26321 | 1554.41 | 0.00 | 0.00 | 1000.44 | 553.97 |
| Hill, Sydney,26482 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Griffin, Cassidy,26496 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Wilson, Christian,27085 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Williams, Zachary, B,27099 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Bell, Eduardo,27101 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Ross, Rachel, C,20669 | 3169.59 | 0.00 | 0.00 | 2049.10 | 1120.49 |
| Perry, Marcus, L,20656 | 3245.90 | 0.00 | 0.00 | 2071.42 | 1174.48 |
| Robinson, Jennifer, L,26504 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Diaz, Angela, K,27259 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Thompson, Joshua, F,25999 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Gonzales, Brianna, L,21148 | 3223.58 | 0.00 | 0.00 | 2049.10 | 1174.48 |
| Phillips, Kaylee,21138 | 4371.38 | 0.00 | 0.00 | 2049.10 | 2322.28 |
| Perez, Angel, S,21336 | 2628.35 | 0.00 | 0.00 | 2071.42 | 556.93 |
| Jones, Zachary, J,27285 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Kelly, Bryan,21349 | 2989.38 | 0.00 | 0.00 | 2989.38 | 0.00 |
| Roberts, Amber, W,21582 | 2638.06 | 0.00 | 0.00 | 2049.10 | 588.96 |
| Watson, Michelle, H,26235 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Johnson, Andrew, F,26294 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
Generated 2025-11-01 22:04:03.288 UTC