[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 18 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Torres, Danielle, G,22947 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Wang, Shannon,11017 | 6434.31 | 3374.99 | 0.00 | 2316.97 | 742.35 |
| Nara, Katrina, Z,24608 | 2120.93 | 0.00 | 1000.44 | 0.00 | 1120.49 |
| Kapoor, Abby, J,29054 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Romero, Jacquelyn,25815 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Carlson, Jay,20264 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Stone, Denise,11032 | 6525.56 | 0.00 | 3374.99 | 0.00 | 3150.57 |
| Nara, Dawn, M,21891 | 4921.69 | 0.00 | 0.00 | 2443.35 | 2478.34 |
| Subram, Cory, B,27599 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Henderson, Marcus, D,15212 | 68.96 | 0.00 | 0.00 | 0.00 | 68.96 |
| Lu, Jeffery, B,19971 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Gomez, Randall, R,11762 | 8228.01 | 0.00 | 3399.99 | 0.00 | 4828.02 |
| Zhu, Roger, J,28098 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Guo, Jaclyn,13119 | 6829.45 | 0.00 | 0.00 | 2071.42 | 4758.03 |
| Gill, Dwayne, A,19675 | 198.99 | 0.00 | 0.00 | 0.00 | 198.99 |
| Luo, Warren,23562 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sanz, Jamie,26549 | 1361.45 | 0.00 | 0.00 | 782.99 | 578.46 |
| Alexander, Austin,26673 | 1505.76 | 0.00 | 0.00 | 782.99 | 722.77 |
| Ross, Adam,11099 | 8215.99 | 0.00 | 3399.99 | 0.00 | 4816.00 |
| Hernandez, Mallory,29091 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
| Zeng, Curtis, E,26669 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Evans, Jackson,14321 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Prasad, Preston, C,20812 | 4127.25 | 0.00 | 3578.27 | 0.00 | 548.98 |
| Madan, Carla, D,28135 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
Generated 2025-12-22 00:08:20.664 UTC