[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 57 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Simpson, Tara, K,28107 | 810.32 | 0.00 | 0.00 | 0.00 | 810.32 |
| Sharma, Sharon, T,25294 | 1882.57 | 699.10 | 0.00 | 0.00 | 1183.47 |
| Suri, Adriana,18463 | 4726.04 | 0.00 | 3578.27 | 0.00 | 1147.77 |
| Nara, Dale, L,21226 | 4659.80 | 0.00 | 0.00 | 2181.56 | 2478.24 |
| Zhao, Glenn, C,14221 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Goel, Chad,28219 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Yang, Roger, A,28108 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Griffin, Olivia,21208 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Coleman, Dalton, M,23412 | 3586.81 | 0.00 | 0.00 | 2443.35 | 1143.46 |
| Sun, Jenny, L,12253 | 4066.93 | 0.00 | 3399.99 | 0.00 | 666.94 |
| She, Rosa,18931 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Mehta, Pamela,22005 | 135.46 | 0.00 | 0.00 | 0.00 | 135.46 |
| Navarro, Sheila, L,21889 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Shen, Grant, B,26763 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Raje, Christy,23100 | 3007.12 | 0.00 | 0.00 | 2443.35 | 563.77 |
| Green, Kyle,28328 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ms., Sandidge, Mary, R.,14016 | 121.06 | 0.00 | 0.00 | 0.00 | 121.06 |
| Stone, Mitchell,25013 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Raji, Karl,29103 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Serrano, Pedro,26189 | 1926.45 | 0.00 | 0.00 | 782.99 | 1143.46 |
| Alonso, Diana, L,24590 | 3911.53 | 0.00 | 0.00 | 2181.56 | 1729.97 |
| Li, Warren, R,29185 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Thomas, Sydney,14322 | 5111.44 | 0.00 | 0.00 | 2049.10 | 3062.34 |
| Martinez, Lydia,24169 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Subram, Ann, M,18693 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Andersen, Nina,18338 | 6124.58 | 0.00 | 3578.27 | 0.00 | 2546.31 |
| Nara, Cassie,13642 | 79.97 | 0.00 | 0.00 | 0.00 | 79.97 |
| Blanco, Sheila, I,17724 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
Generated 2025-12-21 13:34:53.566 UTC