[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 3500 > < TAKE 1000
37 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sun, Karen, C,28208 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Garcia, Jermaine,21566 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Johnson, Sydney,19571 | 90.95 | 0.00 | 0.00 | 0.00 | 90.95 |
| Carlson, Kristy,28217 | 2408.29 | 0.00 | 0.00 | 0.00 | 2408.29 |
| Zeng, Heather, E,18287 | 72.16 | 0.00 | 0.00 | 0.00 | 72.16 |
| Ruiz, Marvin, R,18796 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Ferrier, Mathew,23426 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Kumar, Kate,17321 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Yuan, Franklin,24594 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Raje, Dale, H,27746 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Jai, Alison,23657 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Nara, Derek, A,26139 | 34.47 | 0.00 | 0.00 | 0.00 | 34.47 |
| Wang, Arturo, A,27720 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Torres, Danielle, G,22947 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| White, Kayla,26424 | 79.47 | 0.00 | 0.00 | 0.00 | 79.47 |
| Fernandez, Ronald,28939 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Martinez, Douglas, C,22841 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Srini, Cindy, E,26026 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Chandra, Monica, H,18898 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Nelson, Kaitlyn, J,24276 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Zhao, Randy, J,27874 | 1288.31 | 0.00 | 0.00 | 0.00 | 1288.31 |
| Andersen, Nicolas, A,27594 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Liu, Clayton, L,21373 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Martin, Meghan, B,26773 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Chandra, Troy,21406 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Johnsen, Eddie,28935 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Parker, Gabriel,19606 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Liu, Ronnie,26130 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Malhotra, Arthur, E,25267 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Hernandez, Marvin, A,23077 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Suri, Evelyn, A,21223 | 56.98 | 0.00 | 0.00 | 0.00 | 56.98 |
| Zhu, Amy, W,26664 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Wu, Margaret,28928 | 2473.05 | 0.00 | 0.00 | 0.00 | 2473.05 |
| Yang, Leah, J,15186 | 59.48 | 0.00 | 0.00 | 0.00 | 59.48 |
| Raji, Karl,29103 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Garcia, Edgar, A,17729 | 110.46 | 0.00 | 0.00 | 0.00 | 110.46 |
| _SUM | 9051988.22 | 305781.60 | 2436953.50 | 2256921.46 | 4052331.66 |
Generated 2025-12-22 00:25:57.630 UTC