[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 38 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rodriguez, Harold, M,21184 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Hall, Amanda,26656 | 1345.95 | 0.00 | 0.00 | 1345.95 | 0.00 |
| Xu, Shawna,23419 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Wu, Brittney,23418 | 3400.02 | 0.00 | 0.00 | 2181.56 | 1218.46 |
| Shen, Kathryn, R,21957 | 4919.30 | 0.00 | 0.00 | 2443.35 | 2475.95 |
| Ma, Dawn, A,13956 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Ferrier, Jenny,21955 | 4900.68 | 0.00 | 0.00 | 2443.35 | 2457.33 |
| Sharma, Sharon, T,25294 | 1882.57 | 699.10 | 0.00 | 0.00 | 1183.47 |
| Martin, Alyssa,19587 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Gill, Joanna,26186 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Malhotra, Brett, E,18731 | 6054.06 | 0.00 | 3578.27 | 0.00 | 2475.79 |
| Kumar, Warren, A,24003 | 2806.53 | 0.00 | 0.00 | 2181.56 | 624.97 |
| Kumar, Rafael, L,19088 | 24.27 | 0.00 | 0.00 | 2.29 | 21.98 |
| Hernandez, Clinton,29462 | 854.82 | 0.00 | 0.00 | 0.00 | 854.82 |
| Anderson, Victoria,15799 | 4423.38 | 0.00 | 0.00 | 2071.42 | 2351.96 |
| Lin, Bianca,11107 | 8171.01 | 0.00 | 3374.99 | 2376.96 | 2419.06 |
| Ortega, Eddie,22908 | 4661.50 | 0.00 | 0.00 | 2181.56 | 2479.94 |
| Butler, Hannah, R,13111 | 5707.20 | 0.00 | 0.00 | 2071.42 | 3635.78 |
| Fernandez, Emmanuel,28955 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Nath, Ricardo, C,12039 | 8213.00 | 0.00 | 3374.99 | 0.00 | 4838.01 |
| Wu, Warren, M,15602 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Gonzalez, Summer, L,20266 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Hernandez, Mathew, A,15184 | 4441.38 | 0.00 | 0.00 | 2071.42 | 2369.96 |
| Alonso, Teresa,13138 | 83.97 | 0.00 | 0.00 | 3.99 | 79.98 |
| Jimenez, Jill,11028 | 6474.62 | 3374.99 | 0.00 | 0.00 | 3099.63 |
| Liu, Lacey, L,23545 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Luo, Tamara,18738 | 6089.59 | 0.00 | 3578.27 | 0.00 | 2511.32 |
| Raje, Lindsay, L,20613 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
Generated 2025-12-21 06:18:50.981 UTC