[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 250 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Zhu, Dawn,26661 | 1912.47 | 0.00 | 0.00 | 782.99 | 1129.48 |
| Garcia, Frederick, J,16489 | 112.73 | 0.00 | 0.00 | 0.00 | 112.73 |
| Moyer, Mario,23420 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Tang, Julie,26589 | 1966.46 | 0.00 | 0.00 | 782.99 | 1183.47 |
| Jimenez, Kathleen,26654 | 1346.76 | 0.00 | 0.00 | 1346.76 | 0.00 |
| Xu, Cara,23526 | 3563.84 | 0.00 | 0.00 | 2443.35 | 1120.49 |
| Kumar, Alejandro,14055 | 5177.40 | 0.00 | 0.00 | 2049.10 | 3128.30 |
| Russell, Ashley,12000 | 8183.00 | 0.00 | 3399.99 | 0.00 | 4783.01 |
| Lin, Mandy, C,25035 | 2183.91 | 0.00 | 0.00 | 1000.44 | 1183.47 |
| Yang, Ronnie,23524 | 3598.83 | 0.00 | 0.00 | 2443.35 | 1155.48 |
| Gonzales, Alexis,23521 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Hernandez, Raquel, W,13997 | 4586.35 | 0.00 | 0.00 | 2071.42 | 2514.93 |
| Adams, Amber,26746 | 2001.45 | 0.00 | 0.00 | 782.99 | 1218.46 |
| Lopez, Manuel, M,14050 | 5650.24 | 0.00 | 0.00 | 3295.26 | 2354.98 |
| Navarro, Javier,14131 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Zheng, Curtis, S,23645 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Romero, Latasha,14220 | 5696.19 | 0.00 | 0.00 | 2071.42 | 3624.77 |
| She, Stacey,26748 | 1357.97 | 0.00 | 0.00 | 782.99 | 574.98 |
| Zhang, Lacey, L,14127 | 3809.57 | 0.00 | 0.00 | 2049.10 | 1760.47 |
| Clark, Madison, A,14062 | 5647.92 | 0.00 | 0.00 | 2049.10 | 3598.82 |
| Harris, Ian, W,14128 | 3836.38 | 0.00 | 0.00 | 2071.42 | 1764.96 |
| Munoz, Robyn,14214 | 5759.87 | 0.00 | 0.00 | 2049.10 | 3710.77 |
| Nath, Keith,19617 | 61.75 | 0.00 | 0.00 | 0.00 | 61.75 |
| Ross, Brandon,14132 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Kumar, Jenny, C,23429 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Munoz, Darren,23539 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Alexander, Austin,26673 | 1505.76 | 0.00 | 0.00 | 782.99 | 722.77 |
| Suarez, Ruben,14031 | 6964.42 | 0.00 | 0.00 | 2049.10 | 4915.32 |
| Martin, Justin,23542 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Yang, Randy, E,24000 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Gonzalez, Shane, Y,14125 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
Generated 2025-12-23 05:38:11.052 UTC