[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1497 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Liang, Jenny, S,27351 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Johnsen, Jerry,26670 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| She, Sharon, F,22017 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Subram, Roy,21896 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Guo, Jake, P,19969 | 98.45 | 0.00 | 0.00 | 67.97 | 30.48 |
| Gomez, Brandi, M,14675 | 187.98 | 0.00 | 0.00 | 0.00 | 187.98 |
| Morgan, Melissa, M,20222 | 74.45 | 0.00 | 0.00 | 0.00 | 74.45 |
| Raje, Kelli, A,28136 | 2384.07 | 0.00 | 0.00 | 2384.07 | 0.00 |
| Gao, Rosa,26034 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Martinez, Clifford,23087 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Huang, Wesley,29320 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Sanchez, Levi, A,27745 | 617.47 | 0.00 | 0.00 | 617.47 | 0.00 |
| Xu, Wesley, K,29182 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Gomez, Marc, J,21880 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Brown, Kaitlyn,29120 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Ms., Seidel, Birgit,16621 | 73.86 | 0.00 | 0.00 | 0.00 | 73.86 |
| Raje, Darrell,20252 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Zeng, Krystal, A,25814 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Lopez, Isaac,27692 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Lopez, Clifford, E,27709 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Adams, Savannah,23536 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Hayes, Christian, R,28537 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Nara, Tonya, C,17251 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Sanz, Jimmy,25810 | 114.46 | 0.00 | 0.00 | 0.00 | 114.46 |
| Shen, Karla, E,22925 | 134.93 | 0.00 | 0.00 | 0.00 | 134.93 |
| Alonso, Lance, I,14057 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Sanz, Arthur,27688 | 166.28 | 0.00 | 0.00 | 166.28 | 0.00 |
| Butler, Austin, W,18293 | 74.24 | 0.00 | 0.00 | 74.24 | 0.00 |
| Lu, Christy,17062 | 91.26 | 0.00 | 0.00 | 53.99 | 37.27 |
| Black, Priscilla,15766 | 62.27 | 0.00 | 0.00 | 34.99 | 27.28 |
| Gutierrez, Frank, G,22846 | 74.98 | 0.00 | 0.00 | 74.98 | 0.00 |
| Ward, Shelby,26132 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Zhou, Rafael, A,24494 | 9.99 | 0.00 | 0.00 | 9.99 | 0.00 |
| Navarro, Dana, J,11125 | 79.69 | 0.00 | 0.00 | 7.95 | 71.74 |
| Yang, Hunter, E,20237 | 21.49 | 0.00 | 0.00 | 21.49 | 0.00 |
| Munoz, Gary, D,20230 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Navarro, Janet, J,28320 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Washington, Julian, C,23330 | 31.97 | 0.00 | 0.00 | 0.00 | 31.97 |
| Parker, Mason, W,25923 | 6.28 | 0.00 | 0.00 | 6.28 | 0.00 |
| Vazquez, Ross,11148 | 126.24 | 0.00 | 0.00 | 0.00 | 126.24 |
| Prasad, Clifford,15604 | 66.75 | 0.00 | 0.00 | 0.00 | 66.75 |
| Liang, Steve,14317 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Yang, Louis, J,23013 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Subram, Rebekah,26030 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Martin, Anne, V,25034 | 2164.91 | 0.00 | 0.00 | 1000.44 | 1164.47 |
| Nara, Michele, R,22842 | 86.46 | 0.00 | 0.00 | 0.00 | 86.46 |
| Andersen, Brendan,15121 | 5202.73 | 0.00 | 0.00 | 2071.42 | 3131.31 |
| Lal, Warren, B,25246 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Ramos, Marie, A,14308 | 5140.40 | 0.00 | 0.00 | 2049.10 | 3091.30 |
| Mehta, Brandy,22839 | 39.25 | 0.00 | 0.00 | 0.00 | 39.25 |
| She, Jerry, C,14277 | 5196.74 | 0.00 | 0.00 | 2071.42 | 3125.32 |
| Ruiz, Leslie, J,26032 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Madan, Michele, A,12676 | 6859.46 | 0.00 | 0.00 | 2071.42 | 4788.04 |
| Diaz, Dana, C,12361 | 217.46 | 0.00 | 0.00 | 0.00 | 217.46 |
| Zeng, Suzanne,17918 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Ruiz, Kristine, J,24607 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Munoz, Felicia, D,20406 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Ye, Franklin, L,13952 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Blanco, Monique, W,14103 | 3612.22 | 0.00 | 0.00 | 2071.42 | 1540.80 |
| Goel, Marshall, M,27691 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Tang, Terrence, R,17303 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Zhu, Colin,19973 | 83.44 | 0.00 | 0.00 | 0.00 | 83.44 |
Generated 2025-12-24 06:24:35.113 UTC