[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 500 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Shen, Russell, M,11150 | 192.42 | 0.00 | 0.00 | 0.00 | 192.42 |
| Navarro, Lori,21182 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Hernandez, Audrey,18290 | 84.96 | 0.00 | 0.00 | 8.99 | 75.97 |
| Malhotra, Kristina,25031 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Mehta, Cindy, A,21943 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Goel, Carly, C,12989 | 6817.12 | 0.00 | 0.00 | 2049.10 | 4768.02 |
| Gonzalez, Tabitha, A,26136 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Srini, Deanna,15182 | 4391.41 | 0.00 | 0.00 | 2071.42 | 2319.99 |
| Liu, Suzanne,19594 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Romero, Max, C,29316 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Moore, Devin, J,16167 | 102.57 | 0.00 | 0.00 | 0.00 | 102.57 |
| Romero, Rodney,14521 | 117.96 | 0.00 | 0.00 | 0.00 | 117.96 |
| Vazquez, Carolyn,23650 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ferrier, Leslie, M,28535 | 2433.04 | 0.00 | 0.00 | 2433.04 | 0.00 |
| Goel, Mario, J,12360 | 6750.48 | 0.00 | 2071.42 | 0.00 | 4679.06 |
| Wood, Maria,12667 | 6813.12 | 0.00 | 2049.10 | 0.00 | 4764.02 |
| Sanchez, Manuel,15126 | 86.26 | 0.00 | 0.00 | 58.98 | 27.28 |
| She, Brittney, M,22942 | 3971.53 | 0.00 | 0.00 | 2181.56 | 1789.97 |
| Chande, Latoya, M,23309 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Cai, Bianca, D,22173 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Martinez, Frederick,11991 | 8128.02 | 0.00 | 3374.99 | 0.00 | 4753.03 |
| Chander, Gregory, J,22001 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Luo, Nichole, A,29296 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Wilson, Edward, L,26562 | 1925.41 | 0.00 | 0.00 | 782.99 | 1142.42 |
| Moreno, Janet, L,15592 | 59.98 | 0.00 | 0.00 | 24.99 | 34.99 |
| Fernandez, Holly, M,12675 | 6812.77 | 0.00 | 2071.42 | 0.00 | 4741.35 |
| Moreno, Kathleen, C,15234 | 59.98 | 0.00 | 0.00 | 34.99 | 24.99 |
| Goldstein, Brendan,13518 | 2638.36 | 0.00 | 0.00 | 2049.10 | 589.26 |
| Mehta, Carla, L,21563 | 39.99 | 0.00 | 0.00 | 39.99 | 0.00 |
| Pal, Willie, J,11755 | 46.25 | 0.00 | 0.00 | 0.00 | 46.25 |
Generated 2025-11-04 11:48:54.303 UTC