[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 72 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Liang, Dennis,14034 | 104.24 | 0.00 | 0.00 | 0.00 | 104.24 |
| Shan, Dylan,19677 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Sanz, Kellie,16708 | 4406.74 | 0.00 | 3578.27 | 0.00 | 828.47 |
| Carlson, Frank,11896 | 8117.97 | 0.00 | 3374.99 | 0.00 | 4742.98 |
| Li, Lisa, J,24600 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Dominguez, Gina, L,20213 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Ye, Marshall, R,26559 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Luo, Barbara,27978 | 29.48 | 0.00 | 0.00 | 29.48 | 0.00 |
| Yuan, Kelsey, D,13034 | 94.71 | 0.00 | 0.00 | 0.00 | 94.71 |
| Zhu, Lacey,24167 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Gonzalez, Veronica, C,23311 | 3337.04 | 0.00 | 0.00 | 3337.04 | 0.00 |
| Rogers, Seth, R,14318 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Xu, Alison,14227 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Henderson, Cassidy,21228 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Adams, Devin,21871 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Chavez, Jodi, A,18909 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Zhang, Lacey, L,14127 | 3809.57 | 0.00 | 0.00 | 2049.10 | 1760.47 |
| Ashe, Ebony, E,16612 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Wilson, Edward, L,26562 | 1925.41 | 0.00 | 0.00 | 782.99 | 1142.42 |
| Alonso, Lance, I,14057 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Suarez, Briana, A,15266 | 2935.37 | 0.00 | 0.00 | 2071.42 | 863.95 |
| Zeng, Heather, E,18287 | 72.16 | 0.00 | 0.00 | 0.00 | 72.16 |
| Chen, Crystal, M,26566 | 2016.95 | 0.00 | 0.00 | 782.99 | 1233.96 |
| Romero, Ricky,21361 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Gutierrez, Jaime, A,25227 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Rai, Bradley,19100 | 79.26 | 0.00 | 0.00 | 0.00 | 79.26 |
| She, Kathryn, I,26443 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Hernandez, Raquel, W,13997 | 4586.35 | 0.00 | 0.00 | 2071.42 | 2514.93 |
Generated 2025-12-22 00:22:54.612 UTC