[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 32 >
32 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sara, Ruben, A,19566 | 164.91 | 0.00 | 0.00 | 0.00 | 164.91 |
| Lin, Autumn, E,18272 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Tang, Colin,14323 | 5222.02 | 0.00 | 0.00 | 2071.42 | 3150.60 |
| Zhou, Trisha, B,12686 | 6864.46 | 0.00 | 0.00 | 2071.42 | 4793.04 |
| Subram, Roy,21896 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Raman, Cindy,16157 | 4391.41 | 0.00 | 0.00 | 2071.42 | 2319.99 |
| Gill, Jaime, M,26152 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Chande, Bonnie, L,23992 | 3167.82 | 0.00 | 0.00 | 2443.35 | 724.47 |
| Anand, Alison, J,24009 | 2746.04 | 0.00 | 0.00 | 2181.56 | 564.48 |
| Torres, Melinda, J,14033 | 6809.96 | 0.00 | 0.00 | 2071.42 | 4738.54 |
| Foster, Hunter, A,20269 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Carlson, Jay,20264 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Zhou, Steve, C,20263 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Lal, Colin, M,16640 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Anand, Lacey, J,27150 | 201.28 | 0.00 | 0.00 | 0.00 | 201.28 |
| Serrano, Francis, R,23547 | 3598.83 | 0.00 | 0.00 | 2443.35 | 1155.48 |
| Suarez, Rebekah,13649 | 6812.13 | 0.00 | 0.00 | 2049.10 | 4763.03 |
| Zeng, Alvin, M,11118 | 115.85 | 0.00 | 0.00 | 0.00 | 115.85 |
| Garcia, Monica, D,20267 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Shen, Katrina,15801 | 4381.38 | 0.00 | 0.00 | 2049.10 | 2332.28 |
| Green, Kyle,28328 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hernandez, Philip,21193 | 3905.52 | 0.00 | 2181.56 | 0.00 | 1723.96 |
| Zeng, Ernest, M,12992 | 158.51 | 0.00 | 0.00 | 0.00 | 158.51 |
| Raje, Wayne, A,21372 | 74.96 | 0.00 | 0.00 | 0.00 | 74.96 |
| Gomez, Andy,18721 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Rodriguez, Monica, J,28951 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Zhao, Colin, D,24241 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Munoz, Theresa, M,13953 | 6840.75 | 0.00 | 0.00 | 2071.42 | 4769.33 |
| Martin, Deanna,13091 | 6864.95 | 0.00 | 0.00 | 2071.42 | 4793.53 |
| Griffin, Caroline,17726 | 4721.73 | 0.00 | 3578.27 | 0.00 | 1143.46 |
| She, Derek,15036 | 3785.08 | 0.00 | 0.00 | 2049.10 | 1735.98 |
| Raji, Arturo,23998 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
Generated 2025-12-22 05:28:07.598 UTC