[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1000 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lu, Micah,22174 | 3007.83 | 0.00 | 0.00 | 2443.35 | 564.48 |
| Munoz, Gloria, L,19789 | 6058.21 | 0.00 | 3578.27 | 0.00 | 2479.94 |
| Patel, Veronica,13963 | 74.48 | 0.00 | 0.00 | 0.00 | 74.48 |
| Saunders, Ruben, G,27983 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Wood, Richard, W,24377 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Raji, Devon, D,21898 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Sara, Carmen, W,12582 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Chandra, Cynthia,22000 | 4663.79 | 0.00 | 0.00 | 2181.56 | 2482.23 |
| Suarez, Kristy,21984 | 4175.61 | 0.00 | 0.00 | 2443.35 | 1732.26 |
| Perez, Cesar, L,27982 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Lal, Dustin, A,16484 | 4175.53 | 3578.27 | 0.00 | 0.00 | 597.26 |
| Anand, Bradley,19626 | 39.46 | 0.00 | 0.00 | 0.00 | 39.46 |
| Rai, Bradley,19100 | 79.26 | 0.00 | 0.00 | 0.00 | 79.26 |
| Ruiz, Danny,24456 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Lin, Margaret, C,18306 | 87.77 | 0.00 | 0.00 | 0.00 | 87.77 |
| Alonso, Sheila,25054 | 103.48 | 0.00 | 0.00 | 0.00 | 103.48 |
| Ms., Sandidge, Mary, R.,14016 | 121.06 | 0.00 | 0.00 | 0.00 | 121.06 |
| Goel, Drew,17352 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Zimmerman, Tiffany, E,23325 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Guo, Brent, J,25945 | 1248.08 | 0.00 | 699.10 | 0.00 | 548.98 |
| Kelly, Zoe,23123 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sharma, Keith,15728 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Ye, Vincent,13013 | 256.24 | 0.00 | 0.00 | 0.00 | 256.24 |
| Prasad, George, C,15767 | 4379.09 | 0.00 | 0.00 | 2049.10 | 2329.99 |
| Raman, Cindy,16157 | 4391.41 | 0.00 | 0.00 | 2071.42 | 2319.99 |
| Suri, Cassandra, B,18717 | 87.21 | 0.00 | 0.00 | 0.00 | 87.21 |
| Serrano, Marvin, E,17316 | 97.45 | 0.00 | 0.00 | 0.00 | 97.45 |
| Shen, Grant, B,26763 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Gonzalez, Savannah, F,15644 | 3803.68 | 0.00 | 0.00 | 2071.42 | 1732.26 |
| Kumar, Tasha, M,20249 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Martin, Diane,13958 | 6838.64 | 0.00 | 0.00 | 2049.10 | 4789.54 |
| Goel, Bethany,27511 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Sanchez, Patrick, W,24382 | 143.78 | 0.00 | 0.00 | 0.00 | 143.78 |
| Collins, Logan, H,13983 | 180.41 | 0.00 | 0.00 | 0.00 | 180.41 |
| Ashe, Maurice,20430 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Rubio, Pedro, E,23098 | 2745.33 | 0.00 | 0.00 | 2181.56 | 563.77 |
| Pal, Jenny,15132 | 151.94 | 0.00 | 0.00 | 0.00 | 151.94 |
| Ramos, Alfredo,20456 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Arun, Brenda,13630 | 6824.73 | 0.00 | 0.00 | 2071.42 | 4753.31 |
| Raji, Andres, E,13955 | 6888.44 | 0.00 | 0.00 | 2071.42 | 4817.02 |
| Sharma, Mario, J,25928 | 1316.05 | 0.00 | 699.10 | 0.00 | 616.95 |
| Lu, Jaclyn, D,11047 | 6582.33 | 0.00 | 3399.99 | 0.00 | 3182.34 |
| Kumar, Rafael, L,19088 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Malhotra, Terrance, E,20223 | 187.38 | 0.00 | 0.00 | 0.00 | 187.38 |
| Nara, Melvin, E,27147 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Goel, Tommy,22909 | 3980.52 | 0.00 | 0.00 | 2181.56 | 1798.96 |
| Jenkins, Angela,15722 | 4448.57 | 0.00 | 0.00 | 2049.10 | 2399.47 |
| Nath, Jaime,11033 | 6495.29 | 0.00 | 3374.99 | 0.00 | 3120.30 |
| Ramos, Byron,14306 | 3653.23 | 0.00 | 0.00 | 2071.42 | 1581.81 |
| Navarro, Mallory,24365 | 3331.03 | 0.00 | 0.00 | 2181.56 | 1149.47 |
| Ramos, Robyn, O,15828 | 172.25 | 0.00 | 0.00 | 0.00 | 172.25 |
| Sara, Candace,21380 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Pal, Alvin, C,29319 | 2447.05 | 0.00 | 0.00 | 0.00 | 2447.05 |
| Zhou, Warren,19791 | 6058.21 | 0.00 | 3578.27 | 0.00 | 2479.94 |
| Goel, Bradley,15803 | 66.26 | 0.00 | 0.00 | 0.00 | 66.26 |
| Yuan, Roger,19622 | 61.75 | 0.00 | 0.00 | 0.00 | 61.75 |
| Sullivan, Carla, A,20611 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Alonso, Teresa,13138 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Cai, Vincent, L,11757 | 58.05 | 0.00 | 0.00 | 0.00 | 58.05 |
| Reed, Steven,24373 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
Generated 2026-01-04 05:38:54.090 UTC