[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SKIP 500 < SKIP 15 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| 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 |
| Alvarez, Linda,14047 | 5643.54 | 0.00 | 0.00 | 3321.26 | 2322.28 |
| Henderson, Isabella, L,21981 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Xu, Cara,23526 | 3563.84 | 0.00 | 0.00 | 2443.35 | 1120.49 |
| 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 |
| 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 |
| Thompson, Michael, M,26148 | 1917.46 | 0.00 | 0.00 | 782.99 | 1134.47 |
| Patel, Summer, G,26753 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Navarro, Javier,14131 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Kumar, Alejandro,14055 | 5177.40 | 0.00 | 0.00 | 2049.10 | 3128.30 |
| Zheng, Curtis, S,23645 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Kumar, Ricardo, K,14133 | 3764.07 | 0.00 | 0.00 | 2049.10 | 1714.97 |
| 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 |
| Harris, Ian, W,14128 | 3836.38 | 0.00 | 0.00 | 2071.42 | 1764.96 |
| 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 |
| Alonso, Ricky, S,14070 | 5618.93 | 0.00 | 0.00 | 2049.10 | 3569.83 |
| 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 |
| Clark, Madison, A,14062 | 5647.92 | 0.00 | 0.00 | 2049.10 | 3598.82 |
| Hernandez, Ebony, S,23574 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Gonzalez, Shane, Y,14125 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Gao, Jorge,23573 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Raje, Misty, A,23544 | 3971.01 | 0.00 | 0.00 | 2181.56 | 1789.45 |
Generated 2025-12-23 12:25:46.282 UTC