[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 63 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Chande, Katrina, L,19968 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Zhao, Marshall, C,22033 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Andersen, Gilbert, T,27353 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Hernandez, Javier, A,16156 | 4344.09 | 0.00 | 0.00 | 2049.10 | 2294.99 |
| Sanz, Lance,22573 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Rivera, Jada,21970 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Rodriguez, Douglas, W,19652 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Carlson, Shannon, C,11009 | 8091.33 | 3374.99 | 0.00 | 2297.28 | 2419.06 |
| Lee, Dalton, J,16931 | 4767.73 | 3578.27 | 0.00 | 0.00 | 1189.46 |
| Liu, Erica, A,21564 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Zhao, Randy, J,27874 | 1288.31 | 0.00 | 0.00 | 1288.31 | 0.00 |
| Ruiz, Bruce, W,16171 | 103.86 | 0.00 | 0.00 | 0.00 | 103.86 |
| Patel, Pamela, G,27875 | 1268.84 | 0.00 | 0.00 | 1268.84 | 0.00 |
| Lal, Kelsey, T,24913 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| He, Kelli, A,28872 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Madan, Erick, W,14212 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Zhang, Damien, C,26758 | 1322.98 | 0.00 | 0.00 | 1322.98 | 0.00 |
| Henderson, Xavier, K,12993 | 96.25 | 0.00 | 0.00 | 0.00 | 96.25 |
| Martinez, Brett,23532 | 3337.04 | 0.00 | 0.00 | 3337.04 | 0.00 |
| Beck, Derek,17322 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Clark, Madison, A,14062 | 5647.92 | 0.00 | 0.00 | 3272.94 | 2374.98 |
| Ramos, Meredith, A,23307 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Diaz, Megan, A,24303 | 4207.32 | 0.00 | 0.00 | 2443.35 | 1763.97 |
| Arun, Barry,27700 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Coleman, Paige, L,15263 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Ramos, Michele, J,19574 | 96.74 | 0.00 | 0.00 | 0.00 | 96.74 |
| Jenkins, Amanda,15214 | 4490.88 | 0.00 | 0.00 | 2071.42 | 2419.46 |
| Liang, Louis, M,12706 | 6851.41 | 0.00 | 0.00 | 2071.42 | 4779.99 |
| Chen, Crystal, M,26566 | 2016.95 | 0.00 | 0.00 | 782.99 | 1233.96 |
| Moreno, Felicia, A,12987 | 6759.47 | 0.00 | 0.00 | 2071.42 | 4688.05 |
| Huang, Valerie, J,26745 | 1932.46 | 0.00 | 0.00 | 782.99 | 1149.47 |
| Martin, Larry,18254 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Subram, Francisco, A,21897 | 4909.67 | 0.00 | 0.00 | 2443.35 | 2466.32 |
| Srini, Veronica,11996 | 7058.70 | 0.00 | 3374.99 | 1291.77 | 2391.94 |
| Chander, Carl,14315 | 109.71 | 0.00 | 0.00 | 0.00 | 109.71 |
| Zhao, Ernest, C,18700 | 5328.23 | 0.00 | 3578.27 | 1749.96 | 0.00 |
| Zhou, Brent,15434 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Bradley, Diane, A,15140 | 62.27 | 0.00 | 0.00 | 27.28 | 34.99 |
| Liu, Clayton, L,21373 | 15.23 | 0.00 | 0.00 | 15.23 | 0.00 |
| Becker, Latoya, W,17330 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Gutierrez, Jay, C,13155 | 226.95 | 0.00 | 0.00 | 84.47 | 142.48 |
| Sara, Geoffrey,26188 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Guo, Clarence,20265 | 32.28 | 0.00 | 0.00 | 32.28 | 0.00 |
| Dominguez, Walter,12576 | 2653.07 | 0.00 | 2049.10 | 0.00 | 603.97 |
| Raje, Karla,28936 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Mr., Schmidt, Irving, W,12669 | 6791.10 | 0.00 | 2049.10 | 0.00 | 4742.00 |
| Madan, Raymond, W,20819 | 4181.76 | 0.00 | 3578.27 | 603.49 | 0.00 |
| Zimmerman, Jenny,18197 | 30.97 | 0.00 | 0.00 | 8.99 | 21.98 |
| Chande, Melvin, R,11460 | 8137.52 | 0.00 | 3399.99 | 2294.99 | 2442.54 |
| Zhu, Sandra, V,15732 | 4376.40 | 0.00 | 0.00 | 2071.42 | 2304.98 |
| Yang, Martha, G,22210 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Luo, Melvin,24366 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Deng, Clayton, G,17285 | 6093.20 | 3578.27 | 0.00 | 0.00 | 2514.93 |
| Gao, Bianca, C,13112 | 5717.89 | 0.00 | 0.00 | 2049.10 | 3668.79 |
| Perez, Arthur, L,16526 | 4758.24 | 3578.27 | 0.00 | 0.00 | 1179.97 |
| Williams, Alexis, D,14674 | 142.47 | 0.00 | 0.00 | 0.00 | 142.47 |
| Xu, Alisha,14100 | 226.26 | 0.00 | 0.00 | 0.00 | 226.26 |
| Martinez, Edgar, B,18741 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Wang, Laura, L,26146 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Xu, Barbara,14074 | 59.88 | 0.00 | 0.00 | 0.00 | 59.88 |
| Ashe, Marshall,28932 | 93.97 | 0.00 | 0.00 | 0.00 | 93.97 |
| Huang, Omar, C,14232 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
Generated 2025-11-04 10:16:45.951 UTC