[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 500 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sara, Troy, R,22583 | 2821.51 | 0.00 | 0.00 | 2181.56 | 639.95 |
| She, Kathryn, I,26443 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Green, Devin, J,26440 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Zheng, Alisha,22203 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Kumar, Cedric, B,22860 | 4663.79 | 0.00 | 0.00 | 2181.56 | 2482.23 |
| Shen, Kelvin,22406 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Ortega, Reginald, K,26429 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Guo, Jon,22927 | 3913.82 | 0.00 | 0.00 | 2181.56 | 1732.26 |
| Ashe, Briana,22940 | 4207.32 | 0.00 | 0.00 | 4207.32 | 0.00 |
| Zhang, Claudia,13114 | 6807.45 | 0.00 | 0.00 | 2071.42 | 4736.03 |
| Rubio, Pedro, E,23098 | 2745.33 | 0.00 | 0.00 | 2181.56 | 563.77 |
| Moreno, Mallory, P,22912 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Johnson, Sydney,19571 | 90.95 | 0.00 | 0.00 | 33.98 | 56.97 |
| Mr., Shen, Alan,24257 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| White, Taylor, D,25011 | 1589.40 | 0.00 | 0.00 | 1000.44 | 588.96 |
| Sharma, Edwin, K,25021 | 1554.41 | 0.00 | 0.00 | 1000.44 | 553.97 |
| Pal, Nina,29297 | 613.45 | 0.00 | 0.00 | 0.00 | 613.45 |
| Bailey, Sean, L,27710 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Sai, Barry,22907 | 4169.33 | 0.00 | 0.00 | 2443.35 | 1725.98 |
| Davis, Isabella, A,22929 | 4673.88 | 0.00 | 0.00 | 2181.56 | 2492.32 |
| Gomez, Arthur,24917 | 2179.91 | 0.00 | 0.00 | 1000.44 | 1179.47 |
| Van, Cassandra,13525 | 4607.23 | 0.00 | 0.00 | 2071.42 | 2535.81 |
| Thompson, Justin,22954 | 4179.33 | 0.00 | 0.00 | 4179.33 | 0.00 |
| Vazquez, Casey, S,13132 | 6880.62 | 0.00 | 0.00 | 2049.10 | 4831.52 |
| Becker, Gregory, M,13104 | 6894.44 | 0.00 | 0.00 | 2071.42 | 4823.02 |
| Shen, Lindsey,26560 | 1396.44 | 0.00 | 0.00 | 782.99 | 613.45 |
| Shen, Kelsey, R,22921 | 4647.88 | 0.00 | 0.00 | 2181.56 | 2466.32 |
| Parker, Timothy, C,22943 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Yuan, Kathryn, L,23106 | 3956.01 | 0.00 | 0.00 | 2181.56 | 1774.45 |
| Sanchez, Michelle, R,26569 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Morgan, Sara,13134 | 5648.92 | 0.00 | 0.00 | 2049.10 | 3599.82 |
| Goldstein, Brendan,13518 | 2638.36 | 0.00 | 0.00 | 2049.10 | 589.26 |
| Munoz, Briana,23437 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Alonso, Jonathon, A,15238 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| She, Bradley, L,16016 | 117.93 | 0.00 | 0.00 | 0.00 | 117.93 |
| Ma, Louis,21879 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Gutierrez, Erika,17227 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Chande, Ashlee, N,23096 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Wu, Ernest, L,11147 | 8195.50 | 0.00 | 3374.99 | 0.00 | 4820.51 |
| Gomez, Gary,15640 | 34.57 | 0.00 | 0.00 | 2.29 | 32.28 |
| Patel, Veronica,13963 | 74.48 | 0.00 | 0.00 | 0.00 | 74.48 |
| Alvarez, Philip, A,11123 | 45.88 | 0.00 | 0.00 | 0.00 | 45.88 |
| Ortega, Felicia, J,11753 | 47.92 | 0.00 | 0.00 | 0.00 | 47.92 |
| Sai, Harold,11026 | 6575.79 | 3399.99 | 0.00 | 2399.47 | 776.33 |
| Rubio, Beth,20240 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Gonzales, Hunter,26570 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Pal, Kara,24916 | 2169.90 | 0.00 | 0.00 | 1000.44 | 1169.46 |
| Blanco, Cheryl,13524 | 4528.75 | 0.00 | 0.00 | 2071.42 | 2457.33 |
| Jai, Carly,22986 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Yuan, Keith, N,22926 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Blanco, Hector, J,22938 | 4173.32 | 0.00 | 0.00 | 2443.35 | 1729.97 |
| Lu, Sandra, N,13521 | 4514.77 | 0.00 | 0.00 | 4514.77 | 0.00 |
| Tang, Wayne, S,13090 | 6812.42 | 0.00 | 0.00 | 2049.10 | 4763.32 |
| Cox, Nicole, V,22950 | 3917.54 | 0.00 | 0.00 | 3917.54 | 0.00 |
| Wu, Clarence, L,13115 | 6779.42 | 0.00 | 0.00 | 2049.10 | 4730.32 |
| Long, Isabelle, W,23104 | 3490.03 | 0.00 | 0.00 | 3490.03 | 0.00 |
| Kumar, Michele,23107 | 3896.53 | 0.00 | 0.00 | 2181.56 | 1714.97 |
| Tang, Latoya, F,22910 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Raman, Brett, L,22930 | 4900.68 | 0.00 | 0.00 | 2443.35 | 2457.33 |
| Prasad, Cesar,23411 | 3577.82 | 0.00 | 0.00 | 3577.82 | 0.00 |
| Arun, Brenda,13630 | 6824.73 | 0.00 | 0.00 | 2071.42 | 4753.31 |
| Subram, Joe,13631 | 6817.12 | 0.00 | 0.00 | 2049.10 | 4768.02 |
| Alonso, Armando, M,13647 | 6793.15 | 0.00 | 0.00 | 2049.10 | 4744.05 |
| Yuan, Willie,23421 | 4208.31 | 0.00 | 0.00 | 2443.35 | 1764.96 |
| Moreno, Monique, R,23118 | 3913.82 | 0.00 | 0.00 | 2181.56 | 1732.26 |
| Gonzalez, Veronica, C,23311 | 3337.04 | 0.00 | 0.00 | 3337.04 | 0.00 |
| Ye, Damien, M,13620 | 6848.07 | 0.00 | 0.00 | 2049.10 | 4798.97 |
| Lewis, Jasmine,13964 | 6806.45 | 0.00 | 0.00 | 2071.42 | 4735.03 |
| Luo, Roger, J,18728 | 56.71 | 0.00 | 0.00 | 0.00 | 56.71 |
| Rubio, Mallory, S,11098 | 88.96 | 0.00 | 0.00 | 29.98 | 58.98 |
| Carlson, Clinton, E,11116 | 148.70 | 0.00 | 0.00 | 27.28 | 121.42 |
| Yang, Crystal, A,23665 | 4207.32 | 0.00 | 0.00 | 2443.35 | 1763.97 |
| Serrano, Beth,24304 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Navarro, Kristine, B,25566 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Srini, Darren, P,15591 | 4346.38 | 0.00 | 0.00 | 2049.10 | 2297.28 |
| Raji, Michele,15183 | 4368.70 | 0.00 | 0.00 | 2071.42 | 2297.28 |
| Lal, Shawna,17924 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Ramos, Craig,14209 | 193.97 | 0.00 | 0.00 | 4.99 | 188.98 |
| Rodriguez, Arthur,15438 | 3788.68 | 0.00 | 0.00 | 2071.42 | 1717.26 |
| Kumar, Misty, H,25010 | 1540.43 | 0.00 | 0.00 | 1000.44 | 539.99 |
| Blanco, Billy,23316 | 2835.02 | 0.00 | 0.00 | 2181.56 | 653.46 |
| Rana, Pedro, F,13970 | 6843.14 | 0.00 | 0.00 | 2049.10 | 4794.04 |
| Jimenez, Naomi,24922 | 2145.92 | 0.00 | 0.00 | 1000.44 | 1145.48 |
| Hughes, Lucas, E,26657 | 1357.97 | 0.00 | 0.00 | 1357.97 | 0.00 |
| He, Curtis, D,24921 | 2180.41 | 0.00 | 0.00 | 1000.44 | 1179.97 |
| She, Jessie, A,13650 | 6768.14 | 0.00 | 0.00 | 2049.10 | 4719.04 |
| Lal, Corey, H,23313 | 2906.03 | 0.00 | 0.00 | 2181.56 | 724.47 |
| Allen, Kaylee,26653 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Munoz, Theresa, M,13953 | 6840.75 | 0.00 | 0.00 | 2071.42 | 4769.33 |
| Coleman, Dalton, M,23412 | 3586.81 | 0.00 | 0.00 | 3586.81 | 0.00 |
| Chandra, Tina, S,13974 | 5237.73 | 0.00 | 0.00 | 2071.42 | 3166.31 |
| Chen, Aimee,26591 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Wood, Sydney,23310 | 3333.32 | 0.00 | 0.00 | 3333.32 | 0.00 |
| Sai, Emmanuel,23417 | 3337.04 | 0.00 | 0.00 | 3337.04 | 0.00 |
| Xu, Arturo,13619 | 6808.10 | 0.00 | 0.00 | 2049.10 | 4759.00 |
| Campbell, Jason, J,13625 | 6962.14 | 0.00 | 0.00 | 2049.10 | 4913.04 |
| Hall, Amanda,26656 | 1345.95 | 0.00 | 0.00 | 1345.95 | 0.00 |
| Yuan, Terry, R,13646 | 6843.60 | 0.00 | 0.00 | 2049.10 | 4794.50 |
| Alvarez, Carrie, W,23410 | 4016.53 | 0.00 | 0.00 | 2181.56 | 1834.97 |
| Zimmerman, Tiffany, E,23325 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Moyer, Mario,23420 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Ramos, Juan,13633 | 6803.14 | 0.00 | 0.00 | 2049.10 | 4754.04 |
| Sara, Barry, R,13965 | 6872.39 | 0.00 | 0.00 | 2071.42 | 4800.97 |
| Zhao, Bianca,13971 | 6772.13 | 0.00 | 0.00 | 2049.10 | 4723.03 |
| Malhotra, Kristina,25031 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Gutierrez, Jay, C,13155 | 226.95 | 0.00 | 0.00 | 84.47 | 142.48 |
| Torres, Diane, M,25211 | 79.47 | 0.00 | 0.00 | 0.00 | 79.47 |
| Hu, Jenny, A,16634 | 106.56 | 0.00 | 0.00 | 0.00 | 106.56 |
| Allen, Alexandra, B,17293 | 4417.75 | 0.00 | 3578.27 | 0.00 | 839.48 |
| Alexander, David,15783 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Zeng, Micah, A,25561 | 1288.06 | 0.00 | 699.10 | 0.00 | 588.96 |
| Tang, Julie,26589 | 1966.46 | 0.00 | 0.00 | 782.99 | 1183.47 |
| Jimenez, Kathleen,26654 | 1346.76 | 0.00 | 0.00 | 1346.76 | 0.00 |
| Guo, Margaret,23431 | 4158.32 | 0.00 | 0.00 | 2443.35 | 1714.97 |
| Fernandez, Cassandra, C,14134 | 3835.07 | 0.00 | 0.00 | 2049.10 | 1785.97 |
| Patel, Jillian,26667 | 1390.95 | 0.00 | 0.00 | 1390.95 | 0.00 |
| Zhou, Krystal,23593 | 3990.01 | 0.00 | 0.00 | 2181.56 | 1808.45 |
| Yang, Ronnie,23524 | 3598.83 | 0.00 | 0.00 | 3598.83 | 0.00 |
| Lopez, Manuel, M,14050 | 5650.24 | 0.00 | 0.00 | 3295.26 | 2354.98 |
| Ramos, Tanya, R,14045 | 6804.13 | 0.00 | 0.00 | 2049.10 | 4755.03 |
| Kumar, Ricardo, K,14133 | 3764.07 | 0.00 | 0.00 | 2049.10 | 1714.97 |
| Romero, Latasha,14220 | 5696.19 | 0.00 | 0.00 | 2071.42 | 3624.77 |
| Harris, Ian, W,14128 | 3836.38 | 0.00 | 0.00 | 3836.38 | 0.00 |
| Wang, Nathan,14039 | 6808.13 | 0.00 | 0.00 | 2049.10 | 4759.03 |
| Zheng, Dawn, F,19579 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
Generated 2025-11-02 13:35:56.900 UTC