[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 3500 > < TAKE 250 >
37 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Beck, Bonnie, A,29097 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Sai, Ivan, E,17300 | 94.22 | 0.00 | 0.00 | 0.00 | 94.22 |
| Vazquez, Carolyn,23650 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| West, Nathan,24370 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Li, Alejandro, A,27519 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Gill, Meredith, E,24268 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| 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 |
| Raman, Harold, F,28484 | 778.62 | 0.00 | 0.00 | 0.00 | 778.62 |
| Ramos, Paula, W,21376 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Zhao, Kelvin,25135 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Green, Kyle,28328 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Long, Mariah, C,16730 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Rodriguez, Toni, J,25251 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Alonso, Kathleen,21196 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Sara, Phillip, R,25116 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Luo, Alison, A,23527 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Sai, Monica, L,29055 | 765.32 | 0.00 | 0.00 | 0.00 | 765.32 |
| Sai, Jay, A,23427 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Romero, Ebony, A,27717 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Rana, Marco, K,24473 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Navarro, Lori,21182 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Ramos, Stacy, D,18261 | 85.96 | 0.00 | 0.00 | 0.00 | 85.96 |
| Goel, Katie, D,27708 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Martin, Jaime,28316 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Zheng, Randy, B,22574 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Nath, Melvin, D,27697 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Zeng, Krystal, A,25814 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Ross, Mya, E,27715 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Becker, Grant,21390 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Bell, Isabella,27698 | 1179.97 | 0.00 | 0.00 | 0.00 | 1179.97 |
| Hernandez, Danny,27146 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Vance, Kristi, T,28338 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Subram, Roy,21896 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Garcia, Stefanie, E,27743 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Kapoor, Jarrod,28930 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| _SUM | 9051988.22 | 897617.27 | 2294723.69 | 2701377.52 | 3158269.74 |
Generated 2024-09-20 11:57:42.060 UTC