[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 89 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gill, Leslie,14670 | 2919.89 | 0.00 | 0.00 | 2071.42 | 848.47 |
| Shan, Bethany, L,13973 | 5185.68 | 0.00 | 0.00 | 2071.42 | 3114.26 |
| Baker, Luke, J,22952 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Li, Luis, K,20251 | 59.47 | 0.00 | 0.00 | 0.00 | 59.47 |
| Garcia, Preston, M,24602 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Arthur, Kristi, W,16675 | 4385.03 | 3578.27 | 0.00 | 0.00 | 806.76 |
| Lopez, Jay, A,19965 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Ruiz, Kari, L,12695 | 192.97 | 0.00 | 0.00 | 0.00 | 192.97 |
| Li, Barbara,15788 | 4443.38 | 0.00 | 0.00 | 2071.42 | 2371.96 |
| Alvarez, Erik, M,14311 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Ma, Autumn,20994 | 4191.72 | 0.00 | 3578.27 | 0.00 | 613.45 |
| Carlson, Frank,11896 | 8117.97 | 0.00 | 3374.99 | 0.00 | 4742.98 |
| Sanchez, Joel,18468 | 5333.25 | 0.00 | 3578.27 | 1754.98 | 0.00 |
| Cai, Candice,26747 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Martinez, Meredith, M,19095 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Kumar, Wayne,17502 | 6070.59 | 0.00 | 3578.27 | 0.00 | 2492.32 |
| Morgan, Mackenzie, E,16162 | 185.04 | 0.00 | 0.00 | 0.00 | 185.04 |
| Hu, Crystal,27980 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Chandra, Ann,18209 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Tang, Leonard, L,28109 | 778.62 | 0.00 | 0.00 | 0.00 | 778.62 |
| Huang, Mandy,18266 | 72.26 | 0.00 | 0.00 | 0.00 | 72.26 |
| Ramos, Byron,14306 | 3653.23 | 0.00 | 0.00 | 2071.42 | 1581.81 |
| Sun, Dennis, K,24481 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Hu, Alvin, E,11449 | 8130.32 | 0.00 | 3374.99 | 2362.27 | 2393.06 |
| Yuan, Sharon,12008 | 55.76 | 0.00 | 0.00 | 0.00 | 55.76 |
| Rodriguez, Cynthia, E,22206 | 201.28 | 0.00 | 0.00 | 0.00 | 201.28 |
| Hernandez, Clinton,29462 | 854.82 | 0.00 | 0.00 | 0.00 | 854.82 |
| Hu, Glenn, R,24897 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Xu, Colleen, C,18325 | 108.85 | 0.00 | 0.00 | 0.00 | 108.85 |
| Lal, Dustin, A,16484 | 4175.53 | 3578.27 | 0.00 | 0.00 | 597.26 |
| Chen, Jaclyn, C,22847 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Suri, Adriana,18463 | 4726.04 | 0.00 | 3578.27 | 0.00 | 1147.77 |
| Gomez, Carrie,22965 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Cai, Amy,24920 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Zhu, Jenny, J,17078 | 186.94 | 0.00 | 0.00 | 123.96 | 62.98 |
| Moreno, Bruce, F,26652 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Jai, Calvin, S,22918 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Lopez, Deanna, L,25119 | 2148.21 | 0.00 | 0.00 | 1000.44 | 1147.77 |
| Cooper, Katherine, R,14314 | 122.95 | 0.00 | 0.00 | 0.00 | 122.95 |
| Lu, Crystal, A,15145 | 4368.70 | 0.00 | 0.00 | 2071.42 | 2297.28 |
| Alonso, Naomi,15830 | 2680.38 | 0.00 | 0.00 | 2071.42 | 608.96 |
| She, Jeffery, M,27149 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Lopez, Kari,15235 | 190.89 | 0.00 | 0.00 | 0.00 | 190.89 |
| Andersen, Jaime,25268 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Liu, Ronnie,26130 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Romero, Ruben,16632 | 68.87 | 0.00 | 0.00 | 0.00 | 68.87 |
| Zhang, Willie, T,16023 | 166.89 | 0.00 | 0.00 | 0.00 | 166.89 |
| Suri, Carmen, E,24250 | 2738.49 | 0.00 | 0.00 | 2181.56 | 556.93 |
| Lopez, Mayra, E,27356 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Deng, Colleen, S,27728 | 67.49 | 0.00 | 0.00 | 0.00 | 67.49 |
| Chande, Raul, L,21176 | 35.00 | 0.00 | 0.00 | 35.00 | 0.00 |
| Raje, Derek,12574 | 2626.39 | 0.00 | 2071.42 | 0.00 | 554.97 |
| Torres, Bailey,18259 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Nara, Yolanda,29080 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Shan, Colleen, D,15150 | 4379.08 | 0.00 | 0.00 | 2049.10 | 2329.98 |
| Rai, Willie,14673 | 5117.75 | 0.00 | 0.00 | 2071.42 | 3046.33 |
Generated 2025-12-22 04:58:57.189 UTC