[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 3500 > < TAKE 500 >
37 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Moore, Olivia, A,25231 | 2189.90 | 0.00 | 0.00 | 1000.44 | 1189.46 |
| Guo, Sandra,23664 | 3941.53 | 0.00 | 0.00 | 2181.56 | 1759.97 |
| Sara, Candace,21380 | 2735.53 | 0.00 | 2181.56 | 0.00 | 553.97 |
| Ramos, Mathew, E,28961 | 2478.04 | 0.00 | 0.00 | 0.00 | 2478.04 |
| Zhang, Amy,18307 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Sanz, Rodney,16926 | 44.95 | 0.00 | 0.00 | 0.00 | 44.95 |
| Price, Ian, J,22401 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Subram, Virginia,13036 | 2677.07 | 0.00 | 0.00 | 2049.10 | 627.97 |
| Anand, Rafael,29306 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Raman, Mayra, P,20990 | 4196.22 | 0.00 | 3578.27 | 0.00 | 617.95 |
| Long, Alexis,22580 | 3051.31 | 0.00 | 0.00 | 2443.35 | 607.96 |
| Mehta, Carolyn,28205 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Raman, Arthur,24001 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Yang, Heather,18275 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Zhu, Amy, W,26664 | 123.98 | 0.00 | 0.00 | 123.98 | 0.00 |
| Moreno, Tabitha,19959 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Lin, Rafael,14099 | 200.26 | 0.00 | 0.00 | 27.28 | 172.98 |
| Xu, Margaret, T,22404 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Henderson, Alexia, M,15717 | 4411.37 | 0.00 | 0.00 | 2049.10 | 2362.27 |
| Navarro, Kellie, I,21873 | 4661.50 | 0.00 | 2181.56 | 0.00 | 2479.94 |
| Navarro, Daisy,27514 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Anand, Alícia, J,29113 | 2453.04 | 0.00 | 0.00 | 0.00 | 2453.04 |
| Sai, Ronald, B,13643 | 6799.45 | 0.00 | 0.00 | 2071.42 | 4728.03 |
| Xu, Cedric,18198 | 4143.25 | 0.00 | 3578.27 | 0.00 | 564.98 |
| Nath, Keith,19617 | 61.75 | 0.00 | 0.00 | 0.00 | 61.75 |
| Gomez, Anne,13045 | 62.27 | 0.00 | 0.00 | 0.00 | 62.27 |
| Raji, Donna,24906 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Luo, Colin, L,21210 | 39.99 | 0.00 | 0.00 | 39.99 | 0.00 |
| Luo, Ashlee,23534 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Blanco, Philip, M,15603 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Patterson, Jordan,17238 | 147.48 | 0.00 | 0.00 | 53.99 | 93.49 |
| Zheng, Jaclyn, F,11910 | 8113.03 | 0.00 | 3374.99 | 2319.99 | 2418.05 |
| Munoz, Marvin,14680 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Lin, Heather, L,15718 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Lee, David, J,22199 | 4693.88 | 0.00 | 0.00 | 2181.56 | 2512.32 |
| Nara, Cristina, R,19792 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Ye, Steve,29087 | 810.32 | 0.00 | 0.00 | 0.00 | 810.32 |
Generated 2025-11-03 06:32:45.056 UTC