[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 28 > < TAKE 48 >
48 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Dominguez, Kristi, M,13644 | 6864.46 | 0.00 | 0.00 | 2071.42 | 4793.04 |
| Yang, Jon, V,11000 | 8248.99 | 3399.99 | 0.00 | 2341.97 | 2507.03 |
| Garcia, Charles, M,20250 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Chen, Cedric, R,17065 | 4417.75 | 0.00 | 3578.27 | 0.00 | 839.48 |
| Gomez, Naomi, E,24300 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Alexander, David,15783 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Wilson, Jasmine,17329 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Shen, Roger, G,14011 | 3831.89 | 0.00 | 0.00 | 2071.42 | 1760.47 |
| Raji, Christy,15584 | 62.27 | 0.00 | 0.00 | 0.00 | 62.27 |
| Ferrier, Jenny,21955 | 4900.68 | 0.00 | 0.00 | 2443.35 | 2457.33 |
| Kumar, Lacey,13960 | 6871.74 | 0.00 | 0.00 | 2071.42 | 4800.32 |
| Raje, Dale, H,27746 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Long, Alexis,22580 | 3051.31 | 0.00 | 0.00 | 2443.35 | 607.96 |
| Vazquez, Marie,21899 | 4663.79 | 0.00 | 0.00 | 2181.56 | 2482.23 |
| Suarez, Dana, M,23541 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Shen, Bonnie,21405 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Gomez, Armando, S,21175 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Nath, Latoya, A,27582 | 561.92 | 0.00 | 0.00 | 0.00 | 561.92 |
| Rai, Clayton, K,20446 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Sai, Terrance,19106 | 64.95 | 0.00 | 0.00 | 0.00 | 64.95 |
| Zeng, Erica,26924 | 1350.75 | 0.00 | 0.00 | 782.99 | 567.76 |
| Ye, Jenny,25036 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Yang, Colin, J,20612 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Xu, Casey, J,13158 | 221.91 | 0.00 | 0.00 | 64.97 | 156.94 |
| Long, Angelica, C,28206 | 2398.05 | 0.00 | 0.00 | 2398.05 | 0.00 |
| Gill, Billy, L,16700 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Baker, Luke, J,22952 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gao, Erica, R,19087 | 47.20 | 0.00 | 0.00 | 47.20 | 0.00 |
| Zhang, Willie, T,16023 | 166.89 | 0.00 | 0.00 | 0.00 | 166.89 |
| Fernandez, Allen,19596 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Ashe, Ebony, E,16612 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Lal, Katie, E,18210 | 6044.59 | 0.00 | 3578.27 | 2466.32 | 0.00 |
| Hu, Alvin, E,11449 | 8130.32 | 0.00 | 3374.99 | 2362.27 | 2393.06 |
| Sai, Summer, S,22855 | 70.96 | 0.00 | 0.00 | 0.00 | 70.96 |
| Nath, Dawn, L,11759 | 8054.05 | 0.00 | 3374.99 | 0.00 | 4679.06 |
| Pal, Alison,13042 | 84.47 | 0.00 | 0.00 | 0.00 | 84.47 |
| Vance, Meredith, B,20983 | 4178.73 | 0.00 | 3578.27 | 0.00 | 600.46 |
| Kumar, Louis, A,18203 | 4172.25 | 0.00 | 3578.27 | 0.00 | 593.98 |
| Luo, Shaun,27864 | 2447.05 | 0.00 | 0.00 | 0.00 | 2447.05 |
| Serrano, Joanna, J,26663 | 1976.94 | 0.00 | 0.00 | 782.99 | 1193.95 |
| Shen, Jodi, A,22028 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Ma, Lacey, K,18723 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
| Wu, Brittney,23418 | 3400.02 | 0.00 | 0.00 | 2181.56 | 1218.46 |
| Vazquez, Lawrence,19632 | 56.98 | 0.00 | 0.00 | 0.00 | 56.98 |
| Hu, Cara,20608 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Rana, Carla, K,19593 | 5306.54 | 0.00 | 3578.27 | 0.00 | 1728.27 |
| Tang, Louis, A,18292 | 39.25 | 0.00 | 0.00 | 0.00 | 39.25 |
| Sara, Ross,24367 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
Generated 2025-12-22 04:10:03.860 UTC