[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 63 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Shan, Peter,24280 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Lopez, Heidi,11052 | 8131.32 | 0.00 | 3374.99 | 2337.27 | 2419.06 |
| Stewart, Bryan, M,16928 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Zheng, Laura,16701 | 4426.74 | 0.00 | 3578.27 | 0.00 | 848.47 |
| Diaz, Rebekah, J,21378 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| She, Cedric, R,12580 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Zeng, Ernest, M,12992 | 158.51 | 0.00 | 0.00 | 0.00 | 158.51 |
| Goel, Derek,17045 | 4480.73 | 0.00 | 3578.27 | 0.00 | 902.46 |
| Raman, Patricia, T,16702 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Evans, Carlos, J,23538 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Price, Deb,24502 | 3623.32 | 0.00 | 0.00 | 2443.35 | 1179.97 |
| Ma, Cedric, W,11094 | 157.93 | 0.00 | 0.00 | 0.00 | 157.93 |
| Kapoor, Kaitlin, M,17072 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Gonzales, Victoria,11751 | 8215.02 | 0.00 | 3399.99 | 0.00 | 4815.03 |
| Lu, Krystal,17049 | 4347.76 | 0.00 | 3578.27 | 0.00 | 769.49 |
| Alexander, Gabriel, C,14073 | 156.84 | 0.00 | 0.00 | 0.00 | 156.84 |
| Zhang, Ronnie,16656 | 5930.23 | 0.00 | 3578.27 | 0.00 | 2351.96 |
| Romero, Billy,20419 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Torres, Diane, M,25211 | 79.47 | 0.00 | 0.00 | 0.00 | 79.47 |
| Zhu, Alan,17320 | 4391.74 | 0.00 | 3578.27 | 0.00 | 813.47 |
| Chande, Dale, K,17242 | 4387.23 | 0.00 | 3578.27 | 0.00 | 808.96 |
| Munoz, Carolyn, L,17315 | 6030.61 | 0.00 | 3578.27 | 0.00 | 2452.34 |
| Kumar, Deborah, K,17308 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Wang, Crystal, C,11112 | 8295.02 | 0.00 | 3374.99 | 0.00 | 4920.03 |
| Arun, Ruth, S,17294 | 4355.71 | 0.00 | 3578.27 | 0.00 | 777.44 |
| Moore, Michael,17247 | 4432.72 | 0.00 | 3578.27 | 0.00 | 854.45 |
| Schmidt, Pamela, I,24375 | 31.73 | 0.00 | 0.00 | 0.00 | 31.73 |
| Deng, Clayton, G,17285 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Rana, Darren, M,17257 | 4480.73 | 0.00 | 3578.27 | 0.00 | 902.46 |
| Perez, Kevin, M,25565 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Sanz, Monique, R,24273 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
Generated 2025-12-23 11:56:27.728 UTC