[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 38 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Vazquez, Craig,28117 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Gao, Louis,14666 | 5199.92 | 0.00 | 0.00 | 2049.10 | 3150.82 |
| Ramos, Kendra,24896 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Andersen, Kate,14237 | 90.25 | 0.00 | 0.00 | 0.00 | 90.25 |
| Yuan, Bethany, G,11030 | 6471.32 | 3399.99 | 0.00 | 0.00 | 3071.33 |
| Bryant, Madison, J,16481 | 194.91 | 0.00 | 0.00 | 0.00 | 194.91 |
| Dominguez, Raquel, A,27470 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Sai, Ruth, D,24461 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Madan, Ronald,25828 | 1873.58 | 0.00 | 699.10 | 0.00 | 1174.48 |
| Dominguez, Sabrina, M,28116 | 617.47 | 0.00 | 0.00 | 0.00 | 617.47 |
| Vazquez, Ross,11148 | 126.24 | 0.00 | 0.00 | 0.00 | 126.24 |
| Chander, Gregory, J,22001 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Flores, Brianna,27706 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Yang, Rosa,18713 | 237.26 | 0.00 | 0.00 | 0.00 | 237.26 |
| Xie, Cristina, C,17050 | 4496.23 | 0.00 | 3578.27 | 0.00 | 917.96 |
| Becker, Leonard, C,22405 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| She, Bridget, M,19557 | 5358.24 | 0.00 | 3578.27 | 0.00 | 1779.97 |
| Yang, Stacey,14215 | 5665.89 | 0.00 | 0.00 | 2049.10 | 3616.79 |
| Shen, Priscilla, A,28215 | 589.96 | 0.00 | 0.00 | 0.00 | 589.96 |
| Rodriguez, Cynthia, E,22206 | 201.28 | 0.00 | 0.00 | 0.00 | 201.28 |
| Wang, Laura, L,26146 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Sharma, Jodi, N,18260 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Liu, Bianca, K,11458 | 31.92 | 0.00 | 0.00 | 0.00 | 31.92 |
| Xu, Kara, E,22212 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
Generated 2025-12-22 02:28:36.051 UTC