[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1125 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lopez, Kari,15235 | 190.89 | 0.00 | 0.00 | 0.00 | 190.89 |
| Xu, Martha, C,16351 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Suarez, Orlando,11121 | 58.16 | 0.00 | 0.00 | 0.00 | 58.16 |
| Pal, Casey,16522 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Kapoor, Ruben, D,11109 | 8245.01 | 0.00 | 3374.99 | 2476.96 | 2393.06 |
| Mehta, Marco,11007 | 8211.00 | 3399.99 | 0.00 | 2391.95 | 2419.06 |
| Ye, Christy,14219 | 5744.22 | 0.00 | 0.00 | 2071.42 | 3672.80 |
| Ward, Haley, J,16631 | 5900.55 | 3578.27 | 0.00 | 0.00 | 2322.28 |
| Morgan, Natalie,15149 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Wang, Shannon,11017 | 6434.31 | 3374.99 | 0.00 | 2316.97 | 742.35 |
| Xie, Michele, M,15039 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Fernandez, Brenda, L,16493 | 4197.25 | 3578.27 | 0.00 | 0.00 | 618.98 |
| Kumar, Chad,11095 | 8158.01 | 0.00 | 3374.99 | 2363.96 | 2419.06 |
| Ashe, Ebony, E,16612 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Chandra, Jermaine, A,14299 | 5108.76 | 0.00 | 0.00 | 2071.42 | 3037.34 |
| Suarez, Jacquelyn, C,11010 | 8088.04 | 3399.99 | 0.00 | 2294.99 | 2393.06 |
| Torres, Ruben,11002 | 8114.04 | 3399.99 | 0.00 | 2294.99 | 2419.06 |
| Holt, Krystal,16518 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Raman, Roy,16348 | 5918.24 | 3578.27 | 0.00 | 0.00 | 2339.97 |
| Perez, Arthur, L,16526 | 4758.24 | 3578.27 | 0.00 | 0.00 | 1179.97 |
| Rai, Clarence, D,11018 | 6533.28 | 3399.99 | 0.00 | 2341.97 | 791.32 |
| She, Melvin,16516 | 4733.75 | 3578.27 | 0.00 | 0.00 | 1155.48 |
| Zhang, Warren, L,25252 | 1893.05 | 699.10 | 0.00 | 0.00 | 1193.95 |
| Ramos, Francis,16345 | 4173.24 | 3578.27 | 0.00 | 0.00 | 594.97 |
| Thompson, Cameron, M,16620 | 5895.24 | 3578.27 | 0.00 | 0.00 | 2316.97 |
| Sai, Harold,11026 | 6575.79 | 3399.99 | 0.00 | 0.00 | 3175.80 |
| Gomez, Danny, V,16636 | 5932.74 | 3578.27 | 0.00 | 0.00 | 2354.47 |
| Simmons, Jordyn,16494 | 5961.20 | 3578.27 | 0.00 | 0.00 | 2382.93 |
| Verhoff, Rob,11008 | 8106.31 | 3374.99 | 0.00 | 2312.26 | 2419.06 |
| Tang, Dawn, R,16496 | 5960.23 | 3578.27 | 0.00 | 0.00 | 2381.96 |
| Walker, Anthony, T,25250 | 1883.56 | 699.10 | 0.00 | 0.00 | 1184.46 |
| Chander, Yolanda,16519 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Sharma, Raul, E,16347 | 5918.50 | 3578.27 | 0.00 | 0.00 | 2340.23 |
| Jimenez, Jill,11028 | 6474.62 | 3374.99 | 0.00 | 0.00 | 3099.63 |
| Sutton, Jaime, L,16630 | 5973.24 | 3578.27 | 0.00 | 0.00 | 2394.97 |
| Raman, Shane,16661 | 5908.25 | 3578.27 | 0.00 | 0.00 | 2329.98 |
| Romero, Lawrence, C,16687 | 6070.59 | 3578.27 | 0.00 | 2492.32 | 0.00 |
| Diaz, Gloria,25270 | 1854.58 | 699.10 | 0.00 | 0.00 | 1155.48 |
| Zeng, Claudia, M,16696 | 4506.76 | 3578.27 | 0.00 | 0.00 | 928.49 |
| Xu, Alan,16741 | 6056.61 | 3578.27 | 0.00 | 0.00 | 2478.34 |
| Romero, Renee, E,16639 | 5908.25 | 3578.27 | 0.00 | 0.00 | 2329.98 |
| Rubio, Kendra,17047 | 4347.76 | 3578.27 | 0.00 | 0.00 | 769.49 |
| Perez, Joel,16684 | 4158.24 | 0.00 | 3578.27 | 0.00 | 579.97 |
| Sharma, Sharon, T,25294 | 1882.57 | 699.10 | 0.00 | 0.00 | 1183.47 |
| Powell, Jeremy,11048 | 6498.24 | 0.00 | 3374.99 | 0.00 | 3123.25 |
| Munoz, Deanna,11054 | 8223.02 | 3399.99 | 0.00 | 2403.97 | 2419.06 |
| Shan, Mario,25271 | 1854.58 | 0.00 | 699.10 | 0.00 | 1155.48 |
| Dominguez, Robin,16685 | 4183.23 | 3578.27 | 0.00 | 0.00 | 604.96 |
| Guo, Lacey,16744 | 6070.59 | 0.00 | 3578.27 | 0.00 | 2492.32 |
| She, Alvin, E,16657 | 5900.55 | 0.00 | 3578.27 | 0.00 | 2322.28 |
| Xu, Edwin, J,25272 | 1873.58 | 0.00 | 699.10 | 0.00 | 1174.48 |
| Sai, Preston, D,17046 | 4467.74 | 0.00 | 3578.27 | 0.00 | 889.47 |
| King, Evan,16637 | 5900.55 | 0.00 | 3578.27 | 0.00 | 2322.28 |
| Nara, Tony, L,16713 | 6090.59 | 0.00 | 3578.27 | 0.00 | 2512.32 |
| Cox, Michelle, E,17328 | 4387.74 | 0.00 | 3578.27 | 0.00 | 809.47 |
| Xie, Cristina, C,17050 | 4496.23 | 0.00 | 3578.27 | 0.00 | 917.96 |
| Zhu, Alan,17320 | 4391.74 | 0.00 | 3578.27 | 0.00 | 813.47 |
| Lu, Krystal,17049 | 4347.76 | 0.00 | 3578.27 | 0.00 | 769.49 |
| Kumar, Deborah, K,17308 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Zhang, Ronnie,16656 | 5930.23 | 0.00 | 3578.27 | 0.00 | 2351.96 |
| Watson, Maria,17229 | 4471.74 | 0.00 | 3578.27 | 0.00 | 893.47 |
| Raji, Tammy, K,17071 | 4417.75 | 0.00 | 3578.27 | 0.00 | 839.48 |
| Ferrier, Jaclyn, D,17299 | 4382.75 | 0.00 | 3578.27 | 0.00 | 804.48 |
| Ma, Amy, E,17309 | 6030.61 | 0.00 | 3578.27 | 0.00 | 2452.34 |
| Goel, Carl, S,17249 | 4426.74 | 0.00 | 3578.27 | 0.00 | 848.47 |
| Wang, Alejandro,17310 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Wang, Trisha, V,17259 | 4404.73 | 0.00 | 3578.27 | 0.00 | 826.46 |
| Chande, Dale, K,17242 | 4387.23 | 0.00 | 3578.27 | 0.00 | 808.96 |
| Rana, Darren, M,17257 | 4480.73 | 0.00 | 3578.27 | 0.00 | 902.46 |
| Wilson, Zachary,25558 | 1307.06 | 0.00 | 699.10 | 0.00 | 607.96 |
| Lopez, Luis, P,17334 | 4347.76 | 0.00 | 3578.27 | 0.00 | 769.49 |
| Wu, Micah,17246 | 4380.04 | 0.00 | 3578.27 | 0.00 | 801.77 |
| Price, Isabella, L,17278 | 4382.75 | 0.00 | 3578.27 | 0.00 | 804.48 |
| Green, Jonathan, A,17332 | 4480.73 | 0.00 | 3578.27 | 0.00 | 902.46 |
| Luo, Dustin,17240 | 4385.03 | 0.00 | 3578.27 | 0.00 | 806.76 |
| Green, Fernando,17258 | 4347.76 | 0.00 | 3578.27 | 0.00 | 769.49 |
| Goel, Nichole, A,17277 | 4426.74 | 0.00 | 3578.27 | 0.00 | 848.47 |
| Martin, Joan, R,25556 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Mr., Shakespear, Paul, J.,17326 | 4467.76 | 0.00 | 3578.27 | 0.00 | 889.49 |
| Rodriguez, Pedro, L,17911 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Butler, Jason,17510 | 4369.74 | 0.00 | 3578.27 | 0.00 | 791.47 |
| Diaz, Cheryl, A,11092 | 8110.02 | 0.00 | 3374.99 | 2341.97 | 2393.06 |
| Yuan, Bradley,17920 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Zhou, Louis, C,17912 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Rodriguez, Allen, L,17732 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Suri, Cesar,17512 | 4170.54 | 0.00 | 3578.27 | 592.27 | 0.00 |
| Kumar, Wayne,17502 | 6070.59 | 0.00 | 3578.27 | 0.00 | 2492.32 |
| Yang, Curtis,11110 | 8093.03 | 0.00 | 3399.99 | 0.00 | 4693.04 |
| Vazquez, Kristine, M,17736 | 4742.74 | 0.00 | 3578.27 | 0.00 | 1164.47 |
| Jordan, Ross, F,11124 | 8129.02 | 0.00 | 3399.99 | 2309.97 | 2419.06 |
| Raji, Bradley, E,17925 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Sai, Cesar,18243 | 6058.21 | 0.00 | 3578.27 | 2479.94 | 0.00 |
| Navarro, Bruce, D,17353 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Deng, April,11117 | 8184.99 | 0.00 | 3399.99 | 2365.94 | 2419.06 |
| Serrano, Natasha,25563 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Huang, Brent,18220 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Raje, Cristina, S,17917 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Chandra, Ann,18209 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Goel, Drew,17352 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Zheng, Dennis, E,25567 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Xu, Tracy, L,17916 | 4787.74 | 0.00 | 3578.27 | 0.00 | 1209.47 |
| Fernandez, Candace,11105 | 8095.99 | 0.00 | 3399.99 | 2294.99 | 2401.01 |
| Patel, Douglas,17927 | 4726.04 | 0.00 | 3578.27 | 0.00 | 1147.77 |
| Xie, Karla,18201 | 4157.73 | 0.00 | 3578.27 | 0.00 | 579.46 |
| Suri, Phillip,17914 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Navarro, Kristine, B,25566 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Saunders, Micheal,17513 | 4260.24 | 0.00 | 3578.27 | 681.97 | 0.00 |
| Chander, Alison,18249 | 6044.59 | 0.00 | 3578.27 | 2466.32 | 0.00 |
| Vazquez, Daisy, L,25560 | 1288.06 | 0.00 | 699.10 | 0.00 | 588.96 |
| Torres, Wendy, A,18269 | 6113.20 | 0.00 | 3578.27 | 0.00 | 2534.93 |
| Zeng, Suzanne,17918 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Martin, Larry,18254 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Xu, Lacey, S,17913 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Moreno, Pedro, A,18248 | 6037.89 | 0.00 | 3578.27 | 0.00 | 2459.62 |
| Cai, Tiffany,18204 | 4133.24 | 0.00 | 3578.27 | 0.00 | 554.97 |
| Sanz, Ricky,18251 | 6035.60 | 0.00 | 3578.27 | 2457.33 | 0.00 |
| Lin, Autumn, E,18272 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Suri, Ronald,18214 | 6093.20 | 0.00 | 3578.27 | 2514.93 | 0.00 |
| Powell, Thomas, R,18218 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Mehta, Tina, C,11444 | 8136.02 | 0.00 | 3374.99 | 2376.96 | 2384.07 |
| Nara, Latoya, J,18208 | 6035.60 | 0.00 | 3578.27 | 2457.33 | 0.00 |
| Andersen, Nina,18338 | 6124.58 | 0.00 | 3578.27 | 0.00 | 2546.31 |
| Chapman, Preston, O,18268 | 6102.19 | 0.00 | 3578.27 | 0.00 | 2523.92 |
| Yang, Jamie, S,18465 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
Generated 2025-12-21 22:26:37.036 UTC