[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 421 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Shan, Yolanda,12702 | 6911.10 | 0.00 | 0.00 | 2049.10 | 4862.00 |
| Shen, Nichole,12999 | 6840.46 | 0.00 | 0.00 | 2071.42 | 4769.04 |
| Barnes, Taylor,14279 | 5137.71 | 0.00 | 0.00 | 2049.10 | 3088.61 |
| Sun, Louis, E,16182 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Raje, Tara, F,28483 | 765.32 | 0.00 | 0.00 | 0.00 | 765.32 |
| Lal, Alisha, C,21872 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Sanchez, George, M,12680 | 6880.10 | 0.00 | 0.00 | 2049.10 | 4831.00 |
| Torres, Jacquelyn, P,27464 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Ortega, Shannon,26375 | 1971.45 | 0.00 | 0.00 | 782.99 | 1188.46 |
| Luo, Kenneth, S,15211 | 2910.90 | 0.00 | 0.00 | 2071.42 | 839.48 |
| Kumar, Bridget,15802 | 4444.07 | 0.00 | 0.00 | 2049.10 | 2394.97 |
| Zheng, Alan,11050 | 5007.30 | 0.00 | 3374.99 | 0.00 | 1632.31 |
| Gonzalez, Roy, M,13040 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Lopez, Toni, K,25140 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Cai, Roger, A,13002 | 294.94 | 0.00 | 0.00 | 0.00 | 294.94 |
| Lal, Leonard,26160 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Zimmerman, Candice, J,26754 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Green, Devin, J,26440 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Ruiz, Natasha,21994 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Patel, Whitney, F,24468 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Perez, Carmen, C,13139 | 6854.45 | 0.00 | 0.00 | 2071.42 | 4783.03 |
| Ferrier, Jenny,21955 | 4900.68 | 0.00 | 0.00 | 2443.35 | 2457.33 |
| Deng, Jaime, R,21968 | 4722.88 | 0.00 | 0.00 | 2181.56 | 2541.32 |
| Ramos, Danny,23121 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Alvarez, Mathew, L,17494 | 111.96 | 0.00 | 0.00 | 0.00 | 111.96 |
| Martinez, Anna, J,12994 | 6855.44 | 0.00 | 0.00 | 2071.42 | 4784.02 |
| Sai, Rachael,11912 | 8095.32 | 0.00 | 3374.99 | 0.00 | 4720.33 |
| Xu, Grant, M,19266 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Vazquez, Jésus,26665 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Gao, Wesley,12346 | 6864.46 | 0.00 | 2071.42 | 0.00 | 4793.04 |
Generated 2026-01-04 04:59:24.415 UTC