[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 1469 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Nara, Michele, R,22842 | 86.46 | 0.00 | 0.00 | 0.00 | 86.46 |
| Chander, Omar, W,17241 | 4382.75 | 3578.27 | 0.00 | 0.00 | 804.48 |
| Navarro, Marc,16346 | 37.55 | 0.00 | 0.00 | 0.00 | 37.55 |
| Shan, Jaime,22020 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Gao, Gilbert,24165 | 3046.84 | 0.00 | 0.00 | 2443.35 | 603.49 |
| Lal, Shaun, H,17056 | 4417.75 | 3578.27 | 0.00 | 0.00 | 839.48 |
| Lal, Carl, C,28950 | 44.98 | 0.00 | 0.00 | 0.00 | 44.98 |
| Kumar, Bridget,15802 | 4444.07 | 0.00 | 0.00 | 2049.10 | 2394.97 |
| Shan, Elijah, L,26795 | 1992.46 | 0.00 | 0.00 | 782.99 | 1209.47 |
| Wilson, Jasmine,17329 | 6021.62 | 3578.27 | 0.00 | 0.00 | 2443.35 |
| Weber, Chelsea,29191 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Zheng, Alan,11050 | 5007.30 | 3374.99 | 0.00 | 854.97 | 777.34 |
| Shan, Colleen, D,15150 | 4379.08 | 0.00 | 0.00 | 2049.10 | 2329.98 |
| Rubio, Randall, M,17286 | 6029.57 | 3578.27 | 0.00 | 0.00 | 2451.30 |
| Blanco, Cheryl,13524 | 4528.75 | 0.00 | 0.00 | 2071.42 | 2457.33 |
| Yuan, Karla, W,13629 | 6889.11 | 0.00 | 0.00 | 2049.10 | 4840.01 |
| Shan, Shaun,24274 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Torres, Dwayne, R,17288 | 4426.24 | 0.00 | 3578.27 | 0.00 | 847.97 |
| He, Aimee, A,11093 | 8180.00 | 0.00 | 3399.99 | 2360.95 | 2419.06 |
| Xie, Alicia,26427 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Evans, Mason,15439 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Mr., Shakespear, Paul, J.,17326 | 4467.76 | 0.00 | 3578.27 | 0.00 | 889.49 |
| Zhou, Cedric,17514 | 4142.23 | 0.00 | 3578.27 | 563.96 | 0.00 |
| Gill, Joanna,26186 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Alvarez, Kristy,15588 | 4486.07 | 0.00 | 0.00 | 2049.10 | 2436.97 |
| Butler, Jason,17510 | 4369.74 | 0.00 | 3578.27 | 0.00 | 791.47 |
| Chander, Damien,11080 | 8204.02 | 0.00 | 3374.99 | 2359.98 | 2469.05 |
| Cai, Roger, A,13002 | 294.94 | 0.00 | 0.00 | 167.99 | 126.95 |
| Kapoor, Cesar, J,24302 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Raman, Levi,29114 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Navarro, Bruce, D,17353 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
Generated 2025-11-04 03:47:04.401 UTC