[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 1562 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Vazquez, Carolyn,23650 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Suarez, Lance, C,17230 | 83.98 | 0.00 | 0.00 | 53.99 | 29.99 |
| Raje, Wayne, A,21372 | 74.96 | 0.00 | 0.00 | 0.00 | 74.96 |
| Luo, Roger, J,18728 | 56.71 | 0.00 | 0.00 | 0.00 | 56.71 |
| Gonzalez, Roy, M,13040 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Lopez, Toni, K,25140 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Alonso, Billy, M,22852 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Malhotra, Meredith,29314 | 564.48 | 0.00 | 0.00 | 0.00 | 564.48 |
| Pal, Wayne,19764 | 12.94 | 0.00 | 0.00 | 12.94 | 0.00 |
| Goel, Shawna, L,29332 | 165.28 | 0.00 | 0.00 | 165.28 | 0.00 |
| Madan, Joe,29300 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Vazquez, Latasha,21952 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Ramos, Rodney, C,14059 | 106.75 | 0.00 | 0.00 | 74.48 | 32.27 |
| Lopez, Brandy, S,18199 | 99.94 | 0.00 | 0.00 | 0.00 | 99.94 |
| Chandra, Troy,21406 | 74.98 | 0.00 | 0.00 | 74.98 | 0.00 |
| Lopez, Summer,12036 | 69.55 | 0.00 | 0.00 | 2.29 | 67.26 |
| Diaz, Danny, C,18190 | 30.97 | 0.00 | 0.00 | 8.99 | 21.98 |
| Zhao, Alisha, M,21988 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Hernandez, Joe,15154 | 84.98 | 0.00 | 0.00 | 84.98 | 0.00 |
| Vazquez, Erika, S,22974 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Subram, Kari,12682 | 227.96 | 0.00 | 0.00 | 0.00 | 227.96 |
| Xu, Lindsey,15583 | 66.26 | 0.00 | 0.00 | 0.00 | 66.26 |
| Ye, Amy,11073 | 191.90 | 0.00 | 0.00 | 103.96 | 87.94 |
| Malhotra, Tina, C,27584 | 599.47 | 0.00 | 0.00 | 0.00 | 599.47 |
| Chander, Tonya,15794 | 113.97 | 0.00 | 0.00 | 88.98 | 24.99 |
| Gao, Trisha, A,28953 | 2462.55 | 0.00 | 0.00 | 2462.55 | 0.00 |
| Luo, Colin, L,21210 | 39.99 | 0.00 | 0.00 | 39.99 | 0.00 |
| Suri, Evelyn, A,21223 | 56.98 | 0.00 | 0.00 | 56.98 | 0.00 |
| Hernandez, Isaac,25813 | 26.97 | 0.00 | 0.00 | 26.97 | 0.00 |
| Bailey, Allison,21377 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Reed, Kimberly, D,17311 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Yang, Alan, L,15605 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Deng, Colleen, S,27728 | 67.49 | 0.00 | 0.00 | 0.00 | 67.49 |
| Carlson, Marie,29311 | 603.96 | 0.00 | 0.00 | 0.00 | 603.96 |
| Ramos, Cindy, G,11361 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Kapoor, Brett, L,22147 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Ramos, Paula, W,21376 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gao, Jake, A,19955 | 173.45 | 0.00 | 0.00 | 0.00 | 173.45 |
| Parker, Mason, W,25923 | 6.28 | 0.00 | 0.00 | 6.28 | 0.00 |
| James, Evan, V,11119 | 85.22 | 0.00 | 0.00 | 35.23 | 49.99 |
| Sun, Clayton,28533 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Zhao, Ernest, C,18700 | 5328.23 | 0.00 | 3578.27 | 1749.96 | 0.00 |
| Bradley, Diane, A,15140 | 62.27 | 0.00 | 0.00 | 27.28 | 34.99 |
| Rodriguez, Ruben,12589 | 2665.06 | 0.00 | 2049.10 | 0.00 | 615.96 |
| Stone, Denise,11032 | 6525.56 | 3374.99 | 0.00 | 0.00 | 3150.57 |
| Kapoor, Jay, F,21956 | 4632.86 | 0.00 | 2181.56 | 0.00 | 2451.30 |
| Gutierrez, Hector,26423 | 2001.97 | 0.00 | 0.00 | 782.99 | 1218.98 |
| Ortega, Renee,18447 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Chande, Michele, C,13078 | 6850.46 | 0.00 | 0.00 | 2071.42 | 4779.04 |
| Lopez, Edgar, O,17346 | 81.46 | 0.00 | 0.00 | 0.00 | 81.46 |
| Guo, Leah, R,19562 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Ortega, Anne,13011 | 6819.11 | 0.00 | 0.00 | 2049.10 | 4770.01 |
| Zhang, Willie, T,16023 | 166.89 | 0.00 | 0.00 | 0.00 | 166.89 |
| Alvarez, Marc, B,18221 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Perez, Toni,15581 | 113.94 | 0.00 | 0.00 | 0.00 | 113.94 |
| Martin, Ethan, M,13998 | 245.25 | 0.00 | 0.00 | 97.97 | 147.28 |
| Huang, Jorge,17291 | 86.27 | 0.00 | 0.00 | 53.99 | 32.28 |
| Vazquez, Neil, K,28719 | 2384.07 | 0.00 | 0.00 | 2384.07 | 0.00 |
| Suarez, Daisy, A,18288 | 6093.20 | 0.00 | 3578.27 | 2514.93 | 0.00 |
| She, Rafael, I,20152 | 4142.75 | 0.00 | 3578.27 | 564.48 | 0.00 |
| Vazquez, Diane, D,11987 | 279.23 | 0.00 | 0.00 | 0.00 | 279.23 |
| Xie, Wayne, S,18302 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
Generated 2025-11-04 03:25:26.372 UTC