[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 274 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Wang, Roger, P,24605 | 3627.81 | 0.00 | 0.00 | 3627.81 | 0.00 |
| Ms., Rousey, Linda, R.,21279 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Arun, Nancy, C,21169 | 4647.88 | 0.00 | 0.00 | 2181.56 | 2466.32 |
| Zeng, Ramon,27979 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Navarro, Renee,15793 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Deng, Gilbert, C,15765 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Ferrier, Edwin, J,15757 | 4366.41 | 0.00 | 0.00 | 2071.42 | 2294.99 |
| Perez, Virginia, A,27494 | 1952.45 | 0.00 | 0.00 | 782.99 | 1169.46 |
| Hill, Luis,27500 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Zhu, Alisha, G,18239 | 6030.61 | 0.00 | 3578.27 | 2452.34 | 0.00 |
| Gutierrez, Adrienne,18906 | 4217.22 | 0.00 | 3578.27 | 638.95 | 0.00 |
| Stone, Denise,11032 | 6525.56 | 0.00 | 3374.99 | 0.00 | 3150.57 |
| Gill, Latasha, M,25713 | 1288.06 | 0.00 | 699.10 | 0.00 | 588.96 |
| Kapoor, Jay, F,21956 | 4632.86 | 0.00 | 0.00 | 2181.56 | 2451.30 |
| Alonso, Jerome, H,27977 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Shan, Johnny,11999 | 7043.27 | 0.00 | 3399.99 | 0.00 | 3643.28 |
| Srini, Douglas, M,16733 | 35.26 | 0.00 | 0.00 | 0.00 | 35.26 |
| Huang, Mandy,18266 | 72.26 | 0.00 | 0.00 | 0.00 | 72.26 |
| Suri, Barry,15253 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Zhao, Shannon,19807 | 35.47 | 0.00 | 0.00 | 0.00 | 35.47 |
| Rodriguez, Sergio, D,15239 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Nath, Kara, S,21177 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Carson, Kelvin, A,11995 | 8249.01 | 0.00 | 3399.99 | 0.00 | 4849.02 |
| Anand, Kara,11989 | 8139.53 | 0.00 | 3374.99 | 0.00 | 4764.54 |
| Blanco, Alberto, R,27867 | 2443.55 | 0.00 | 0.00 | 0.00 | 2443.55 |
| Adams, Sydney,27367 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Nath, Latoya, A,27582 | 561.92 | 0.00 | 0.00 | 0.00 | 561.92 |
| Yang, Connor,17735 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
Generated 2026-01-04 05:39:40.804 UTC