[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 500 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Zheng, Jeffery, W,15030 | 3786.39 | 0.00 | 0.00 | 2071.42 | 1714.97 |
| Dominguez, Robyn, P,23305 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Martinez, Frederick,11991 | 8128.02 | 0.00 | 3374.99 | 0.00 | 4753.03 |
| Xu, Lacey, S,17913 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Zhang, Louis, K,20227 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Garcia, Harold, K,14087 | 341.97 | 0.00 | 0.00 | 159.00 | 182.97 |
| Perez, Rachael, D,26762 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 |
| Dominguez, Diana, L,29292 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Xu, Julie,18301 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Ferrier, Mathew,23426 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Anand, Bradley,19626 | 39.46 | 0.00 | 0.00 | 0.00 | 39.46 |
| Shan, Connor, C,18901 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Ramos, Juan,13633 | 6803.14 | 0.00 | 0.00 | 2049.10 | 4754.04 |
| Gill, Hector, M,26187 | 1932.46 | 0.00 | 0.00 | 782.99 | 1149.47 |
| Lu, Suzanne, K,16712 | 4417.75 | 3578.27 | 0.00 | 0.00 | 839.48 |
| Torres, Naomi, J,14061 | 82.26 | 0.00 | 0.00 | 32.27 | 49.99 |
| Pal, Dustin,26588 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Gao, Rafael, R,18733 | 24.27 | 0.00 | 0.00 | 2.29 | 21.98 |
| Kapoor, Denise, M,18725 | 6044.59 | 0.00 | 3578.27 | 2466.32 | 0.00 |
| Li, Stacey,14064 | 5694.21 | 0.00 | 0.00 | 2071.42 | 3622.79 |
| Nelson, Julia, L,11102 | 102.91 | 0.00 | 0.00 | 0.00 | 102.91 |
| Moreno, Naomi, C,15601 | 4429.57 | 0.00 | 0.00 | 2049.10 | 2380.47 |
| Ruiz, Francis, D,21381 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Liu, Cedric,12677 | 6785.47 | 0.00 | 2071.42 | 0.00 | 4714.05 |
| Martinez, Ann,12009 | 8195.50 | 0.00 | 3399.99 | 0.00 | 4795.51 |
| Green, Kyle,28328 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gao, Rosa,26034 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Raji, Derek, D,19591 | 63.42 | 0.00 | 0.00 | 0.00 | 63.42 |
| Guo, Susan, A,26543 | 14.23 | 0.00 | 0.00 | 14.23 | 0.00 |
| Zheng, Claudia,18691 | 6070.59 | 0.00 | 3578.27 | 2492.32 | 0.00 |
| Saunders, Micheal,17513 | 4260.24 | 0.00 | 3578.27 | 681.97 | 0.00 |
| Zeng, Micah, A,25561 | 1288.06 | 0.00 | 699.10 | 0.00 | 588.96 |
| Sanz, Ricky,18251 | 6035.60 | 0.00 | 3578.27 | 2457.33 | 0.00 |
| Suarez, Ruben,14031 | 6964.42 | 0.00 | 0.00 | 2049.10 | 4915.32 |
| Fernandez, Cassandra, C,14134 | 3835.07 | 0.00 | 0.00 | 2049.10 | 1785.97 |
| Bailey, Savannah, J,23428 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Chandra, Dominique, H,26765 | 78.98 | 0.00 | 0.00 | 78.98 | 0.00 |
| Suri, Cesar,17512 | 4170.54 | 0.00 | 3578.27 | 592.27 | 0.00 |
| Xu, Clayton, W,25001 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Nara, Grant,12995 | 6850.58 | 0.00 | 0.00 | 2049.10 | 4801.48 |
| Sara, Adriana, M,15146 | 161.94 | 0.00 | 0.00 | 0.00 | 161.94 |
| Rai, Colleen,28933 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Zheng, Laura,16701 | 4426.74 | 3578.27 | 0.00 | 848.47 | 0.00 |
| Ross, Arianna, E,26774 | 1331.97 | 0.00 | 0.00 | 1331.97 | 0.00 |
| Lin, Jaclyn,28721 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Nara, Devon, C,21964 | 103.49 | 0.00 | 0.00 | 0.00 | 103.49 |
| Liang, Ronnie,24584 | 30.48 | 0.00 | 0.00 | 0.00 | 30.48 |
| Rubio, Larry,14223 | 155.94 | 0.00 | 0.00 | 0.00 | 155.94 |
| Suri, Pedro,26422 | 1980.96 | 0.00 | 0.00 | 782.99 | 1197.97 |
| Zhang, Ronnie,16656 | 5930.23 | 3578.27 | 0.00 | 0.00 | 2351.96 |
| Cooper, Alex, L,27362 | 1407.45 | 0.00 | 0.00 | 782.99 | 624.46 |
| Alonso, Natasha, L,25009 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Romero, Walter, A,25020 | 1549.42 | 0.00 | 0.00 | 1000.44 | 548.98 |
| Romero, Jimmy,27704 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Liu, Erica, A,21564 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Lin, Wesley,21407 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Hernandez, Ebony, S,23574 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Romero, Ruben,16632 | 68.87 | 0.00 | 0.00 | 0.00 | 68.87 |
| Ramos, Lance, S,28949 | 2473.05 | 0.00 | 0.00 | 2473.05 | 0.00 |
| Andersen, Karl, M,23105 | 3361.53 | 0.00 | 0.00 | 3361.53 | 0.00 |
| Garcia, Virginia, C,24599 | 26.97 | 0.00 | 0.00 | 0.00 | 26.97 |
| Kumar, Derek, M,15135 | 4381.39 | 0.00 | 0.00 | 2071.42 | 2309.97 |
Generated 2025-11-03 09:02:33.594 UTC