[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 94 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Yuan, Tamara, E,21166 | 4909.67 | 0.00 | 2443.35 | 0.00 | 2466.32 |
| Dominguez, Stacy, S,19105 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Fernandez, Kristi,19585 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Anand, Rafael,29306 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| He, Jon, L,14262 | 5652.54 | 0.00 | 0.00 | 2071.42 | 3581.12 |
| Suarez, Carolyn, B,18222 | 6044.59 | 0.00 | 3578.27 | 2466.32 | 0.00 |
| Zhu, Gilbert,11921 | 63.24 | 0.00 | 0.00 | 0.00 | 63.24 |
| Shen, Michele,27985 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Garcia, Preston, M,24602 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Kumar, Kate,17321 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Torres, Jacquelyn, P,27464 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| She, Katie, B,11965 | 118.74 | 0.00 | 0.00 | 0.00 | 118.74 |
| Shan, Kristin,23416 | 3598.83 | 0.00 | 0.00 | 2443.35 | 1155.48 |
| Nara, Edwin, R,11097 | 8099.03 | 0.00 | 3374.99 | 0.00 | 4724.04 |
| Alvarez, Carrie, W,23410 | 4016.53 | 0.00 | 0.00 | 2181.56 | 1834.97 |
| Kumar, Barbara, N,27499 | 1331.97 | 0.00 | 0.00 | 782.99 | 548.98 |
| Nelson, Fernando, G,25564 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Miller, Dalton, D,13130 | 6797.15 | 0.00 | 0.00 | 2049.10 | 4748.05 |
| Xu, Grant, M,19266 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Xu, Tara,19592 | 5377.23 | 0.00 | 3578.27 | 0.00 | 1798.96 |
| Goldstein, Dustin,12337 | 8137.01 | 0.00 | 3399.99 | 0.00 | 4737.02 |
| Evans, Adam, H,25820 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Perez, Geoffrey, P,21000 | 2721.55 | 0.00 | 2181.56 | 0.00 | 539.99 |
| Raji, Omar,15643 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Munoz, Jimmy, E,21573 | 61.97 | 0.00 | 0.00 | 0.00 | 61.97 |
| Vance, Meredith, B,20983 | 4178.73 | 0.00 | 3578.27 | 0.00 | 600.46 |
| Mehta, Deanna, P,17280 | 6089.59 | 0.00 | 3578.27 | 0.00 | 2511.32 |
| Zheng, Randy, B,22574 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
Generated 2025-12-23 07:47:32.457 UTC