[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 87 > < TAKE 32 >
32 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Raje, Grant, S,24162 | 3004.83 | 0.00 | 0.00 | 2443.35 | 561.48 |
| Gao, Krystal,25821 | 1879.07 | 0.00 | 699.10 | 0.00 | 1179.97 |
| Andersen, Calvin,22920 | 91.95 | 0.00 | 0.00 | 0.00 | 91.95 |
| Pal, Terry, H,25824 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Lal, Donna,25812 | 113.97 | 0.00 | 0.00 | 0.00 | 113.97 |
| Raman, Candace, M,11766 | 8280.48 | 0.00 | 3399.99 | 0.00 | 4880.49 |
| Tang, Willie, A,25939 | 1264.57 | 0.00 | 699.10 | 0.00 | 565.47 |
| Shan, Peter,24280 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Suarez, Alfredo,19601 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Rodriguez, Donald, L,28351 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Ruiz, Bruce, W,16171 | 103.86 | 0.00 | 0.00 | 0.00 | 103.86 |
| Barnes, Taylor,14279 | 5137.71 | 0.00 | 0.00 | 2049.10 | 3088.61 |
| Zhang, Dawn, A,14222 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Yuan, Bradley,17920 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Munoz, Felicia, D,20406 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Garcia, Preston, M,24602 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Sai, Ruth, D,24461 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Martin, Justin,23542 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Yang, Crystal, A,23665 | 4207.32 | 0.00 | 0.00 | 2443.35 | 1763.97 |
| He, Ramon,26919 | 1350.75 | 0.00 | 0.00 | 782.99 | 567.76 |
| Yang, Warren, F,17908 | 35.72 | 0.00 | 0.00 | 0.00 | 35.72 |
| Johnsen, Ross,19618 | 119.45 | 0.00 | 0.00 | 0.00 | 119.45 |
| Muñoz, Ruben, L,11451 | 8249.49 | 0.00 | 3399.99 | 0.00 | 4849.50 |
| Reed, Steven,24373 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Ma, Jessie,29092 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Rubio, Kristy,12243 | 3914.98 | 0.00 | 3374.99 | 0.00 | 539.99 |
| Martin, Marc, J,11039 | 6636.58 | 0.00 | 3399.99 | 0.00 | 3236.59 |
| Zeng, Heather, E,18287 | 72.16 | 0.00 | 0.00 | 0.00 | 72.16 |
| Munoz, Jacquelyn,29115 | 2407.04 | 0.00 | 0.00 | 0.00 | 2407.04 |
| Chande, Melvin, R,11460 | 8137.52 | 0.00 | 3399.99 | 0.00 | 4737.53 |
| Garcia, Donald,18929 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Raheem, Bethany, L,21965 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
Generated 2026-01-04 05:37:53.525 UTC