[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 60 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Patterson, Natalie,16123 | 629.97 | 0.00 | 0.00 | 0.00 | 629.97 |
| Peterson, Morgan, J,16834 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Rodriguez, Alexandra,21642 | 2620.40 | 0.00 | 0.00 | 2071.42 | 548.98 |
| Ward, Angela, M,27756 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Morgan, Angela,24665 | 109.97 | 0.00 | 0.00 | 0.00 | 109.97 |
| Coleman, Spencer,15993 | 597.26 | 0.00 | 0.00 | 0.00 | 597.26 |
| Taylor, Victoria,26013 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Lopez, Carlos,18617 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Yang, Thomas, A,14108 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Russell, Katherine,28771 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Kumar, Zachary,25433 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gonzalez, Jordan,15157 | 213.94 | 0.00 | 0.00 | 123.98 | 89.96 |
| Clark, Zachary, J,23893 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Green, Isabella,26620 | 699.10 | 699.10 | 0.00 | 0.00 | 0.00 |
| Simmons, Haley, T,26202 | 2749.32 | 0.00 | 0.00 | 2181.56 | 567.76 |
| Davis, Nicholas,13201 | 73.16 | 0.00 | 0.00 | 0.00 | 73.16 |
| Powell, Miranda, J,15304 | 4843.00 | 0.00 | 0.00 | 0.00 | 4843.00 |
| Gonzales, Brianna, L,21148 | 3223.58 | 0.00 | 0.00 | 2049.10 | 1174.48 |
| Ramirez, Jennifer, E,21311 | 4472.58 | 0.00 | 0.00 | 2049.10 | 2423.48 |
| Luo, Franklin, J,22027 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Chen, Jack, E,17579 | 151.43 | 0.00 | 0.00 | 0.00 | 151.43 |
| Thomas, Jeremiah,18372 | 1760.47 | 0.00 | 0.00 | 0.00 | 1760.47 |
| Blanco, Randall,26321 | 1554.41 | 0.00 | 0.00 | 1000.44 | 553.97 |
| Powell, Jack, J,18411 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Brown, Anthony, J,19399 | 151.43 | 0.00 | 0.00 | 0.00 | 151.43 |
| She, Alisha, G,24757 | 4343.59 | 0.00 | 3578.27 | 0.00 | 765.32 |
| Hughes, Austin, P,18368 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Hernandez, Haley, L,11769 | 478.95 | 0.00 | 0.00 | 0.00 | 478.95 |
| Flores, Jordyn,25288 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Coleman, Ian,21276 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Butler, Dalton, A,13345 | 4759.51 | 0.00 | 0.00 | 0.00 | 4759.51 |
| Gray, Sara,29247 | 2447.05 | 0.00 | 0.00 | 0.00 | 2447.05 |
| Thomas, Matthew, K,13239 | 185.70 | 0.00 | 0.00 | 0.00 | 185.70 |
| Bailey, Olivia,23892 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Diaz, Angela, K,27259 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Price, Jeremy,25989 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| James, Jeremiah, S,11661 | 287.70 | 0.00 | 0.00 | 0.00 | 287.70 |
| Gonzales, Trevor, K,16085 | 143.53 | 0.00 | 0.00 | 14.98 | 128.55 |
| Martin, Lucas, L,22114 | 4183.23 | 0.00 | 3578.27 | 0.00 | 604.96 |
| Washington, Kayla, E,14655 | 174.96 | 0.00 | 0.00 | 0.00 | 174.96 |
| Brown, Morgan,29197 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Perez, Charles,26693 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Ashe, Alexis, S,19414 | 1145.48 | 0.00 | 0.00 | 0.00 | 1145.48 |
| Allen, Amanda,22353 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Morgan, Juan, C,18821 | 91.97 | 0.00 | 0.00 | 0.00 | 91.97 |
| Cooper, Alexandra,19541 | 131.24 | 0.00 | 0.00 | 0.00 | 131.24 |
| Phillips, Isaiah,28631 | 144.47 | 0.00 | 0.00 | 0.00 | 144.47 |
| Wood, Alexandria, M,24824 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Cooper, Paige,14119 | 148.94 | 0.00 | 0.00 | 0.00 | 148.94 |
| Perry, Christian,24671 | 4354.60 | 0.00 | 3578.27 | 0.00 | 776.33 |
| Wilson, Tyler, L,15879 | 196.93 | 0.00 | 0.00 | 0.00 | 196.93 |
| Smith, Justin, P,19827 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Bennett, Seth,24493 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Ward, Devin, J,15378 | 170.91 | 0.00 | 0.00 | 0.00 | 170.91 |
| Flores, Hannah,19525 | 40.23 | 0.00 | 0.00 | 0.00 | 40.23 |
| Peterson, Isabella,28080 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Wilson, Hunter, R,27230 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Walker, Thomas,13071 | 93.98 | 0.00 | 0.00 | 0.00 | 93.98 |
| Hill, Haley, J,16103 | 3142.32 | 0.00 | 0.00 | 0.00 | 3142.32 |
| Cooper, Timothy, J,20651 | 3198.57 | 0.00 | 0.00 | 2049.10 | 1149.47 |
Generated 2025-12-21 14:04:03.309 UTC