[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 12 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Richardson, Katelyn,18930 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Butler, Jose,29064 | 815.81 | 0.00 | 0.00 | 0.00 | 815.81 |
| Xu, Dennis,21997 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Patel, Stanley, L,24915 | 2145.92 | 0.00 | 0.00 | 1000.44 | 1145.48 |
| Sanchez, Michelle, R,26569 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Hu, Alejandro,13125 | 138.54 | 0.00 | 0.00 | 0.00 | 138.54 |
| Chandra, Virginia, M,27588 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Shen, Alisha, J,26438 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Martinez, Troy, L,20823 | 4216.75 | 0.00 | 3578.27 | 0.00 | 638.48 |
| Sanchez, Cynthia, S,23662 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Griffin, Noah, E,29118 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Ms., Robinson, Dorothy, B.,11952 | 8169.00 | 0.00 | 3374.99 | 0.00 | 4794.01 |
| Zhu, Amy, W,26664 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Serrano, Jacquelyn,21963 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
Generated 2025-12-24 09:05:54.928 UTC