[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 23 < SKIP 188 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Mr., Schmidt, Irving, W,12669 | 6791.10 | 0.00 | 0.00 | 2049.10 | 4742.00 |
| Xu, Calvin, E,27583 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Becker, Leonard, C,22405 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Rubio, Walter, R,25912 | 63.47 | 0.00 | 0.00 | 0.00 | 63.47 |
| Cai, Warren,24918 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Moreno, Robin,19563 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| She, Brittney, M,22942 | 3971.53 | 0.00 | 0.00 | 2181.56 | 1789.97 |
| Pal, Kara,24916 | 2169.90 | 0.00 | 0.00 | 1000.44 | 1169.46 |
| Carter, Amber, E,16679 | 106.56 | 0.00 | 0.00 | 0.00 | 106.56 |
| Li, Lacey,17515 | 4143.26 | 0.00 | 3578.27 | 0.00 | 564.99 |
| Zhu, Vincent, E,24899 | 105.45 | 0.00 | 0.00 | 0.00 | 105.45 |
| Williams, Anna, R,17504 | 4362.74 | 0.00 | 3578.27 | 0.00 | 784.47 |
| Xu, Colin, C,29461 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Navarro, Melinda,11454 | 8089.04 | 0.00 | 3374.99 | 2294.99 | 2419.06 |
| Zheng, Christy,17069 | 4426.74 | 0.00 | 3578.27 | 0.00 | 848.47 |
| Jai, Carl,27597 | 564.21 | 0.00 | 0.00 | 0.00 | 564.21 |
| Ma, Louis,21879 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| She, Latoya, A,11750 | 8148.02 | 0.00 | 3399.99 | 0.00 | 4748.03 |
| Srini, Douglas, M,16733 | 35.26 | 0.00 | 0.00 | 0.00 | 35.26 |
| Sai, Holly, V,26769 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Serrano, Audrey,18337 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Patel, Pamela, G,27875 | 1268.84 | 0.00 | 0.00 | 0.00 | 1268.84 |
| Patterson, Melissa, E,12668 | 6839.46 | 0.00 | 0.00 | 2071.42 | 4768.04 |
| Pal, Omar,27714 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Lal, Mario, T,23345 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rodriguez, Evelyn,13117 | 6831.42 | 0.00 | 0.00 | 2049.10 | 4782.32 |
| Liu, Kelli, A,24480 | 4175.61 | 0.00 | 0.00 | 2443.35 | 1732.26 |
| Lopez, Ross,18443 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Sai, Barry,22907 | 4169.33 | 0.00 | 0.00 | 2443.35 | 1725.98 |
| She, Christine,16184 | 78.20 | 0.00 | 0.00 | 0.00 | 78.20 |
| Romero, Rodney,14521 | 117.96 | 0.00 | 0.00 | 0.00 | 117.96 |
| Coleman, Melanie, H,15639 | 34.57 | 0.00 | 0.00 | 0.00 | 34.57 |
| Xie, Mitchell, B,20993 | 4262.04 | 0.00 | 3578.27 | 0.00 | 683.77 |
| Goel, Chad,28219 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Alexander, Elizabeth,13089 | 6800.45 | 0.00 | 0.00 | 2071.42 | 4729.03 |
| Harris, Ian, W,14128 | 3836.38 | 0.00 | 0.00 | 2071.42 | 1764.96 |
| Shen, Cristina,26768 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Sullivan, Henry, L,20603 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Li, Marshall,12687 | 6805.47 | 0.00 | 0.00 | 2071.42 | 4734.05 |
| Rana, Pedro, F,13970 | 6843.14 | 0.00 | 0.00 | 2049.10 | 4794.04 |
| Lu, Curtis,11011 | 8133.04 | 3399.99 | 0.00 | 2294.99 | 2438.06 |
| Zhu, Dawn,26661 | 1912.47 | 0.00 | 0.00 | 782.99 | 1129.48 |
| Chandra, Jermaine, A,14299 | 5108.76 | 0.00 | 0.00 | 2071.42 | 3037.34 |
| Kumar, Tony, P,19783 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Lal, Karl, R,14264 | 5217.73 | 0.00 | 0.00 | 2822.76 | 2394.97 |
| Zheng, Jenny, R,11947 | 4747.30 | 0.00 | 3374.99 | 629.96 | 742.35 |
| Schmidt, Shane,17922 | 4821.72 | 0.00 | 3578.27 | 0.00 | 1243.45 |
| Diaz, Briana,13131 | 6737.15 | 0.00 | 0.00 | 2049.10 | 4688.05 |
| Nara, Edwin, R,11097 | 8099.03 | 0.00 | 3374.99 | 0.00 | 4724.04 |
| Vazquez, Latasha,21952 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Suarez, Renee, L,12703 | 6891.12 | 0.00 | 0.00 | 2049.10 | 4842.02 |
| Zhou, Jamie,17327 | 99.94 | 0.00 | 0.00 | 0.00 | 99.94 |
| Evans, Adam, H,25820 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Pal, Drew,11902 | 63.04 | 0.00 | 0.00 | 0.00 | 63.04 |
| Blanco, Lee, M,16660 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 |
| Chander, Bethany, K,11446 | 8237.01 | 0.00 | 3399.99 | 2354.98 | 2482.04 |
| Kapoor, Rachael, D,11911 | 62.46 | 0.00 | 0.00 | 0.00 | 62.46 |
| Sanz, Bruce,23117 | 3931.52 | 0.00 | 0.00 | 2181.56 | 1749.96 |
| Pal, Tasha,22853 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Gill, Jimmy,29098 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Mehta, Cindy, A,21943 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Ashe, Katie, Z,26770 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
Generated 2025-12-23 06:05:27.374 UTC