[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 15 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Hayes, Hannah, J,21656 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Morris, Paige, W,22041 | 4167.23 | 3578.27 | 0.00 | 0.00 | 588.96 |
| Chen, Jack, E,17579 | 151.43 | 0.00 | 0.00 | 0.00 | 151.43 |
| She, Kenneth,16096 | 212.01 | 0.00 | 0.00 | 0.00 | 212.01 |
| Stewart, Amanda, M,15310 | 94.44 | 0.00 | 0.00 | 0.00 | 94.44 |
| Ward, Lucas, N,18363 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| James, Sara,19802 | 3374.99 | 3374.99 | 0.00 | 0.00 | 0.00 |
| Griffin, Isabelle,24986 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ward, Mariah, J,21580 | 44.91 | 0.00 | 0.00 | 0.00 | 44.91 |
| Wilson, Christian,27085 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Hill, Blake,11748 | 131.54 | 0.00 | 0.00 | 0.00 | 131.54 |
| Griffin, Marcus,20756 | 34.56 | 0.00 | 0.00 | 0.00 | 34.56 |
| Green, Gabriella, C,28035 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Russell, Chloe, M,12763 | 589.96 | 0.00 | 0.00 | 0.00 | 589.96 |
| Bryant, Samantha,18345 | 115.47 | 0.00 | 0.00 | 0.00 | 115.47 |
| Peterson, Christina,28976 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Garcia, Hunter, J,21305 | 3204.58 | 0.00 | 0.00 | 2049.10 | 1155.48 |
| Perez, Angel, S,21336 | 2628.35 | 0.00 | 0.00 | 2071.42 | 556.93 |
| Bennett, Maria, G,22983 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Scott, Sean, F,24755 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Washington, Riley, L,18544 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Diaz, Gabrielle,14893 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Baker, Sean, T,24778 | 2858.49 | 0.00 | 2181.56 | 0.00 | 676.93 |
| Phillips, Haley, B,28079 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Raje, Mindy, A,16083 | 561.97 | 0.00 | 0.00 | 0.00 | 561.97 |
| Ramirez, Garrett, M,17388 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Harris, Jacob, G,23679 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Taylor, Edward, C,17442 | 319.88 | 0.00 | 0.00 | 0.00 | 319.88 |
| Adams, Julia, N,26073 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Moore, Anthony, M,24730 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ross, Rachel, C,20669 | 3169.59 | 0.00 | 0.00 | 2049.10 | 1120.49 |
| James, Morgan, E,23245 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Perez, Sydney, C,22117 | 4158.24 | 0.00 | 3578.27 | 0.00 | 579.97 |
| Anderson, Ashley,20680 | 3219.58 | 0.00 | 0.00 | 2049.10 | 1170.48 |
| Rodriguez, Brianna, J,22267 | 4167.23 | 0.00 | 3578.27 | 0.00 | 588.96 |
| Coleman, Miguel, D,27400 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Griffin, Stephanie, L,28261 | 27.92 | 0.00 | 0.00 | 0.00 | 27.92 |
| Davis, Jonathan,29259 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Young, Kaitlyn, J,25062 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Moore, Hunter,14897 | 196.27 | 0.00 | 0.00 | 0.00 | 196.27 |
| Gonzales, Luis,15856 | 116.25 | 0.00 | 0.00 | 37.27 | 78.98 |
| Johnson, Jonathan,22059 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Clark, Destiny, L,28600 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Bailey, Alexandria, V,13209 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
| Taylor, Christian,20764 | 56.76 | 0.00 | 0.00 | 0.00 | 56.76 |
| Bell, Timothy, J,28101 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Phillips, Andrea,18573 | 83.74 | 0.00 | 0.00 | 0.00 | 83.74 |
| Campbell, Kevin, S,12177 | 4811.50 | 0.00 | 0.00 | 0.00 | 4811.50 |
| Winston, Ethan, R,21622 | 2612.06 | 0.00 | 0.00 | 2049.10 | 562.96 |
| Cook, Megan, J,20299 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Alexander, Thomas,20760 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Yang, Justin, S,15363 | 4719.04 | 0.00 | 0.00 | 0.00 | 4719.04 |
| Bradley, Melanie, G,13343 | 4720.27 | 0.00 | 0.00 | 0.00 | 4720.27 |
| Green, Isabella,26620 | 699.10 | 699.10 | 0.00 | 0.00 | 0.00 |
| Morgan, Abigail, C,24431 | 4334.60 | 0.00 | 3578.27 | 0.00 | 756.33 |
| Morris, Seth,18959 | 2341.46 | 0.00 | 0.00 | 0.00 | 2341.46 |
Generated 2025-12-21 08:43:49.900 UTC