[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 625 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Becker, Kathryn,24588 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Ruiz, Francis, D,21381 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Hernandez, Walter,13141 | 240.24 | 0.00 | 0.00 | 0.00 | 240.24 |
| Baker, Jose, A,22937 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Diaz, Aaron, C,18695 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Gill, Jimmy,29098 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Gill, Dwayne, A,19675 | 198.99 | 0.00 | 0.00 | 0.00 | 198.99 |
| Ramos, Victor, D,24246 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Coleman, Nicole, A,21558 | 4919.30 | 0.00 | 2443.35 | 0.00 | 2475.95 |
| Patel, Marco, L,19575 | 60.05 | 0.00 | 0.00 | 23.78 | 36.27 |
| Subram, Nancy, C,29291 | 564.48 | 0.00 | 0.00 | 0.00 | 564.48 |
| Martinez, Terrance,25718 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Xu, Crystal, E,15754 | 4416.38 | 0.00 | 0.00 | 2071.42 | 2344.96 |
| Evans, Xavier,19098 | 122.24 | 0.00 | 0.00 | 0.00 | 122.24 |
| Ortega, Gloria, R,19558 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Ramos, Theresa, G,11031 | 6478.60 | 3399.99 | 0.00 | 0.00 | 3078.61 |
| Navarro, Albert, L,21561 | 4947.78 | 0.00 | 2443.35 | 0.00 | 2504.43 |
| Goel, Gilbert,15596 | 4460.04 | 0.00 | 0.00 | 2049.10 | 2410.94 |
| Madan, Summer, D,12347 | 6839.12 | 0.00 | 2049.10 | 0.00 | 4790.02 |
| Lal, Shawna,17924 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Shen, Tony,29099 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Chander, Drew, J,25111 | 2145.92 | 0.00 | 0.00 | 1000.44 | 1145.48 |
| Guo, Jamie,20151 | 4152.73 | 0.00 | 3578.27 | 574.46 | 0.00 |
| Raman, Veronica, R,12359 | 95.74 | 0.00 | 0.00 | 0.00 | 95.74 |
| Rai, Tracy, K,17079 | 4417.75 | 3578.27 | 0.00 | 0.00 | 839.48 |
| Kim, Kari, S,11445 | 8098.03 | 0.00 | 3399.99 | 2304.98 | 2393.06 |
| She, Tonya, L,16521 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Bradley, Diane, A,15140 | 62.27 | 0.00 | 0.00 | 27.28 | 34.99 |
| Yuan, Colin,11758 | 58.05 | 0.00 | 0.00 | 0.00 | 58.05 |
| Huang, Jorge,17291 | 86.27 | 0.00 | 0.00 | 53.99 | 32.28 |
| Ashe, Brad,25228 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Sai, Monica, L,29055 | 765.32 | 0.00 | 0.00 | 0.00 | 765.32 |
| Romero, Jacquelyn,25815 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Wang, Willie,29304 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Clark, Joshua, A,26137 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Lin, Claudia, A,14312 | 191.27 | 0.00 | 0.00 | 166.28 | 24.99 |
| Ashe, Maurice,20430 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Vazquez, Latasha,21952 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Wang, Trisha, V,17259 | 4404.73 | 3578.27 | 0.00 | 0.00 | 826.46 |
| Martinez, Brett,23532 | 3337.04 | 0.00 | 0.00 | 3337.04 | 0.00 |
| Zhao, Jorge,16711 | 132.95 | 0.00 | 0.00 | 62.98 | 69.97 |
| White, Ashley, D,21887 | 39.99 | 0.00 | 0.00 | 39.99 | 0.00 |
| Raji, Brendan,13103 | 6842.60 | 0.00 | 0.00 | 2049.10 | 4793.50 |
| Russell, Alexis, L,13634 | 234.93 | 0.00 | 0.00 | 0.00 | 234.93 |
| Simmons, Jacqueline, W,13137 | 177.94 | 0.00 | 0.00 | 3.99 | 173.95 |
| Schmidt, Deanna, H,25936 | 1248.08 | 0.00 | 699.10 | 0.00 | 548.98 |
| Serrano, Natasha,25563 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Muñoz, Pedro, A,23433 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Srini, Joe,22180 | 4632.86 | 0.00 | 0.00 | 2181.56 | 2451.30 |
| Xie, Wayne, S,18302 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Sai, Kari, E,14231 | 83.97 | 0.00 | 0.00 | 24.99 | 58.98 |
| Pal, Tamara,12689 | 6846.92 | 0.00 | 2071.42 | 0.00 | 4775.50 |
| Luo, Michele,26027 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Jiménez, Bruce, L,23640 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Raji, Lindsey,18205 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Perez, Virginia, A,27494 | 1952.45 | 0.00 | 0.00 | 782.99 | 1169.46 |
| Richardson, Katelyn,18930 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Ruiz, Kristine, J,24607 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Black, Shaun, M,17355 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Butler, Carson, T,12672 | 381.97 | 0.00 | 0.00 | 0.00 | 381.97 |
| Blanco, Jésus, E,20448 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Xu, Wesley, K,29182 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Ashe, Orlando, I,11897 | 8203.02 | 0.00 | 3399.99 | 0.00 | 4803.03 |
| Romero, Latasha,14220 | 5696.19 | 0.00 | 0.00 | 2071.42 | 3624.77 |
| Arthur, Kristi, W,16675 | 4385.03 | 3578.27 | 0.00 | 806.76 | 0.00 |
| Campbell, Haley, L,17304 | 62.27 | 0.00 | 0.00 | 0.00 | 62.27 |
| Kumar, Kurt, L,27360 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Ashe, Kathryn,16168 | 80.11 | 0.00 | 0.00 | 34.89 | 45.22 |
| Jai, Ethan,15217 | 41.26 | 0.00 | 0.00 | 31.27 | 9.99 |
| Rai, Terrence, R,25037 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Nath, Dale, B,27343 | 132.97 | 0.00 | 0.00 | 0.00 | 132.97 |
| She, Colin, M,15139 | 59.98 | 0.00 | 0.00 | 34.99 | 24.99 |
| Arun, Barry,27700 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Moreno, Pedro, A,18248 | 6037.89 | 0.00 | 3578.27 | 2459.62 | 0.00 |
| Kapoor, Brandy, I,15236 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
| Chapman, Alicia, A,21418 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Rubio, Tanya, I,15598 | 167.93 | 0.00 | 0.00 | 0.00 | 167.93 |
| Andersen, Jodi,26766 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Carlson, Orlando, J,11893 | 8123.03 | 0.00 | 3374.99 | 2319.99 | 2428.05 |
| Hu, Jenny, A,16634 | 106.56 | 0.00 | 0.00 | 0.00 | 106.56 |
| Suri, Evelyn, A,21223 | 56.98 | 0.00 | 0.00 | 56.98 | 0.00 |
| Hernandez, Javier, A,16156 | 4344.09 | 0.00 | 0.00 | 2049.10 | 2294.99 |
| Shen, Bonnie,21405 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Alvarez, Larry, T,14235 | 5682.20 | 0.00 | 0.00 | 2071.42 | 3610.78 |
| Zhao, Randy, J,27874 | 1288.31 | 0.00 | 0.00 | 1288.31 | 0.00 |
| Fernandez, Ross, R,11763 | 76.65 | 0.00 | 0.00 | 24.49 | 52.16 |
| Wood, Jacqueline,16705 | 97.96 | 0.00 | 0.00 | 0.00 | 97.96 |
| Jenkins, Wyatt,27987 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Martin, Briana, L,15213 | 2818.59 | 0.00 | 0.00 | 2049.10 | 769.49 |
| Andersen, Karl, M,23105 | 3361.53 | 0.00 | 0.00 | 3361.53 | 0.00 |
| Hernandez, Monique, J,15138 | 123.45 | 0.00 | 0.00 | 34.99 | 88.46 |
| Diaz, Jacquelyn, K,18747 | 6089.59 | 0.00 | 3578.27 | 2511.32 | 0.00 |
| Mehta, Patricia, K,29179 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Anand, Tamara,29088 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
| Zheng, Dawn, F,19579 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Hernandez, Bruce,17919 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Suarez, Alberto, G,18719 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Patterson, Ashley, R,18736 | 6035.60 | 0.00 | 3578.27 | 2457.33 | 0.00 |
| Xu, Kelsey, W,28220 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Lopez, Rachael,23425 | 3951.52 | 0.00 | 0.00 | 2181.56 | 1769.96 |
| Ortega, Briana, L,29346 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Hall, Jeremiah, M,18250 | 6058.21 | 0.00 | 3578.27 | 2479.94 | 0.00 |
| Yang, Crystal, A,23665 | 4207.32 | 0.00 | 0.00 | 2443.35 | 1763.97 |
| Alvarez, Pedro, E,28120 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Fernandez, Lydia, M,14523 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Chande, Derek,26743 | 1371.95 | 0.00 | 0.00 | 1371.95 | 0.00 |
| Chande, Mindy, V,27472 | 1345.95 | 0.00 | 0.00 | 782.99 | 562.96 |
| Li, Colin, J,18445 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Alvarez, Arthur,24892 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Perez, Johnathan, D,20426 | 4139.75 | 0.00 | 3578.27 | 561.48 | 0.00 |
| Rodriguez, Toni, J,25251 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Shan, Dylan,19677 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Yuan, Bradley,17920 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Raji, Kelli, G,13123 | 6765.44 | 0.00 | 0.00 | 2049.10 | 4716.34 |
| Sanders, Arianna, E,22859 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Luo, Raul, Q,20154 | 4153.25 | 0.00 | 3578.27 | 574.98 | 0.00 |
| Wu, Lisa,26158 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Gomez, Derrick,18694 | 6035.60 | 0.00 | 3578.27 | 2457.33 | 0.00 |
| Rodriguez, Pedro, L,17911 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Zhu, Jake, G,24603 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ramos, Paula, W,21376 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Raji, Damien, K,24282 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Gutierrez, Jonathon, R,16529 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Rodriguez, Pamela,29065 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Martin, Ethan, M,13998 | 245.25 | 0.00 | 0.00 | 97.97 | 147.28 |
Generated 2025-11-03 09:02:48.309 UTC