[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 500 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Chapman, Alicia, A,21418 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Carlson, Marc, W,17501 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Kumar, Jenny, C,23429 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Alexander, David,15783 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Yuan, Karla, W,13629 | 6889.11 | 0.00 | 0.00 | 2049.10 | 4840.01 |
| Martinez, Frederick,11991 | 8128.02 | 0.00 | 3374.99 | 0.00 | 4753.03 |
| Diaz, Frank, F,29086 | 805.33 | 0.00 | 0.00 | 0.00 | 805.33 |
| Navarro, Eddie, C,24504 | 3563.84 | 0.00 | 0.00 | 2443.35 | 1120.49 |
| Luo, Maurice, C,27491 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Muñoz, Pedro, A,23433 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Alonso, Armando, M,13647 | 6793.15 | 0.00 | 0.00 | 2049.10 | 4744.05 |
| Sanders, Gabriella,11906 | 8151.00 | 0.00 | 3374.99 | 2391.94 | 2384.07 |
| Madan, Meagan,11767 | 8319.51 | 0.00 | 3399.99 | 2475.97 | 2443.55 |
| Suarez, Meghan, L,22177 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Morgan, Melanie,21227 | 26.97 | 0.00 | 0.00 | 0.00 | 26.97 |
| Alonso, Brandi,17061 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Nath, Omar, F,14672 | 5237.72 | 0.00 | 0.00 | 2071.42 | 3166.30 |
| Goel, Mario, J,12360 | 6750.48 | 0.00 | 2071.42 | 0.00 | 4679.06 |
| Sanz, Nelson, M,14056 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Howard, Jesse, D,24249 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Li, Crystal, L,14325 | 5152.70 | 0.00 | 0.00 | 2049.10 | 3103.60 |
| Hernandez, Jill, L,13003 | 230.25 | 0.00 | 0.00 | 6.28 | 223.97 |
| Shan, Jaime,22020 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Sanz, Tabitha,17496 | 110.96 | 0.00 | 0.00 | 0.00 | 110.96 |
| Yang, Wesley, K,15127 | 5182.73 | 0.00 | 0.00 | 2071.42 | 3111.31 |
| Arun, Ross, C,23658 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| She, Christine,16184 | 78.20 | 0.00 | 0.00 | 0.00 | 78.20 |
| Chavez, Corey, R,15731 | 59.98 | 0.00 | 0.00 | 24.99 | 34.99 |
| Navarro, Jacquelyn,15465 | 40.23 | 0.00 | 0.00 | 29.99 | 10.24 |
| Xu, Tracy, L,17916 | 4787.74 | 0.00 | 3578.27 | 0.00 | 1209.47 |
| Ruiz, Sabrina, A,22214 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Zeng, Stacey, J,17317 | 128.95 | 0.00 | 0.00 | 0.00 | 128.95 |
| Sutton, Kern, A,26660 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Price, Isabella, L,17278 | 4382.75 | 3578.27 | 0.00 | 0.00 | 804.48 |
| Vance, Ruth, D,17302 | 147.44 | 0.00 | 0.00 | 58.98 | 88.46 |
| Fernandez, Michele, M,24884 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Johnsen, Willie,15218 | 4399.08 | 0.00 | 0.00 | 2049.10 | 2349.98 |
| Vazquez, Danny, J,26033 | 1903.48 | 0.00 | 782.99 | 0.00 | 1120.49 |
| Tang, Barbara,27711 | 617.47 | 0.00 | 0.00 | 0.00 | 617.47 |
| Yang, Darryl, K,21571 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Williams, Madison, J,21198 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Romero, Walter, A,25020 | 1549.42 | 0.00 | 0.00 | 1000.44 | 548.98 |
| Griffin, Grace,11443 | 8235.00 | 0.00 | 3374.99 | 0.00 | 4860.01 |
| Hernandez, Leslie, D,12990 | 6829.47 | 0.00 | 0.00 | 2071.42 | 4758.05 |
| Pal, Terry, H,25824 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gao, Jamie,26022 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| He, Gilbert,15589 | 4416.38 | 0.00 | 0.00 | 2071.42 | 2344.96 |
| Gill, Lawrence, J,20224 | 44.46 | 0.00 | 0.00 | 0.00 | 44.46 |
| Edwards, Evan, L,21888 | 4925.58 | 0.00 | 2443.35 | 0.00 | 2482.23 |
| Li, David, A,21894 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Coleman, Paige, L,15263 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Chande, Casey,26149 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Jenkins, Amanda,15214 | 4490.88 | 0.00 | 0.00 | 2071.42 | 2419.46 |
| Chen, Crystal, M,26566 | 2016.95 | 0.00 | 0.00 | 782.99 | 1233.96 |
| Huang, Valerie, J,26745 | 1932.46 | 0.00 | 0.00 | 782.99 | 1149.47 |
| Subram, Francisco, A,21897 | 4909.67 | 0.00 | 0.00 | 2443.35 | 2466.32 |
| Serrano, Natasha,25563 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Gutierrez, Tabitha, A,21884 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| She, Jeffery, M,27149 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Blanco, Krista, L,27580 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Perez, Henry,26752 | 1917.46 | 0.00 | 0.00 | 782.99 | 1134.47 |
| Johnson, Sydney,19571 | 90.95 | 0.00 | 0.00 | 33.98 | 56.97 |
| Alan, Jamie, S,21224 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Lopez, Patricia,28305 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Sharma, Corey, M,17495 | 119.91 | 0.00 | 0.00 | 0.00 | 119.91 |
| Wang, Kelvin, S,15143 | 4366.41 | 0.00 | 0.00 | 2071.42 | 2294.99 |
| Serrano, Deanna, W,15144 | 4344.09 | 0.00 | 0.00 | 2049.10 | 2294.99 |
| Ruiz, Marvin, R,18796 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Gonzales, Lucas,29463 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Arthur, Jay, R,12694 | 6785.13 | 0.00 | 2049.10 | 0.00 | 4736.03 |
| Zhang, Clarence, M,13001 | 6799.43 | 0.00 | 0.00 | 2049.10 | 4750.33 |
| Ortega, Tyrone, H,12583 | 2646.40 | 0.00 | 2071.42 | 0.00 | 574.98 |
| Cai, Susan,19101 | 104.42 | 0.00 | 0.00 | 0.00 | 104.42 |
| Fernandez, Marie,28929 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Liang, Eugene,13972 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Rai, Tasha, L,24301 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Zhu, Suzanne, E,25112 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Zhao, Colin, D,24241 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Wang, Lacey,24173 | 2771.52 | 0.00 | 0.00 | 2181.56 | 589.96 |
| Lin, Jake,24248 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Lu, Suzanne, K,16712 | 4417.75 | 3578.27 | 0.00 | 0.00 | 839.48 |
| She, Bridget, M,19557 | 5358.24 | 0.00 | 3578.27 | 0.00 | 1779.97 |
| Garcia, Carolyn,20999 | 2735.53 | 0.00 | 2181.56 | 0.00 | 553.97 |
| Alan, Meghan, I,28210 | 564.48 | 0.00 | 0.00 | 0.00 | 564.48 |
| Gao, Wesley,12346 | 6864.46 | 0.00 | 2071.42 | 0.00 | 4793.04 |
| Raman, Frederick, F,28942 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Stone, Colin, K,12673 | 6768.14 | 0.00 | 2049.10 | 0.00 | 4719.04 |
| Martin, Justin,23542 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Ma, Roger, V,15130 | 5215.40 | 0.00 | 0.00 | 2049.10 | 3166.30 |
| Huang, Rosa, P,15181 | 4448.38 | 0.00 | 0.00 | 2071.42 | 2376.96 |
| Raman, Abby, T,15122 | 5193.72 | 0.00 | 0.00 | 2071.42 | 3122.30 |
| Ortega, Latasha,24270 | 2844.51 | 0.00 | 0.00 | 2181.56 | 662.95 |
| Serrano, Anne,24244 | 3617.83 | 0.00 | 0.00 | 2443.35 | 1174.48 |
| Gomez, Teresa, D,24164 | 2760.02 | 0.00 | 0.00 | 2181.56 | 578.46 |
| Gao, Randy,25113 | 2180.41 | 0.00 | 0.00 | 1000.44 | 1179.97 |
| Perez, Bryant, L,15042 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Raji, Jaime, L,15037 | 3856.38 | 0.00 | 0.00 | 2071.42 | 1784.96 |
| Li, Edwin,26967 | 1336.96 | 0.00 | 0.00 | 1336.96 | 0.00 |
| Andersen, Brendan,15121 | 5202.73 | 0.00 | 0.00 | 2071.42 | 3131.31 |
| Rai, Raul, R,15133 | 5237.73 | 0.00 | 0.00 | 2071.42 | 3166.31 |
| Huang, Lacey, J,11951 | 63.52 | 0.00 | 0.00 | 0.00 | 63.52 |
| Prasad, Ebony,24368 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Kovar, Mayra, J,17312 | 4471.74 | 3578.27 | 0.00 | 0.00 | 893.47 |
| Yuan, Christine,11046 | 6616.81 | 3374.99 | 0.00 | 0.00 | 3241.82 |
| Hernandez, Diana, F,11038 | 6437.33 | 3374.99 | 0.00 | 0.00 | 3062.34 |
| Guo, Lisa, S,17314 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Ruiz, Francis, D,21381 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Schmidt, Danny, M,28926 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Srini, Candace,15437 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Sara, Ross,24367 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Yang, Clarence, D,25121 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Srini, Manuel,24168 | 2790.52 | 0.00 | 0.00 | 2181.56 | 608.96 |
| Raman, Ruben,15580 | 2910.90 | 0.00 | 0.00 | 2071.42 | 839.48 |
| Sanchez, Andre,15595 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Bhat, Yolanda,15225 | 4401.41 | 0.00 | 0.00 | 2071.42 | 2329.99 |
| Wu, Shannon, F,15268 | 2840.91 | 0.00 | 0.00 | 2071.42 | 769.49 |
| Sai, Ann,27339 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Suri, Patricia, E,15436 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Alonso, Meghan, A,24457 | 3356.04 | 0.00 | 0.00 | 2181.56 | 1174.48 |
| Rai, Calvin,15229 | 2833.57 | 0.00 | 0.00 | 2049.10 | 784.47 |
| Deng, Priscilla, M,25127 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Deng, Kate, L,15723 | 4444.07 | 0.00 | 0.00 | 2049.10 | 2394.97 |
| Rodriguez, Frederick, S,24458 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Subram, Douglas,27352 | 1357.97 | 0.00 | 0.00 | 782.99 | 574.98 |
Generated 2025-11-03 21:39:56.094 UTC