[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 1250 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Cai, Trisha,18265 | 64.98 | 0.00 | 0.00 | 0.00 | 64.98 |
| Goel, Derek,17045 | 4480.73 | 3578.27 | 0.00 | 0.00 | 902.46 |
| Lal, Devon, L,15237 | 66.26 | 0.00 | 0.00 | 0.00 | 66.26 |
| Hu, Alejandro,13125 | 138.54 | 0.00 | 0.00 | 0.00 | 138.54 |
| Gutierrez, Natasha,17048 | 4382.75 | 3578.27 | 0.00 | 0.00 | 804.48 |
| Diaz, Samuel,14065 | 5608.55 | 0.00 | 0.00 | 2071.42 | 3537.13 |
| Mr., Shakespear, Paul, J.,17326 | 4467.76 | 0.00 | 3578.27 | 0.00 | 889.49 |
| Raje, Colleen, M,19084 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Zhou, Autumn, L,25229 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Zhang, Edwin,15785 | 4454.35 | 0.00 | 0.00 | 2071.42 | 2382.93 |
| Griffin, Brianna, K,16487 | 73.24 | 0.00 | 0.00 | 0.00 | 73.24 |
| Lal, Karla,25219 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Taylor, Ashley, E,18215 | 150.97 | 0.00 | 0.00 | 0.00 | 150.97 |
| Raman, Patricia, T,16702 | 6021.62 | 3578.27 | 0.00 | 2443.35 | 0.00 |
| Nelson, Sophia,16664 | 4377.75 | 3578.27 | 0.00 | 799.48 | 0.00 |
| Oliver, Lee,29119 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Serrano, Javier, R,20256 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Coleman, Melanie, H,15639 | 34.57 | 0.00 | 0.00 | 0.00 | 34.57 |
| Garcia, Toni,22193 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Gonzales, Victoria,11751 | 8215.02 | 0.00 | 3399.99 | 2430.96 | 2384.07 |
| Jimenez, Jacquelyn,14304 | 3595.93 | 0.00 | 0.00 | 2049.10 | 1546.83 |
| Lopez, Pamela, E,26444 | 1938.71 | 0.00 | 0.00 | 782.99 | 1155.72 |
| Romero, Paula, B,16691 | 4471.74 | 3578.27 | 0.00 | 893.47 | 0.00 |
| Rubio, Jay,15179 | 4444.89 | 0.00 | 0.00 | 2071.42 | 2373.47 |
| Huang, Barbara,26442 | 1919.75 | 0.00 | 0.00 | 782.99 | 1136.76 |
| Zhang, Ronnie,16656 | 5930.23 | 3578.27 | 0.00 | 0.00 | 2351.96 |
| Diaz, Rebekah, J,21378 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Ortega, Lawrence,14685 | 146.74 | 0.00 | 0.00 | 0.00 | 146.74 |
| Romero, Billy,20419 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sanz, Kellie,16708 | 4406.74 | 3578.27 | 0.00 | 0.00 | 828.47 |
| Deng, Colin, B,18299 | 32.22 | 0.00 | 0.00 | 0.00 | 32.22 |
| Mehta, Ann, M,14518 | 126.95 | 0.00 | 0.00 | 63.97 | 62.98 |
| Arun, Nancy, C,21169 | 4647.88 | 0.00 | 2181.56 | 0.00 | 2466.32 |
| Moore, Michael,17247 | 4432.72 | 3578.27 | 0.00 | 0.00 | 854.45 |
| Butler, Elijah, D,21551 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Bailey, Savannah, J,23428 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Carlson, Theresa, L,19629 | 109.44 | 0.00 | 0.00 | 0.00 | 109.44 |
| Kumar, Warren, A,24003 | 2806.53 | 0.00 | 0.00 | 2181.56 | 624.97 |
| Sai, Terrance,19106 | 64.95 | 0.00 | 0.00 | 21.98 | 42.97 |
| Mr., Solanki, Ajay,18295 | 144.27 | 0.00 | 0.00 | 0.00 | 144.27 |
| Xu, Tara,19592 | 5377.23 | 0.00 | 3578.27 | 0.00 | 1798.96 |
| Jimenez, Joy,28312 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Romero, Max, C,29316 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Zheng, Omar, C,14522 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
| Lal, Darrell,19953 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Perez, Patricia,25022 | 1564.92 | 0.00 | 0.00 | 1000.44 | 564.48 |
| Ruiz, Naomi,23649 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Ye, Christy,14219 | 5744.22 | 0.00 | 0.00 | 2071.42 | 3672.80 |
| Torres, Melinda, J,14033 | 6809.96 | 0.00 | 0.00 | 2071.42 | 4738.54 |
| Serrano, Francis, R,23547 | 3598.83 | 0.00 | 0.00 | 2443.35 | 1155.48 |
| Martin, Justin,23542 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Jai, Kathryn,23546 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Romero, Jessie,25030 | 2180.41 | 0.00 | 0.00 | 1000.44 | 1179.97 |
| Raje, Johnny,13975 | 5138.72 | 0.00 | 0.00 | 2049.10 | 3089.62 |
| Beck, Ashlee, L,26666 | 1336.96 | 0.00 | 0.00 | 1336.96 | 0.00 |
| Dominguez, Kristine, A,14020 | 6831.76 | 0.00 | 0.00 | 2071.42 | 4760.34 |
| Lal, Franklin, A,14101 | 3679.90 | 0.00 | 0.00 | 2888.58 | 791.32 |
| Rai, Tonya,25243 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Carlson, Jonathon, N,17073 | 78.97 | 0.00 | 0.00 | 0.00 | 78.97 |
| Rai, Christy,16683 | 69.87 | 0.00 | 0.00 | 0.00 | 69.87 |
| Zheng, Jaclyn, F,11910 | 8113.03 | 0.00 | 3374.99 | 2319.99 | 2418.05 |
| Jai, Clayton,12339 | 6865.46 | 0.00 | 2071.42 | 0.00 | 4794.04 |
| Srini, Douglas, M,16733 | 35.26 | 0.00 | 0.00 | 0.00 | 35.26 |
| Suri, Barry,15253 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Prasad, Gerald, B,12035 | 81.24 | 0.00 | 0.00 | 64.97 | 16.27 |
| Xie, Cristina, C,17050 | 4496.23 | 3578.27 | 0.00 | 0.00 | 917.96 |
| Garcia, Ruben,19613 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Kumar, Tony, P,19783 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Wu, Bianca, F,28485 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Zeng, Curtis, E,26669 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Gomez, Hector, A,29337 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Gonzalez, Meredith,22171 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| She, Sheena, R,23008 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Rana, Henry,27342 | 1348.46 | 0.00 | 0.00 | 782.99 | 565.47 |
| Ms., Simon, Britta,25946 | 1873.58 | 0.00 | 699.10 | 0.00 | 1174.48 |
| Xu, Edwin, J,25272 | 1873.58 | 699.10 | 0.00 | 0.00 | 1174.48 |
| Madan, Geoffrey, M,15241 | 51.91 | 0.00 | 0.00 | 0.00 | 51.91 |
| Ortega, Joanna,17909 | 4761.74 | 0.00 | 3578.27 | 0.00 | 1183.47 |
| Lal, Nina, L,14263 | 5647.93 | 0.00 | 0.00 | 2049.10 | 3598.83 |
| He, Jon, L,14262 | 5652.54 | 0.00 | 0.00 | 2071.42 | 3581.12 |
| Perez, Joe, A,14326 | 5207.70 | 0.00 | 0.00 | 2071.42 | 3136.28 |
| Martin, Joe,14668 | 5216.69 | 0.00 | 0.00 | 2071.42 | 3145.27 |
| Yang, Crystal, A,23665 | 4207.32 | 0.00 | 0.00 | 2443.35 | 1763.97 |
| Gill, Leslie,14670 | 2919.89 | 0.00 | 0.00 | 2071.42 | 848.47 |
| Weber, Deanna, L,14855 | 3759.08 | 0.00 | 0.00 | 2049.10 | 1709.98 |
| Liu, Warren,15014 | 3860.87 | 0.00 | 0.00 | 2071.42 | 1789.45 |
| Subram, Meredith, S,14261 | 5653.92 | 0.00 | 0.00 | 2049.10 | 3604.82 |
| Ramos, Marie, A,14308 | 5140.40 | 0.00 | 0.00 | 2049.10 | 3091.30 |
| Dominguez, Neil, K,23663 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Ross, Arianna, E,26774 | 1331.97 | 0.00 | 0.00 | 1331.97 | 0.00 |
| Gao, Micah, W,25106 | 2170.92 | 0.00 | 0.00 | 1000.44 | 1170.48 |
| Serrano, Mallory, E,26751 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Saunders, Ruben, G,27983 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Carson, Terrence,11356 | 5069.29 | 0.00 | 3374.99 | 0.00 | 1694.30 |
| Xu, Colleen,28956 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Coleman, Ethan, G,16693 | 6060.50 | 3578.27 | 0.00 | 2482.23 | 0.00 |
| Suarez, Melody, H,14276 | 5259.36 | 0.00 | 0.00 | 2049.10 | 3210.26 |
| Nara, Tony, L,16713 | 6090.59 | 3578.27 | 0.00 | 2512.32 | 0.00 |
| Nath, Michele, L,11056 | 8207.50 | 3374.99 | 0.00 | 2413.45 | 2419.06 |
| Ma, Cedric, W,11094 | 157.93 | 0.00 | 0.00 | 0.00 | 157.93 |
| Rai, Karl, M,25273 | 1898.07 | 699.10 | 0.00 | 0.00 | 1198.97 |
| Zhang, Ramon, D,12352 | 274.24 | 0.00 | 0.00 | 0.00 | 274.24 |
| Andersen, Kate,14237 | 90.25 | 0.00 | 0.00 | 0.00 | 90.25 |
| Black, Rafael,11966 | 55.76 | 0.00 | 0.00 | 0.00 | 55.76 |
| Romero, Sabrina, L,28534 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Romero, Rodney,14521 | 117.96 | 0.00 | 0.00 | 0.00 | 117.96 |
| Wood, Richard, W,24377 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Vazquez, Kristi,28349 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sullivan, Dominic, M,22840 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Raji, Devon, D,21898 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Kapoor, Regina,15810 | 67.17 | 0.00 | 0.00 | 0.00 | 67.17 |
| Raje, Carly, J,15576 | 4344.09 | 0.00 | 0.00 | 2049.10 | 2294.99 |
| Gutierrez, Marvin,25938 | 1308.06 | 0.00 | 699.10 | 0.00 | 608.96 |
| Dominguez, Diana, L,29292 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Moreno, Meghan, J,15152 | 4464.57 | 0.00 | 0.00 | 2049.10 | 2415.47 |
| Anand, Kara,11989 | 8139.53 | 0.00 | 3374.99 | 0.00 | 4764.54 |
| Arun, Ruth, S,17294 | 4355.71 | 3578.27 | 0.00 | 0.00 | 777.44 |
| Wang, Crystal, C,11112 | 8295.02 | 0.00 | 3374.99 | 0.00 | 4920.03 |
| Suarez, Joy, B,12665 | 74.54 | 0.00 | 0.00 | 0.00 | 74.54 |
| Gao, Todd, M,11061 | 8129.02 | 3374.99 | 0.00 | 2369.96 | 2384.07 |
| Torres, Meghan, I,21256 | 3917.54 | 0.00 | 2181.56 | 0.00 | 1735.98 |
| Munoz, Latasha,11967 | 8153.02 | 0.00 | 3374.99 | 2358.97 | 2419.06 |
| Gao, Cara, B,15642 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Beck, April,14302 | 5140.73 | 0.00 | 0.00 | 2071.42 | 3069.31 |
| Chander, Russell, E,29067 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
Generated 2025-11-03 05:44:54.393 UTC