[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 563 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Fernandez, Michele, M,24884 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Ruiz, Leslie, J,26032 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Martinez, Harold, J,20604 | 93.49 | 0.00 | 0.00 | 0.00 | 93.49 |
| Lin, Laura, L,11462 | 8116.33 | 0.00 | 3374.99 | 2322.28 | 2419.06 |
| Shen, Priscilla, A,28215 | 589.96 | 0.00 | 0.00 | 0.00 | 589.96 |
| Goel, Derek,17045 | 4480.73 | 3578.27 | 0.00 | 0.00 | 902.46 |
| Griffin, Caroline,17726 | 4721.73 | 0.00 | 3578.27 | 0.00 | 1143.46 |
| Kumar, Wayne,17502 | 6070.59 | 0.00 | 3578.27 | 0.00 | 2492.32 |
| Anand, Niñia, L,19949 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Dominguez, Josue, R,15600 | 4590.40 | 0.00 | 0.00 | 2071.42 | 2518.98 |
| Hu, Jenny, A,16634 | 106.56 | 0.00 | 0.00 | 0.00 | 106.56 |
| Gutierrez, Kristine, G,25133 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Verhoff, Rob,11008 | 8106.31 | 3374.99 | 0.00 | 4731.32 | 0.00 |
| He, Susan, A,24467 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Luo, Melvin,24366 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Xu, Terry,24228 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Chandra, Jermaine, A,14299 | 5108.76 | 0.00 | 0.00 | 2071.42 | 3037.34 |
| Mr., Shen, Alan,24257 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Perez, Edgar, B,29318 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Gill, Joanna,26186 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Hernandez, Max,18192 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Munoz, Meredith,13957 | 5645.24 | 0.00 | 0.00 | 2071.42 | 3573.82 |
| Subram, Roy,21896 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Sai, Terrance,19106 | 64.95 | 0.00 | 0.00 | 21.98 | 42.97 |
| Thomas, Sydney,14322 | 5111.44 | 0.00 | 0.00 | 2049.10 | 3062.34 |
| Morcos, Hany,20821 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Wu, Laura,20615 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Shen, Barbara,22030 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Simmons, Jordyn,16494 | 5961.20 | 3578.27 | 0.00 | 0.00 | 2382.93 |
| Navarro, Dana, J,11125 | 79.69 | 0.00 | 0.00 | 47.42 | 32.27 |
| Goel, Ricardo, T,25961 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
Generated 2025-11-06 12:21:12.110 UTC