[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 29 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Arun, Marie, E,22844 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Sharma, Lindsay, E,24478 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Sharma, Keith,15728 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Patel, Veronica,13963 | 74.48 | 0.00 | 0.00 | 0.00 | 74.48 |
| Mehta, Cindy, A,21943 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Luo, Lindsey, R,22201 | 5012.27 | 0.00 | 0.00 | 2443.35 | 2568.92 |
| _SUM | 9051988.22 | 305781.60 | 2436953.50 | 2256921.46 | 4052331.66 |
| Ramos, Jay, D,21882 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Wang, Martha, D,24272 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Romero, Mallory,26434 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Nara, Katrina, Z,24608 | 2120.93 | 0.00 | 1000.44 | 0.00 | 1120.49 |
| Mr., Sands, Patrick,14063 | 5676.25 | 0.00 | 0.00 | 2071.42 | 3604.83 |
| Rodriguez, Dylan, E,16611 | 75.53 | 0.00 | 0.00 | 0.00 | 75.53 |
| Malhotra, Veronica, J,25922 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Shen, Priscilla, A,28215 | 589.96 | 0.00 | 0.00 | 0.00 | 589.96 |
| Henderson, Angela, T,11898 | 8179.03 | 0.00 | 3399.99 | 0.00 | 4779.04 |
| Raman, Brandy,12247 | 77.27 | 0.00 | 0.00 | 49.99 | 27.28 |
| Kumar, Louis, A,18203 | 4172.25 | 0.00 | 3578.27 | 0.00 | 593.98 |
| Martin, Renee, L,17478 | 4758.24 | 0.00 | 3578.27 | 0.00 | 1179.97 |
| Arun, Denise,28218 | 18.97 | 0.00 | 0.00 | 0.00 | 18.97 |
| Huang, Wesley,29320 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Price, Trevor, M,15725 | 4416.38 | 0.00 | 0.00 | 2071.42 | 2344.96 |
| Moore, Nathan, N,28323 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Li, Jake, L,19583 | 97.96 | 0.00 | 0.00 | 0.00 | 97.96 |
| Chandra, Ann,18209 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Sharma, Tracy,17731 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Arthur, Joel,27701 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Moreno, Robin,19563 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
Generated 2025-12-21 15:35:54.884 UTC