[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 45 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sanz, Hector,27344 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Guo, Jake, P,19969 | 98.45 | 0.00 | 0.00 | 67.97 | 30.48 |
| Schmidt, Joe, M,22905 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Martinez, Jermaine, L,15170 | 4391.41 | 0.00 | 0.00 | 2071.42 | 2319.99 |
| Vance, Ruth, D,17302 | 147.44 | 0.00 | 0.00 | 0.00 | 147.44 |
| Goel, April, C,16166 | 108.85 | 0.00 | 0.00 | 0.00 | 108.85 |
| Munoz, Audrey, V,12003 | 8256.50 | 0.00 | 3374.99 | 0.00 | 4881.51 |
| Patel, Harold,24585 | 3366.02 | 0.00 | 0.00 | 2181.56 | 1184.46 |
| Liang, Damien, M,22150 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Romero, Dwayne,28314 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Chande, Alvin, W,24893 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Andersen, Rafael, E,12691 | 247.46 | 0.00 | 0.00 | 0.00 | 247.46 |
| Ye, Amy,11073 | 191.90 | 0.00 | 0.00 | 0.00 | 191.90 |
| Subram, Francisco, A,21897 | 4909.67 | 0.00 | 0.00 | 2443.35 | 2466.32 |
| Kumar, Cristina, N,15426 | 115.92 | 0.00 | 0.00 | 0.00 | 115.92 |
| Ashe, Tara, J,19093 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Evans, Xavier,19098 | 122.24 | 0.00 | 0.00 | 0.00 | 122.24 |
| Hu, Dennis, J,20600 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Perez, Cesar, L,27982 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Romero, Julio,22857 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Vance, Denise, L,21205 | 4886.70 | 0.00 | 2443.35 | 0.00 | 2443.35 |
| Rodriguez, Carla, V,21230 | 4171.62 | 0.00 | 2443.35 | 0.00 | 1728.27 |
| Navarro, Julio, M,25822 | 1819.59 | 0.00 | 699.10 | 0.00 | 1120.49 |
| Zhu, Alan,17320 | 4391.74 | 0.00 | 3578.27 | 0.00 | 813.47 |
Generated 2025-12-22 06:43:36.450 UTC