[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 31 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ramos, Stacy, D,18261 | 85.96 | 0.00 | 0.00 | 0.00 | 85.96 |
| Garcia, Preston, M,24602 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Huang, Willie, C,28133 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Ramos, Tanya, R,14045 | 6804.13 | 0.00 | 0.00 | 2049.10 | 4755.03 |
| Ramos, Juan,13633 | 6803.14 | 0.00 | 0.00 | 2049.10 | 4754.04 |
| Moreno, Latasha, R,18735 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Cai, Gilbert, J,18256 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Pal, Derek,24591 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Prasad, Candace, S,22148 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Alexander, Austin,26673 | 1505.76 | 0.00 | 0.00 | 782.99 | 722.77 |
| Sun, Brittney,11365 | 5024.79 | 0.00 | 3374.99 | 0.00 | 1649.80 |
| Ramos, Paula, W,21376 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rubio, Nelson,26433 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Gonzalez, Edgar, A,15648 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Kumar, Derek, M,15135 | 4381.39 | 0.00 | 0.00 | 2071.42 | 2309.97 |
| Serrano, Dwayne,16695 | 76.15 | 0.00 | 0.00 | 0.00 | 76.15 |
| Mr., Rovira Diez, Pablo,21190 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Perez, Cesar, L,27982 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Sanders, Kaylee, C,20221 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Nara, Dustin, M,17910 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Gomez, Ricky,18737 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Moore, Michael,17247 | 4432.72 | 0.00 | 3578.27 | 0.00 | 854.45 |
| Patel, Ruben, I,19765 | 4132.24 | 0.00 | 3578.27 | 553.97 | 0.00 |
| Lopez, Kristopher, L,21560 | 4702.39 | 0.00 | 0.00 | 2181.56 | 2520.83 |
| Zhu, Sandra, V,15732 | 4376.40 | 0.00 | 0.00 | 2071.42 | 2304.98 |
| Gutierrez, Carrie, C,28139 | 127.28 | 0.00 | 0.00 | 0.00 | 127.28 |
| She, Maurice,22917 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rodriguez, Evelyn,13117 | 6831.42 | 0.00 | 0.00 | 2049.10 | 4782.32 |
| Henderson, Paige, C,17325 | 54.94 | 0.00 | 0.00 | 0.00 | 54.94 |
| Li, David, A,21894 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
Generated 2025-12-24 09:06:29.697 UTC