[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 251 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Serrano, Gloria, G,21556 | 4930.68 | 0.00 | 0.00 | 2443.35 | 2487.33 |
| Zhang, Barbara,16338 | 169.43 | 0.00 | 0.00 | 0.00 | 169.43 |
| Rubio, Beth,20240 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Huang, Jake,19589 | 95.26 | 0.00 | 0.00 | 0.00 | 95.26 |
| Suarez, Lawrence, C,26131 | 1952.45 | 0.00 | 0.00 | 782.99 | 1169.46 |
| Suarez, Pedro, A,24611 | 2219.42 | 0.00 | 0.00 | 1000.44 | 1218.98 |
| Chander, Bethany, K,11446 | 8237.01 | 0.00 | 3399.99 | 2354.98 | 2482.04 |
| Gill, Alberto, P,17733 | 4758.24 | 0.00 | 3578.27 | 0.00 | 1179.97 |
| Chen, Autumn, I,21408 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Jimenez, Latasha, E,13121 | 121.25 | 0.00 | 0.00 | 0.00 | 121.25 |
| Butler, Jose,29064 | 815.81 | 0.00 | 0.00 | 0.00 | 815.81 |
| Raji, Bradley, E,17925 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Patterson, Melissa, E,12668 | 6839.46 | 0.00 | 0.00 | 2071.42 | 4768.04 |
| Lu, Christy,17062 | 91.26 | 0.00 | 0.00 | 0.00 | 91.26 |
| King, Jesse, J,14665 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Gomez, Armando, S,21175 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Fernandez, Holly, M,12675 | 6812.77 | 0.00 | 0.00 | 2071.42 | 4741.35 |
| Wu, Mandy,18309 | 6090.59 | 0.00 | 3578.27 | 0.00 | 2512.32 |
| Perez, Ivan, S,23408 | 4218.82 | 0.00 | 0.00 | 2443.35 | 1775.47 |
| Xu, Arturo,13619 | 6808.10 | 0.00 | 0.00 | 2049.10 | 4759.00 |
| Rodriguez, Wyatt, D,21218 | 4661.50 | 0.00 | 0.00 | 2181.56 | 2479.94 |
| Chen, Randy,13004 | 190.27 | 0.00 | 0.00 | 0.00 | 190.27 |
| Li, Cedric,27364 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Ramos, Mathew, E,28961 | 2478.04 | 0.00 | 0.00 | 0.00 | 2478.04 |
| Zhang, Jenny, H,24609 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Chande, Raul, L,21176 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Gao, Rafael, R,18733 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Pal, Drew,11902 | 63.04 | 0.00 | 0.00 | 0.00 | 63.04 |
| Perry, Gavin, M,12578 | 2668.08 | 0.00 | 0.00 | 2049.10 | 618.98 |
| Johnson, Emma, M,15136 | 62.27 | 0.00 | 0.00 | 0.00 | 62.27 |
| Lin, Laura, L,11462 | 8116.33 | 0.00 | 3374.99 | 0.00 | 4741.34 |
| Vazquez, Jimmy, D,12348 | 6906.09 | 0.00 | 0.00 | 2049.10 | 4856.99 |
| She, Cedric, R,12580 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Raman, Dominique, D,13023 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Nara, Johnny, R,18489 | 6081.10 | 0.00 | 3578.27 | 0.00 | 2502.83 |
| Smith, Allen,14072 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Malhotra, Pedro,21559 | 4900.68 | 0.00 | 0.00 | 2443.35 | 2457.33 |
| Guo, Jake, P,19969 | 98.45 | 0.00 | 0.00 | 0.00 | 98.45 |
| Raman, Ronald, M,17077 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Carlson, Jay,20264 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Madan, Michele, A,12676 | 6859.46 | 0.00 | 0.00 | 2071.42 | 4788.04 |
| Stone, Brenda, J,12697 | 296.19 | 0.00 | 0.00 | 0.00 | 296.19 |
| Nara, Derek, A,26139 | 34.47 | 0.00 | 0.00 | 0.00 | 34.47 |
| Shan, Bethany, L,13973 | 5185.68 | 0.00 | 0.00 | 2071.42 | 3114.26 |
| Zhou, Laura, D,12683 | 6801.45 | 0.00 | 0.00 | 2071.42 | 4730.03 |
| Prasad, Cesar,23411 | 3577.82 | 0.00 | 0.00 | 2443.35 | 1134.47 |
| Ramos, Adrienne, L,28216 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Jiménez, Orlando, M,21283 | 124.94 | 0.00 | 0.00 | 0.00 | 124.94 |
| Madan, Jarrod, C,21555 | 4715.49 | 0.00 | 0.00 | 2181.56 | 2533.93 |
| Li, Aimee,17915 | 4792.73 | 0.00 | 3578.27 | 0.00 | 1214.46 |
| Campbell, Seth,18716 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Ramos, Juan,13633 | 6803.14 | 0.00 | 0.00 | 2049.10 | 4754.04 |
| Martinez, Sarah, S,12670 | 6785.13 | 0.00 | 0.00 | 2049.10 | 4736.03 |
| Gao, Erica, R,19087 | 47.20 | 0.00 | 0.00 | 0.00 | 47.20 |
| Torres, Kari,18486 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Kumar, Kurt, L,27360 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Chow, Christy, M,12681 | 6784.13 | 0.00 | 0.00 | 2049.10 | 4735.03 |
| Lin, Suzanne,29287 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| White, Kayla,26424 | 79.47 | 0.00 | 0.00 | 0.00 | 79.47 |
| Carlson, Orlando, J,11893 | 8123.03 | 0.00 | 3374.99 | 0.00 | 4748.04 |
Generated 2026-01-04 05:20:29.288 UTC