[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 88 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Schmidt, Kaitlin,13628 | 191.25 | 0.00 | 0.00 | 0.00 | 191.25 |
| Xu, Arturo,13619 | 6808.10 | 0.00 | 0.00 | 2049.10 | 4759.00 |
| Navarro, Albert, L,21561 | 4947.78 | 0.00 | 2443.35 | 0.00 | 2504.43 |
| Sharma, Clayton, D,12240 | 3964.98 | 0.00 | 3399.99 | 0.00 | 564.99 |
| Chande, Jaclyn, S,18698 | 5314.25 | 0.00 | 3578.27 | 1735.98 | 0.00 |
| Subram, Evelyn, S,21257 | 4144.34 | 0.00 | 2443.35 | 0.00 | 1700.99 |
| Chander, Alejandro, M,24455 | 75.47 | 0.00 | 0.00 | 0.00 | 75.47 |
| Romero, Max, C,29316 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Lin, Clarence,29069 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
| Shen, Cedric,22209 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Stone, Mitchell,25013 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Becker, Leonard, C,22405 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Raman, Brandy,12247 | 77.27 | 0.00 | 0.00 | 49.99 | 27.28 |
| Serrano, Stacy,24613 | 2148.21 | 0.00 | 0.00 | 2148.21 | 0.00 |
| Chapman, Patricia,12037 | 7107.10 | 0.00 | 3374.99 | 0.00 | 3732.11 |
| Garcia, Monica, D,20267 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Nelson, Julia, L,11102 | 102.91 | 0.00 | 0.00 | 0.00 | 102.91 |
| Prasad, Preston, C,20812 | 4127.25 | 0.00 | 3578.27 | 0.00 | 548.98 |
| Yang, Darryl, K,21571 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Schmidt, Deanna, H,25936 | 1248.08 | 0.00 | 699.10 | 0.00 | 548.98 |
| Liu, Warren,15014 | 3860.87 | 0.00 | 0.00 | 2071.42 | 1789.45 |
| Raji, Omar,15643 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Gonzalez, George, L,11942 | 4792.29 | 0.00 | 3399.99 | 614.96 | 777.34 |
| Shan, Tasha,15192 | 4384.08 | 0.00 | 0.00 | 2049.10 | 2334.98 |
| Lin, Alan,22973 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Lal, Karla,25219 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Munoz, Shannon, S,29122 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Mehta, Ann, M,14518 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
Generated 2025-12-23 07:46:58.202 UTC