[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SKIP 0 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Alvarez, Albert, R,16624 | 5938.25 | 3578.27 | 0.00 | 0.00 | 2359.98 |
| Raji, Misty,16520 | 4727.74 | 3578.27 | 0.00 | 0.00 | 1149.47 |
| Gonzales, Logan,16607 | 5897.53 | 3578.27 | 0.00 | 0.00 | 2319.26 |
| Pal, Casey,16522 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Torres, Ruben,11002 | 8114.04 | 3399.99 | 0.00 | 4714.05 | 0.00 |
| Mehta, Marco,11007 | 8211.00 | 3399.99 | 0.00 | 4811.01 | 0.00 |
| Ward, Haley, J,16631 | 5900.55 | 3578.27 | 0.00 | 0.00 | 2322.28 |
| Raman, Roy,16348 | 5918.24 | 3578.27 | 0.00 | 0.00 | 2339.97 |
| Lal, Andres, L,16623 | 5973.24 | 3578.27 | 0.00 | 0.00 | 2394.97 |
| Ramos, Francis,16345 | 4173.24 | 3578.27 | 0.00 | 0.00 | 594.97 |
| Simmons, Jordyn,16494 | 5961.20 | 3578.27 | 0.00 | 0.00 | 2382.93 |
| Alvarez, Janet, G,11006 | 8119.03 | 3399.99 | 0.00 | 2334.97 | 2384.07 |
| Verhoff, Rob,11008 | 8106.31 | 3374.99 | 0.00 | 4731.32 | 0.00 |
| Sharma, Raul, E,16347 | 5918.50 | 3578.27 | 0.00 | 0.00 | 2340.23 |
| Carlson, Shannon, C,11009 | 8091.33 | 3374.99 | 0.00 | 2297.28 | 2419.06 |
| Diaz, Gloria,25270 | 1854.58 | 699.10 | 0.00 | 0.00 | 1155.48 |
| Xu, Alan,16741 | 6056.61 | 3578.27 | 0.00 | 2478.34 | 0.00 |
| Ramos, Theresa, G,11031 | 6478.60 | 3399.99 | 0.00 | 0.00 | 3078.61 |
| Jones, Emily,16659 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Ortega, Jessie, J,17051 | 6060.50 | 3578.27 | 0.00 | 0.00 | 2482.23 |
| Munoz, Deanna,11054 | 8223.02 | 3399.99 | 0.00 | 2403.97 | 2419.06 |
| Romero, Renee, E,16639 | 5908.25 | 3578.27 | 0.00 | 0.00 | 2329.98 |
| Yuan, Christine,11046 | 6616.81 | 3374.99 | 0.00 | 0.00 | 3241.82 |
| Moreno, Krista, J,16745 | 6021.62 | 3578.27 | 0.00 | 2443.35 | 0.00 |
| Powell, Jeremy,11048 | 6498.24 | 3374.99 | 0.00 | 0.00 | 3123.25 |
| Nelson, Sophia,16664 | 4377.75 | 3578.27 | 0.00 | 799.48 | 0.00 |
| Lu, Rosa, A,16663 | 4471.74 | 3578.27 | 0.00 | 893.47 | 0.00 |
| Goel, Derek,17045 | 4480.73 | 3578.27 | 0.00 | 0.00 | 902.46 |
| Xu, Edwin, J,25272 | 1873.58 | 699.10 | 0.00 | 0.00 | 1174.48 |
| Nara, Tony, L,16713 | 6090.59 | 3578.27 | 0.00 | 2512.32 | 0.00 |
| Xie, Cristina, C,17050 | 4496.23 | 3578.27 | 0.00 | 0.00 | 917.96 |
| Jimenez, Gary, E,16609 | 344.04 | 0.00 | 0.00 | 84.95 | 259.09 |
| Sai, Ann,27339 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Madan, Toni,26668 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Chen, Willie, C,28322 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Ramos, Briana, J,14303 | 3636.91 | 0.00 | 0.00 | 2049.10 | 1587.81 |
| Shen, Priscilla, A,28215 | 589.96 | 0.00 | 0.00 | 0.00 | 589.96 |
| Ramos, Joe,12353 | 6765.46 | 0.00 | 2071.42 | 0.00 | 4694.04 |
| Zhang, Ronnie,16656 | 5930.23 | 3578.27 | 0.00 | 0.00 | 2351.96 |
| Ma, Amy, E,17309 | 6030.61 | 3578.27 | 0.00 | 0.00 | 2452.34 |
| She, Willie,17055 | 4347.76 | 3578.27 | 0.00 | 0.00 | 769.49 |
| Diaz, Marc,11058 | 8248.02 | 3399.99 | 0.00 | 2374.98 | 2473.05 |
| Arun, Ruth, S,17294 | 4355.71 | 3578.27 | 0.00 | 0.00 | 777.44 |
| Moore, Michael,17247 | 4432.72 | 3578.27 | 0.00 | 0.00 | 854.45 |
| Beck, Alicia, L,17248 | 4382.75 | 3578.27 | 0.00 | 0.00 | 804.48 |
| Rana, Darren, M,17257 | 4480.73 | 3578.27 | 0.00 | 0.00 | 902.46 |
| Sharma, Terrence, N,17351 | 6117.69 | 3578.27 | 0.00 | 0.00 | 2539.42 |
| Green, Jonathan, A,17332 | 4480.73 | 3578.27 | 0.00 | 0.00 | 902.46 |
| Nath, Carly, J,17255 | 4442.24 | 3578.27 | 0.00 | 0.00 | 863.97 |
| Green, Fernando,17258 | 4347.76 | 3578.27 | 0.00 | 0.00 | 769.49 |
| Wilson, Jasmine,17329 | 6021.62 | 3578.27 | 0.00 | 0.00 | 2443.35 |
| Jimenez, Walter,17232 | 4347.76 | 3578.27 | 0.00 | 0.00 | 769.49 |
| Rubio, Randall, M,17286 | 6029.57 | 3578.27 | 0.00 | 0.00 | 2451.30 |
| Sanchez, Troy, H,25559 | 1253.07 | 699.10 | 0.00 | 0.00 | 553.97 |
| Torres, Dwayne, R,17288 | 4426.24 | 0.00 | 3578.27 | 0.00 | 847.97 |
| Mr., Shakespear, Paul, J.,17326 | 4467.76 | 0.00 | 3578.27 | 0.00 | 889.49 |
| Luo, Casey,11072 | 8194.00 | 0.00 | 3399.99 | 2395.96 | 2398.05 |
| Wang, Jeffery, E,18188 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Garcia, Ivan, L,17354 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Ross, Adam,11099 | 8215.99 | 0.00 | 3399.99 | 2363.96 | 2452.04 |
| Vazquez, Kristine, M,17736 | 4742.74 | 0.00 | 3578.27 | 0.00 | 1164.47 |
| Li, Aimee,17915 | 4792.73 | 0.00 | 3578.27 | 0.00 | 1214.46 |
| Serrano, Natasha,25563 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Raje, Cristina, S,17917 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Suri, Cesar,17512 | 4170.54 | 0.00 | 3578.27 | 592.27 | 0.00 |
| Ortega, Joanna,17909 | 4761.74 | 0.00 | 3578.27 | 0.00 | 1183.47 |
| Suri, Phillip,17914 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Saunders, Micheal,17513 | 4260.24 | 0.00 | 3578.27 | 681.97 | 0.00 |
| Xu, Lacey, S,17913 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Lin, Bianca,11107 | 8171.01 | 0.00 | 3374.99 | 2376.96 | 2419.06 |
| Jordan, Ross, F,11124 | 8129.02 | 0.00 | 3399.99 | 2309.97 | 2419.06 |
| Deng, April,11117 | 8184.99 | 0.00 | 3399.99 | 2365.94 | 2419.06 |
| Sharma, Tony,18241 | 6058.21 | 0.00 | 3578.27 | 2479.94 | 0.00 |
| Raji, Lindsey,18205 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Cai, Tiffany,18204 | 4133.24 | 0.00 | 3578.27 | 0.00 | 554.97 |
| Alonso, Danny, S,18217 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Carson, Terrence,11356 | 5069.29 | 0.00 | 3374.99 | 0.00 | 1694.30 |
| Nelson, Fernando, G,25564 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Chapman, Preston, O,18268 | 6102.19 | 0.00 | 3578.27 | 0.00 | 2523.92 |
| Martin, Larry,18254 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Smith, Arthur,18240 | 6098.58 | 0.00 | 3578.27 | 2520.31 | 0.00 |
| Sun, Alvin,18252 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Mehta, Tina, C,11444 | 8136.02 | 0.00 | 3374.99 | 2376.96 | 2384.07 |
| Torres, Kari,18486 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Serrano, Audrey,18337 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Gill, Monique, L,17727 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Price, Megan,24907 | 2183.91 | 0.00 | 0.00 | 1000.44 | 1183.47 |
| Diaz, Samuel,14065 | 5608.55 | 0.00 | 0.00 | 2071.42 | 3537.13 |
| Rai, Alejandro, R,21990 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Lal, Karla,25219 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Xu, Barbara,29195 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Yang, Jamie, S,18465 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Kim, Kari, S,11445 | 8098.03 | 0.00 | 3399.99 | 2304.98 | 2393.06 |
| White, Olivia, E,18457 | 4826.23 | 0.00 | 3578.27 | 0.00 | 1247.96 |
| Townsend, Darren,18467 | 5279.26 | 0.00 | 3578.27 | 1700.99 | 0.00 |
| Romero, Wendy, H,11372 | 4965.81 | 0.00 | 3374.99 | 0.00 | 1590.82 |
| Taylor, Jennifer,18470 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Deng, Carl,18284 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Sanchez, Joel,18468 | 5333.25 | 0.00 | 3578.27 | 1754.98 | 0.00 |
| McDonald, Kaitlin,18493 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Serrano, Shannon, R,18303 | 6030.61 | 0.00 | 3578.27 | 2452.34 | 0.00 |
| Lal, Tara, S,18697 | 5279.26 | 0.00 | 3578.27 | 1700.99 | 0.00 |
| Lal, Kenneth, J,18701 | 5357.74 | 0.00 | 3578.27 | 1779.47 | 0.00 |
| Hu, Alvin, E,11449 | 8130.32 | 0.00 | 3374.99 | 2362.27 | 2393.06 |
| Suri, Toni,18464 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Miller, Edward,11368 | 5106.24 | 0.00 | 3374.99 | 0.00 | 1731.25 |
| Roberts, Jennifer,11447 | 8078.02 | 0.00 | 3374.99 | 2309.97 | 2393.06 |
| Murphy, Seth, A,25704 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Hill, Adam,18740 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Gonzales, Victoria,11751 | 8215.02 | 0.00 | 3399.99 | 2430.96 | 2384.07 |
| Rubio, Erika, A,11452 | 8183.04 | 0.00 | 3374.99 | 2414.99 | 2393.06 |
| Campbell, Seth,18716 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Gomez, Andy,18721 | 5333.25 | 0.00 | 3578.27 | 1754.98 | 0.00 |
| Gutierrez, Darren, A,25714 | 1308.06 | 0.00 | 699.10 | 0.00 | 608.96 |
| Rivera, Steven, T,19083 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Zheng, Darryl,18706 | 6060.50 | 0.00 | 3578.27 | 2482.23 | 0.00 |
| Lin, Laura, L,11462 | 8116.33 | 0.00 | 3374.99 | 2322.28 | 2419.06 |
| Gao, Jon, C,11456 | 8224.46 | 0.00 | 3399.99 | 2391.43 | 2433.04 |
| Guo, Ernest,25717 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Garcia, Donald,18929 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Fernandez, Denise, A,18724 | 6056.51 | 0.00 | 3578.27 | 2478.24 | 0.00 |
| Parker, Evan, R,18729 | 5333.25 | 0.00 | 3578.27 | 1754.98 | 0.00 |
| Huang, Alejandro,11464 | 8128.51 | 0.00 | 3374.99 | 2334.46 | 2419.06 |
| Sun, Krystal,18908 | 6090.59 | 0.00 | 3578.27 | 2512.32 | 0.00 |
| Gomez, Ricky,18737 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
Generated 2025-11-01 04:32:49.711 UTC