[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 24 > < TAKE 48 >
48 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Brown, Samantha, G,25147 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Chen, Jack, E,17579 | 151.43 | 0.00 | 0.00 | 0.00 | 151.43 |
| Walker, John, M,28589 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Gonzalez, James, M,18842 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Hughes, Zachary,12203 | 157.91 | 0.00 | 0.00 | 0.00 | 157.91 |
| Martin, Brianna, M,23583 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Lewis, Ethan,27998 | 144.47 | 0.00 | 0.00 | 0.00 | 144.47 |
| Brown, Julia,18065 | 155.47 | 0.00 | 0.00 | 0.00 | 155.47 |
| Lopez, Bailey, R,18557 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Rivera, Kaitlyn, R,15490 | 4813.52 | 0.00 | 0.00 | 0.00 | 4813.52 |
| Lobao, Alexandre,18926 | 91.95 | 0.00 | 0.00 | 0.00 | 91.95 |
| Nelson, Luis,23488 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Cooper, Jacqueline, S,27634 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Washington, Christian, R,26686 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Li, Brandon,29339 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Thompson, Devin,20708 | 4406.40 | 0.00 | 0.00 | 2071.42 | 2334.98 |
| Reed, Paige,22112 | 6047.32 | 0.00 | 3578.27 | 0.00 | 2469.05 |
| Flores, Xavier,23866 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Moore, Logan,26348 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Flores, Eduardo, S,28969 | 62.98 | 0.00 | 0.00 | 0.00 | 62.98 |
| Price, Miranda,26629 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Coleman, Ian,21276 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Rodriguez, Taylor,16071 | 66.96 | 0.00 | 0.00 | 0.00 | 66.96 |
| Thompson, Jose,23731 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Hall, Taylor, J,16995 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Nelson, Henry,19394 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Gonzalez, Morgan,13065 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Edwards, Hailey,24258 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Adams, Julia, N,26073 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Thomas, Dalton,23009 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Blue, Makayla,19000 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Price, Devin, M,18758 | 158.51 | 0.00 | 0.00 | 0.00 | 158.51 |
| Long, Gavin,13762 | 186.03 | 0.00 | 0.00 | 0.00 | 186.03 |
| Edwards, Elijah, D,28157 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Morgan, Isabella, L,28602 | 144.47 | 0.00 | 0.00 | 0.00 | 144.47 |
| Li, Thomas,18116 | 2376.96 | 0.00 | 0.00 | 0.00 | 2376.96 |
| Rubio, Kellie,27653 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Hill, Katherine, L,26701 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Stewart, Allison, R,18826 | 166.43 | 0.00 | 0.00 | 0.00 | 166.43 |
| Walker, Ian,16771 | 104.55 | 0.00 | 0.00 | 0.00 | 104.55 |
| Butler, Cassidy, L,21792 | 114.46 | 0.00 | 0.00 | 0.00 | 114.46 |
| Ross, Seth, M,18433 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Barnes, Ian, M,16106 | 133.54 | 0.00 | 0.00 | 0.00 | 133.54 |
| Lee, Don,18839 | 2384.97 | 0.00 | 0.00 | 0.00 | 2384.97 |
| Garcia, Henry, B,11287 | 1009.24 | 0.00 | 0.00 | 96.07 | 913.17 |
| Reed, Bryan,18884 | 133.93 | 0.00 | 0.00 | 0.00 | 133.93 |
| Hughes, Luis,13084 | 1798.96 | 0.00 | 0.00 | 0.00 | 1798.96 |
| Kumar, Elijah,15197 | 156.92 | 0.00 | 0.00 | 0.00 | 156.92 |
Generated 2025-12-22 08:55:45.332 UTC