[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > SHUFFLE < SKIP 625 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Bryant, Lauren,11752 | 137.87 | 0.00 | 0.00 | 77.96 | 59.91 |
| Kapoor, Candace,18282 | 30.97 | 0.00 | 0.00 | 21.98 | 8.99 |
| Alvarez, Marvin,23651 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Sara, Tabitha, W,25715 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Kumar, Colin,29188 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Subram, Adriana,23424 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Yang, Jon, V,11000 | 8248.99 | 3399.99 | 0.00 | 2341.97 | 2507.03 |
| Raje, Casey, A,14686 | 203.46 | 0.00 | 0.00 | 0.00 | 203.46 |
| Sutton, Cassie, S,16613 | 129.35 | 0.00 | 0.00 | 34.89 | 94.46 |
| Chen, Randy,13004 | 190.27 | 0.00 | 0.00 | 0.00 | 190.27 |
| Xu, Martha, C,16351 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Yuan, Sharon,12008 | 55.76 | 0.00 | 0.00 | 0.00 | 55.76 |
| Lewis, Justin, L,28303 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Evans, Jackson,14321 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Martinez, Jermaine, L,15170 | 4391.41 | 0.00 | 0.00 | 2071.42 | 2319.99 |
| Ye, Edwin,18334 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Ye, Alejandro, W,15029 | 3826.40 | 0.00 | 0.00 | 2071.42 | 1754.98 |
| Hernandez, Tabitha, L,19603 | 25.48 | 0.00 | 0.00 | 25.48 | 0.00 |
| Raman, Deanna, H,17053 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Moreno, Kristi,23415 | 3588.83 | 0.00 | 0.00 | 3588.83 | 0.00 |
| Patel, Virginia, R,11366 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Yuan, Darrell,18271 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Fernandez, Tammy, A,25825 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sai, Ronald, B,13643 | 6799.45 | 0.00 | 0.00 | 2071.42 | 4728.03 |
| Yang, Wesley, K,15127 | 5182.73 | 0.00 | 0.00 | 2071.42 | 3111.31 |
| Morgan, Nathaniel, E,16626 | 71.57 | 0.00 | 0.00 | 36.59 | 34.98 |
| Moreno, Diana, J,29298 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Gill, Erika, A,18202 | 4143.26 | 0.00 | 3578.27 | 0.00 | 564.99 |
| Martin, Gerald, K,17284 | 90.25 | 0.00 | 0.00 | 31.27 | 58.98 |
| Hernandez, Beth, L,29084 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Zhao, Susan, L,25122 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gonzalez, Ruth,12693 | 6820.47 | 0.00 | 2071.42 | 0.00 | 4749.05 |
| Liang, Omar,24245 | 17.27 | 0.00 | 0.00 | 0.00 | 17.27 |
| Thompson, Cameron, M,16620 | 5895.24 | 3578.27 | 0.00 | 0.00 | 2316.97 |
| Schmidt, Shane,17922 | 4821.72 | 0.00 | 3578.27 | 0.00 | 1243.45 |
| Torres, Mathew, L,18900 | 4132.24 | 0.00 | 3578.27 | 553.97 | 0.00 |
| Gonzalez, Carla, J,18336 | 6145.07 | 0.00 | 3578.27 | 0.00 | 2566.80 |
| Chen, Jon,26920 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Navarro, Erik, E,25055 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Rai, Tracy, K,17079 | 4417.75 | 3578.27 | 0.00 | 0.00 | 839.48 |
| Wu, Shannon, F,15268 | 2840.91 | 0.00 | 0.00 | 2071.42 | 769.49 |
| Vance, Meredith, B,20983 | 4178.73 | 0.00 | 3578.27 | 0.00 | 600.46 |
| Raji, Michele,15183 | 4368.70 | 0.00 | 0.00 | 2071.42 | 2297.28 |
| Xu, Clayton, W,25001 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Hernandez, Jill, L,13003 | 230.25 | 0.00 | 0.00 | 6.28 | 223.97 |
| Liang, Vincent,20402 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Raman, Johnathan,19103 | 63.91 | 0.00 | 0.00 | 41.93 | 21.98 |
| Patel, Marco, L,19575 | 60.05 | 0.00 | 0.00 | 23.78 | 36.27 |
| Cai, Warren,24918 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Adams, Amber,26746 | 2001.45 | 0.00 | 0.00 | 782.99 | 1218.46 |
| Sun, Krystal,18908 | 6090.59 | 0.00 | 3578.27 | 2512.32 | 0.00 |
| Serrano, Jacquelyn,21963 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Carlson, Alfredo,16178 | 108.85 | 0.00 | 0.00 | 0.00 | 108.85 |
| Chandra, Gerald,25131 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Zhao, Laura, T,24589 | 68.97 | 0.00 | 0.00 | 68.97 | 0.00 |
| Huang, Colleen, S,21379 | 2992.33 | 0.00 | 2443.35 | 0.00 | 548.98 |
| Lal, Alisha, C,21872 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Yuan, Franklin,24594 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Huang, Rosa, P,15181 | 4448.38 | 0.00 | 0.00 | 2071.42 | 2376.96 |
| Gomez, Carrie,22965 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Rodriguez, Douglas, W,19652 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Lee, David, J,22199 | 4693.88 | 0.00 | 0.00 | 2181.56 | 2512.32 |
| Perez, Martin,19577 | 6037.89 | 0.00 | 3578.27 | 0.00 | 2459.62 |
| Thompson, Justin,22954 | 4179.33 | 0.00 | 0.00 | 4179.33 | 0.00 |
| Shan, Kristin,23416 | 3598.83 | 0.00 | 0.00 | 3598.83 | 0.00 |
| Martinez, Ethan, C,20260 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Zheng, Jenny, R,11947 | 4747.30 | 0.00 | 3374.99 | 629.96 | 742.35 |
| Diaz, Gary,27482 | 38.98 | 0.00 | 0.00 | 38.98 | 0.00 |
| Jimenez, Victor,11461 | 8089.04 | 0.00 | 3374.99 | 2294.99 | 2419.06 |
| Liang, Alejandro, W,29193 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Ward, Haley, J,16631 | 5900.55 | 3578.27 | 0.00 | 0.00 | 2322.28 |
| Alonso, Kristine,16686 | 4157.73 | 3578.27 | 0.00 | 0.00 | 579.46 |
| Guo, Tiffany,25927 | 1272.52 | 0.00 | 699.10 | 0.00 | 573.42 |
| Browning, Javier,23120 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Liu, Suzanne,19594 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Navarro, Jaime, T,27690 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Gomez, Alfredo, C,18200 | 4150.53 | 0.00 | 3578.27 | 0.00 | 572.26 |
| Hall, Amanda,26656 | 1345.95 | 0.00 | 0.00 | 1345.95 | 0.00 |
| Ortega, Reginald, K,26429 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Ross, Arianna, E,26774 | 1331.97 | 0.00 | 0.00 | 1331.97 | 0.00 |
| Vazquez, Janet, R,21973 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Natsuhara, Tony,23097 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| He, Jon, L,14262 | 5652.54 | 0.00 | 0.00 | 2071.42 | 3581.12 |
| Wood, Jacqueline,16705 | 97.96 | 0.00 | 0.00 | 0.00 | 97.96 |
| Nath, Kara, S,21177 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Chandra, Tina, S,13974 | 5237.73 | 0.00 | 0.00 | 2071.42 | 3166.31 |
| Shan, Yolanda,12702 | 6911.10 | 0.00 | 0.00 | 2049.10 | 4862.00 |
| Suri, Troy, M,12251 | 3924.97 | 0.00 | 3374.99 | 0.00 | 549.98 |
| Lin, Suzanne,29287 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Jai, Jodi, M,27971 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Ramos, Kristine,17479 | 163.40 | 0.00 | 0.00 | 0.00 | 163.40 |
| Suarez, Nelson,27355 | 1383.45 | 0.00 | 0.00 | 782.99 | 600.46 |
| Guo, Clarence,20265 | 32.28 | 0.00 | 0.00 | 32.28 | 0.00 |
| Shan, Derek, R,19782 | 6089.59 | 0.00 | 3578.27 | 0.00 | 2511.32 |
| Zhou, Jon, L,11060 | 8153.02 | 3399.99 | 0.00 | 2319.99 | 2433.04 |
| Raje, Marshall, J,19267 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Chander, Russell, E,29067 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Suarez, Erika,15120 | 5217.70 | 0.00 | 0.00 | 2049.10 | 3168.60 |
| Fernandez, Ivan,22032 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Reed, Steven,24373 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Chander, Marshall,19090 | 59.26 | 0.00 | 0.00 | 2.29 | 56.97 |
| Gutierrez, Latasha, C,15022 | 2999.91 | 0.00 | 0.00 | 2071.42 | 928.49 |
| Smith, Arthur,18240 | 6098.58 | 0.00 | 3578.27 | 2520.31 | 0.00 |
| Nath, Louis, C,25830 | 1833.57 | 0.00 | 699.10 | 0.00 | 1134.47 |
| Ms., Sanchez, Madalena, J.,13020 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Ye, Leah,11077 | 8169.03 | 0.00 | 3374.99 | 2374.98 | 2419.06 |
| Blanco, Krista, L,27580 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Nath, Ricardo, C,12039 | 8213.00 | 0.00 | 3374.99 | 0.00 | 4838.01 |
| Lal, Andres, L,16623 | 5973.24 | 3578.27 | 0.00 | 0.00 | 2394.97 |
| Nath, Cassie,24606 | 2155.92 | 0.00 | 1000.44 | 1155.48 | 0.00 |
| Madan, Denise, R,25248 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Lopez, Stanley, M,28962 | 2477.53 | 0.00 | 0.00 | 0.00 | 2477.53 |
| Mr., Rovira Diez, Pablo,21190 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Yuan, Julie,22959 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Pal, Clayton,27721 | 166.28 | 0.00 | 0.00 | 0.00 | 166.28 |
| Malhotra, Toni,26162 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Jai, Drew, M,21562 | 4632.86 | 0.00 | 2181.56 | 0.00 | 2451.30 |
| Jai, Nichole, R,28348 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Brown, Kaitlyn,29120 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Lopez, Kristina, L,20247 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Nara, Kelsey, A,24905 | 2195.91 | 0.00 | 0.00 | 1000.44 | 1195.47 |
| Vance, Toni, L,23438 | 123.48 | 0.00 | 0.00 | 0.00 | 123.48 |
| Lu, Glenn,12692 | 156.26 | 0.00 | 0.00 | 0.00 | 156.26 |
| Sanz, Larry,14067 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Zheng, Sandra, P,15141 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
Generated 2025-11-03 03:34:10.904 UTC