[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 1 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Alvarez, Carrie, W,23410 | 4016.53 | 0.00 | 0.00 | 2181.56 | 1834.97 |
| Moyer, Mario,23420 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Rai, Bradley,19100 | 79.26 | 0.00 | 0.00 | 0.00 | 79.26 |
| Ortega, Julio, M,11892 | 8119.03 | 0.00 | 3399.99 | 0.00 | 4719.04 |
| Alonso, Sheila,25054 | 103.48 | 0.00 | 0.00 | 0.00 | 103.48 |
| Zeng, Cara,20444 | 6085.59 | 0.00 | 3578.27 | 0.00 | 2507.32 |
| Deng, Barbara,20445 | 6078.71 | 0.00 | 3578.27 | 0.00 | 2500.44 |
| Zhang, Claudia,13114 | 6807.45 | 0.00 | 0.00 | 2071.42 | 4736.03 |
| Hu, Alejandro,13125 | 138.54 | 0.00 | 0.00 | 0.00 | 138.54 |
| Munoz, Craig, V,13076 | 6862.14 | 0.00 | 0.00 | 2049.10 | 4813.04 |
| Allen, Logan,15812 | 81.25 | 0.00 | 0.00 | 0.00 | 81.25 |
| Morgan, Nathaniel, E,16626 | 71.57 | 0.00 | 0.00 | 36.59 | 34.98 |
| Chande, Alvin, W,24893 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Perez, Brett, M,28313 | 647.94 | 0.00 | 0.00 | 0.00 | 647.94 |
| Sara, Ann, A,23576 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Tang, Julie,26589 | 1966.46 | 0.00 | 0.00 | 782.99 | 1183.47 |
| Rubio, Bruce, E,23343 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Yuan, Mitchell,26744 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Xu, Cara,23526 | 3563.84 | 0.00 | 0.00 | 3563.84 | 0.00 |
| Powell, Alexis, M,23531 | 3337.28 | 0.00 | 0.00 | 3337.28 | 0.00 |
| Chandra, Arthur, L,14032 | 6859.43 | 0.00 | 0.00 | 2071.42 | 4788.01 |
| Martinez, Brett,23532 | 3337.04 | 0.00 | 0.00 | 3337.04 | 0.00 |
| Lin, Mandy, C,25035 | 2183.91 | 0.00 | 0.00 | 1000.44 | 1183.47 |
| Zhou, Krystal,23593 | 3990.01 | 0.00 | 0.00 | 2181.56 | 1808.45 |
| Anand, Johnny,14058 | 5652.52 | 0.00 | 0.00 | 3355.24 | 2297.28 |
| Hernandez, Alberto, D,25029 | 2272.20 | 0.00 | 0.00 | 1000.44 | 1271.76 |
| Zheng, Edwin, J,14216 | 5653.92 | 0.00 | 0.00 | 2049.10 | 3604.82 |
| Nath, Rafael,23533 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Li, Jack, J,14071 | 5617.92 | 0.00 | 0.00 | 2049.10 | 3568.82 |
| Luo, Johnny,21359 | 3032.31 | 0.00 | 2443.35 | 0.00 | 588.96 |
| Huang, Colleen, S,21379 | 2992.33 | 0.00 | 2443.35 | 0.00 | 548.98 |
| Andersen, Carl, J,11057 | 8088.04 | 3374.99 | 0.00 | 2319.99 | 2393.06 |
| Martinez, Kari,19609 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Chow, Christy, M,12681 | 6784.13 | 0.00 | 2049.10 | 0.00 | 4735.03 |
| Lal, Shaun, H,17056 | 4417.75 | 3578.27 | 0.00 | 0.00 | 839.48 |
| Martin, Ruben,22400 | 2737.82 | 0.00 | 0.00 | 2181.56 | 556.26 |
| Mehta, Mayra,12998 | 5694.90 | 0.00 | 0.00 | 2049.10 | 3645.80 |
| Yang, Stacey,14215 | 5665.89 | 0.00 | 0.00 | 2049.10 | 3616.79 |
| 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 |
| Kumar, Warren, A,24003 | 2806.53 | 0.00 | 0.00 | 2181.56 | 624.97 |
| Raman, Deanna, H,17053 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| 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 |
| Lin, Ronnie, D,21384 | 2921.02 | 0.00 | 2181.56 | 0.00 | 739.46 |
| 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 |
| Serrano, Anne,24244 | 3617.83 | 0.00 | 0.00 | 2443.35 | 1174.48 |
| Goel, Karl,18705 | 59.26 | 0.00 | 0.00 | 0.00 | 59.26 |
| Subram, Meredith, S,14261 | 5653.92 | 0.00 | 0.00 | 2049.10 | 3604.82 |
| Alvarez, Mathew, L,17494 | 111.96 | 0.00 | 0.00 | 0.00 | 111.96 |
| Sara, Cesar, C,22172 | 2932.30 | 0.00 | 0.00 | 2181.56 | 750.74 |
| Ramos, Marie, A,14308 | 5140.40 | 0.00 | 0.00 | 2049.10 | 3091.30 |
| Sai, Rachael,11912 | 8095.32 | 0.00 | 3374.99 | 0.00 | 4720.33 |
| Dominguez, Neil, K,23663 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Wu, Amy,19790 | 6089.59 | 0.00 | 3578.27 | 0.00 | 2511.32 |
| Li, Vincent, D,21207 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| 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 |
| Shen, Brendan, L,14305 | 3652.20 | 0.00 | 0.00 | 2049.10 | 1603.10 |
| Richardson, Abigail, S,14236 | 5710.23 | 0.00 | 0.00 | 2071.42 | 3638.81 |
| Goel, Tara, I,14347 | 2900.39 | 0.00 | 0.00 | 2071.42 | 828.97 |
| Zhang, Damien, C,26758 | 1322.98 | 0.00 | 0.00 | 1322.98 | 0.00 |
| Lal, Cristina, M,14671 | 2934.37 | 0.00 | 0.00 | 2071.42 | 862.95 |
| Luo, Christine, J,24159 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Lin, Sandra, A,25052 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Shan, Tasha,15192 | 4384.08 | 0.00 | 0.00 | 2049.10 | 2334.98 |
| Lu, Crystal, A,15145 | 4368.70 | 0.00 | 0.00 | 2071.42 | 2297.28 |
| Gill, Gina, F,24177 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Jones, Destiny,15171 | 4392.02 | 0.00 | 0.00 | 2049.10 | 2342.92 |
| Chander, Melvin, L,24266 | 2749.32 | 0.00 | 0.00 | 2181.56 | 567.76 |
| Raje, Kurt,15210 | 2926.39 | 0.00 | 0.00 | 2071.42 | 854.97 |
| 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 |
| Jai, Katrina,13044 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Moreno, Leslie, C,11114 | 122.89 | 0.00 | 0.00 | 7.95 | 114.94 |
| Madan, Geoffrey, M,15241 | 51.91 | 0.00 | 0.00 | 0.00 | 51.91 |
| Alvarez, Roy, A,16709 | 143.94 | 0.00 | 0.00 | 0.00 | 143.94 |
| Liu, Bianca, K,11458 | 31.92 | 0.00 | 0.00 | 0.00 | 31.92 |
| Deng, Colin, B,18299 | 32.22 | 0.00 | 0.00 | 0.00 | 32.22 |
| Martin, Diane,13958 | 6838.64 | 0.00 | 0.00 | 2049.10 | 4789.54 |
| Sanchez, Patrick, W,24382 | 143.78 | 0.00 | 0.00 | 0.00 | 143.78 |
| She, Ricardo, A,14233 | 78.97 | 0.00 | 0.00 | 0.00 | 78.97 |
| Ashe, Maurice,20430 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Goel, Jodi,20447 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Serrano, Diane, E,14857 | 87.97 | 0.00 | 0.00 | 78.98 | 8.99 |
| Jones, Ethan,13051 | 6831.74 | 0.00 | 0.00 | 2071.42 | 4760.32 |
| Ruiz, Krista, C,13081 | 6772.15 | 0.00 | 0.00 | 2049.10 | 4723.05 |
| Gutierrez, Lawrence, M,19564 | 5293.24 | 0.00 | 3578.27 | 0.00 | 1714.97 |
| Goel, Alejandro, K,13077 | 6766.63 | 0.00 | 0.00 | 2049.10 | 4717.53 |
| Jimenez, Naomi,24922 | 2145.92 | 0.00 | 0.00 | 1000.44 | 1145.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 |
| 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 |
| 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 |
Generated 2025-11-03 15:27:18.186 UTC