[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 125 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gomez, Naomi, E,24300 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Raji, Omar,15643 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Gonzalez, Kaylee, L,21895 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Sharma, Kelli,26672 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Weber, Cory,16739 | 81.26 | 0.00 | 0.00 | 31.27 | 49.99 |
| Lu, Crystal, A,15145 | 4368.70 | 0.00 | 0.00 | 2071.42 | 2297.28 |
| Chande, Ricardo, L,24471 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Subram, Arthur, E,27350 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Zhang, Tiffany, R,17318 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Kumar, Keith, M,25224 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Zhao, Kristen,16930 | 7.95 | 0.00 | 0.00 | 0.00 | 7.95 |
| Nath, Ricardo, C,12039 | 8213.00 | 0.00 | 3374.99 | 0.00 | 4838.01 |
| Powell, Grace, B,29194 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Hill, Mackenzie,19576 | 6058.21 | 0.00 | 3578.27 | 0.00 | 2479.94 |
| Lal, Carl, C,28950 | 44.98 | 0.00 | 0.00 | 0.00 | 44.98 |
| Liu, Alejandro, R,19555 | 6110.60 | 0.00 | 3578.27 | 0.00 | 2532.33 |
| She, Latoya, A,11750 | 8148.02 | 0.00 | 3399.99 | 0.00 | 4748.03 |
| Stone, Colin, K,12673 | 6768.14 | 0.00 | 2049.10 | 0.00 | 4719.04 |
| Blanco, Marc,24908 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Raji, Tasha, T,17057 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Carlson, Krista,28209 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Sullivan, Kaitlin,16919 | 70.95 | 0.00 | 0.00 | 0.00 | 70.95 |
| Butler, Gavin, D,22949 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Suri, Gerald,13617 | 116.92 | 0.00 | 0.00 | 0.00 | 116.92 |
| Chapman, Jodi, L,22966 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Xie, Kurt, A,14344 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
| Sharma, Bonnie, R,25562 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Sanchez, Candace, L,21567 | 4973.28 | 0.00 | 2443.35 | 0.00 | 2529.93 |
| Richardson, Abigail, S,14236 | 5710.23 | 0.00 | 0.00 | 2071.42 | 3638.81 |
| Shan, Darrell, J,27345 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Lopez, Chelsea,24369 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Generated 2025-11-04 05:44:34.067 UTC