[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 999 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lal, Drew, A,28325 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Bhat, Edwin,13079 | 6752.13 | 0.00 | 0.00 | 2049.10 | 4703.03 |
| Zhu, Roger, J,28098 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Adams, Devin,21871 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Andersen, Maurice,15206 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Lal, Deborah, T,21982 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Goel, Carly, C,12989 | 6817.12 | 0.00 | 0.00 | 2049.10 | 4768.02 |
| Sai, Jay, A,23427 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gomez, Jerome, J,25057 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Sai, Bruce,22194 | 4633.90 | 0.00 | 0.00 | 2181.56 | 2452.34 |
| Hernandez, Krista, J,26918 | 1399.94 | 0.00 | 0.00 | 782.99 | 616.95 |
| Dominguez, Larry,22197 | 4740.98 | 0.00 | 0.00 | 2181.56 | 2559.42 |
| Nath, Michele, L,11056 | 8207.50 | 0.00 | 3374.99 | 2413.45 | 2419.06 |
| Deng, Latoya, H,21969 | 4759.47 | 0.00 | 0.00 | 2181.56 | 2577.91 |
| Sanchez, Andre,15595 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Zheng, Alisha,22203 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Sai, Monica, L,29055 | 765.32 | 0.00 | 0.00 | 0.00 | 765.32 |
| Martinez, Anna, J,12994 | 6855.44 | 0.00 | 0.00 | 2071.42 | 4784.02 |
| Lal, Jodi, J,22944 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Torres, Michele, A,16176 | 4404.08 | 0.00 | 0.00 | 2049.10 | 2354.98 |
| Gomez, Derrick,18694 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Serrano, Pedro,26189 | 1926.45 | 0.00 | 0.00 | 782.99 | 1143.46 |
| Ye, Alvin, B,15575 | 2910.90 | 0.00 | 0.00 | 2071.42 | 839.48 |
| Zeng, Alisha, A,15727 | 134.46 | 0.00 | 0.00 | 0.00 | 134.46 |
| Xu, Clayton,18488 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Martin, Ruben,22400 | 2737.82 | 0.00 | 0.00 | 2181.56 | 556.26 |
| Wu, Shannon, F,15268 | 2840.91 | 0.00 | 0.00 | 2071.42 | 769.49 |
| Lu, Valerie,22913 | 4684.39 | 0.00 | 0.00 | 2181.56 | 2502.83 |
| Shen, Corey,26739 | 61.97 | 0.00 | 0.00 | 0.00 | 61.97 |
| Sun, Lacey, L,15131 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Becker, Leonard, C,22405 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Suri, Rachael, J,18279 | 162.02 | 0.00 | 0.00 | 0.00 | 162.02 |
| Rubio, Marie, V,20618 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Smith, Christian, L,14313 | 222.44 | 0.00 | 0.00 | 0.00 | 222.44 |
| Dominguez, Josue, R,15600 | 4590.40 | 0.00 | 0.00 | 2071.42 | 2518.98 |
| Lal, Terrence,12369 | 94.23 | 0.00 | 0.00 | 0.00 | 94.23 |
| Torres, Marc,11765 | 8143.03 | 0.00 | 3374.99 | 0.00 | 4768.04 |
| Raman, Arthur,24001 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Jackson, Eduardo, C,11749 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Zheng, Colleen,13026 | 155.94 | 0.00 | 0.00 | 0.00 | 155.94 |
| Gao, Jon, C,11456 | 8224.46 | 0.00 | 3399.99 | 2391.43 | 2433.04 |
| Jimenez, Melody, S,14066 | 3612.19 | 0.00 | 0.00 | 2853.57 | 758.62 |
| Shan, Shaun,24274 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Pal, Drew,11902 | 63.04 | 0.00 | 0.00 | 0.00 | 63.04 |
| Mr., Rodgers, Scott, M.,20211 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Kumar, Shawna, L,19085 | 78.26 | 0.00 | 0.00 | 0.00 | 78.26 |
| Hu, Lacey,19948 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Liang, Rosa, L,19770 | 4127.25 | 0.00 | 3578.27 | 0.00 | 548.98 |
| Martin, Jaime,28316 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Romero, Meredith, J,29452 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Malhotra, Kristopher, L,15265 | 2897.57 | 0.00 | 0.00 | 2049.10 | 848.47 |
| Chande, Melvin, R,11460 | 8137.52 | 0.00 | 3399.99 | 0.00 | 4737.53 |
| Gutierrez, Jaime, C,11457 | 8211.48 | 0.00 | 3374.99 | 0.00 | 4836.49 |
| Lal, Cristina, M,14671 | 2934.37 | 0.00 | 0.00 | 2071.42 | 862.95 |
| Gao, Cara, B,15642 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Kapoor, Kristina,11997 | 7029.78 | 0.00 | 3399.99 | 0.00 | 3629.79 |
| Lal, Kara,22579 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Shan, Tony, M,16175 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Lin, Kelvin, A,13075 | 6843.94 | 0.00 | 0.00 | 2071.42 | 4772.52 |
| Sharma, Christian,15809 | 62.59 | 0.00 | 0.00 | 0.00 | 62.59 |
| Lopez, Summer,12036 | 69.55 | 0.00 | 0.00 | 0.00 | 69.55 |
| Blanco, Sheila, I,17724 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Smith, Tina, K,19793 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Chande, Warren,17307 | 132.95 | 0.00 | 0.00 | 0.00 | 132.95 |
| Zheng, Randy, B,22574 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Diaz, Felicia, J,15026 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Hill, Kaylee, L,11918 | 8204.99 | 0.00 | 3399.99 | 0.00 | 4805.00 |
| Kapoor, Bryant,22946 | 3911.53 | 0.00 | 0.00 | 2181.56 | 1729.97 |
| Nath, Bethany,16177 | 133.34 | 0.00 | 0.00 | 0.00 | 133.34 |
| Rodriguez, Cynthia, E,22206 | 201.28 | 0.00 | 0.00 | 0.00 | 201.28 |
| Pal, Mohamed, D,12698 | 6786.75 | 0.00 | 0.00 | 2071.42 | 4715.33 |
| Anand, Andrés,11096 | 8063.04 | 0.00 | 3374.99 | 0.00 | 4688.05 |
| Navarro, Dana, J,11125 | 79.69 | 0.00 | 0.00 | 7.95 | 71.74 |
| Pal, Nichole, J,26741 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Gonzalez, Natalie,25215 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Chander, Tommy,19086 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Alvarez, Erik, M,14311 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Moore, Devin, J,16167 | 102.57 | 0.00 | 0.00 | 0.00 | 102.57 |
| She, Roger, L,15724 | 4359.07 | 0.00 | 0.00 | 2049.10 | 2309.97 |
| Moreno, Pedro, A,18248 | 6037.89 | 0.00 | 3578.27 | 0.00 | 2459.62 |
| Flores, Antonio, D,14259 | 3630.93 | 0.00 | 0.00 | 2049.10 | 1581.83 |
| Cai, Shannon,26156 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Rana, Whitney, A,13006 | 6762.15 | 0.00 | 0.00 | 2049.10 | 4713.05 |
| Moreno, Monique, R,23118 | 3913.82 | 0.00 | 0.00 | 2181.56 | 1732.26 |
| Andersen, Tracy,20815 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Prasad, Marco, C,15606 | 115.93 | 0.00 | 0.00 | 0.00 | 115.93 |
| Rubio, Jessie, J,27868 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| She, Jerry, C,14277 | 5196.74 | 0.00 | 0.00 | 2071.42 | 3125.32 |
| Patterson, Antonio, G,11963 | 8068.03 | 0.00 | 3374.99 | 0.00 | 4693.04 |
| Holt, Alisha,28350 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Price, Isabella, L,17278 | 4382.75 | 0.00 | 3578.27 | 0.00 | 804.48 |
| Xie, Marshall, M,19796 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Weber, Cory,16739 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Shen, Rafael, J,16689 | 290.46 | 0.00 | 0.00 | 0.00 | 290.46 |
| Deng, Kate, L,15723 | 4444.07 | 0.00 | 0.00 | 2049.10 | 2394.97 |
| Cox, Jared, E,28114 | 570.47 | 0.00 | 0.00 | 0.00 | 570.47 |
| Zhao, Glenn, C,14221 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Jimenez, Krista,18257 | 115.95 | 0.00 | 0.00 | 0.00 | 115.95 |
| Fernandez, Michele, M,24884 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Gao, Arturo,28714 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Garcia, Sarah,11907 | 8135.33 | 0.00 | 3399.99 | 0.00 | 4735.34 |
| Yuan, Melvin,29331 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Huang, Micah,25130 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Gonzalez, Devin,18485 | 6063.21 | 0.00 | 3578.27 | 0.00 | 2484.94 |
| Sai, Ivan, E,17300 | 94.22 | 0.00 | 0.00 | 0.00 | 94.22 |
| Sharma, Andres, C,24230 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| King, Hailey, A,28214 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Deng, Carl,18284 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Rubio, Larry,14223 | 155.94 | 0.00 | 0.00 | 0.00 | 155.94 |
| Sutton, Cassie, S,16613 | 129.35 | 0.00 | 0.00 | 0.00 | 129.35 |
| Anand, Niñia, L,19949 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Arun, Levi, A,11074 | 94.19 | 0.00 | 0.00 | 0.00 | 94.19 |
| Andersen, Tara, L,24465 | 3356.04 | 0.00 | 0.00 | 2181.56 | 1174.48 |
| Black, Wayne, E,25056 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Sun, Christy,25218 | 2184.90 | 0.00 | 0.00 | 1000.44 | 1184.46 |
| Serrano, Jésus, B,12991 | 5641.90 | 0.00 | 0.00 | 2049.10 | 3592.80 |
| Diaz, Marc,11058 | 8248.02 | 0.00 | 3399.99 | 2374.98 | 2473.05 |
| Garcia, Darren,28716 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Jiménez, Alberto, C,15215 | 4468.56 | 0.00 | 0.00 | 2049.10 | 2419.46 |
| Vazquez, Latasha,21952 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Tang, Cristina, D,19623 | 153.93 | 0.00 | 0.00 | 0.00 | 153.93 |
| Raji, Jaime, L,15037 | 3856.38 | 0.00 | 0.00 | 2071.42 | 1784.96 |
| Sai, Ruth, D,24461 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Beck, Alisha, E,11463 | 47.92 | 0.00 | 0.00 | 0.00 | 47.92 |
Generated 2025-12-22 02:38:18.375 UTC