[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 | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Nara, Clayton,11768 | 8139.04 | 0.00 | 3399.99 | 2319.99 | 2419.06 |
| Madan, Henry, E,17283 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Mehta, Erick, E,14123 | 61.58 | 0.00 | 0.00 | 28.98 | 32.60 |
| Xu, Karl,23321 | 3060.82 | 0.00 | 0.00 | 2443.35 | 617.47 |
| Allen, Hailey, C,26759 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Martinez, Emmanuel, V,21370 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Powell, Lucas, T,18278 | 158.95 | 0.00 | 0.00 | 123.96 | 34.99 |
| Zheng, Jeffery, W,15030 | 3786.39 | 0.00 | 0.00 | 2071.42 | 1714.97 |
| Rodriguez, Jarrod,13636 | 6831.76 | 0.00 | 0.00 | 2071.42 | 4760.34 |
| Shan, Peter,24280 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Diaz, Rebekah, J,21378 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Evans, Carlos, J,23538 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Lu, Curtis,11011 | 8133.04 | 3399.99 | 0.00 | 4733.05 | 0.00 |
| Gonzales, Logan,16607 | 5897.53 | 3578.27 | 0.00 | 0.00 | 2319.26 |
| Ward, Haley, J,16631 | 5900.55 | 3578.27 | 0.00 | 0.00 | 2322.28 |
| Liang, Kelvin, L,16616 | 5915.54 | 3578.27 | 0.00 | 0.00 | 2337.27 |
| Wang, Shannon,11017 | 6434.31 | 3374.99 | 0.00 | 2316.97 | 742.35 |
| Ashe, Ebony, E,16612 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Holt, Krystal,16518 | 4698.76 | 3578.27 | 0.00 | 1120.49 | 0.00 |
| Perez, Arthur, L,16526 | 4758.24 | 3578.27 | 0.00 | 0.00 | 1179.97 |
| Zhao, Jessie, R,11027 | 6591.57 | 3399.99 | 0.00 | 0.00 | 3191.58 |
| Sai, Troy,16515 | 4733.75 | 3578.27 | 0.00 | 1155.48 | 0.00 |
| Lal, Dustin, A,16484 | 4175.53 | 3578.27 | 0.00 | 0.00 | 597.26 |
| Yang, Jon, V,11000 | 8248.99 | 3399.99 | 0.00 | 4849.00 | 0.00 |
| Huang, Sandra, C,16523 | 4698.76 | 3578.27 | 0.00 | 1120.49 | 0.00 |
| Alvarez, Janet, G,11006 | 8119.03 | 3399.99 | 0.00 | 2334.97 | 2384.07 |
| Walker, Anthony, T,25250 | 1883.56 | 699.10 | 0.00 | 0.00 | 1184.46 |
| 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 |
| Stewart, Ariana,16743 | 6070.59 | 3578.27 | 0.00 | 2492.32 | 0.00 |
| Lewis, Justin, L,28303 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Jimenez, Latasha, E,13121 | 121.25 | 0.00 | 0.00 | 54.99 | 66.26 |
| Hu, Dennis, J,20600 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Jackson, Joshua,17235 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Morris, Eduardo,19619 | 112.75 | 0.00 | 0.00 | 88.97 | 23.78 |
| Andersen, Jenny,20259 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Russell, Seth,25138 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Sai, Ann,27339 | 1336.96 | 0.00 | 0.00 | 1336.96 | 0.00 |
| Brown, Cameron, D,13041 | 153.95 | 0.00 | 0.00 | 88.98 | 64.97 |
| Sanz, Eddie, A,19580 | 173.93 | 0.00 | 0.00 | 53.99 | 119.94 |
| Serrano, Max, E,12010 | 8203.50 | 0.00 | 3374.99 | 2384.96 | 2443.55 |
| Liang, Tiffany,11068 | 113.36 | 0.00 | 0.00 | 38.47 | 74.89 |
| Sanz, Reginald, K,17522 | 74.95 | 0.00 | 0.00 | 0.00 | 74.95 |
| Nath, Rafael,23533 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Kumar, Robert,25226 | 2158.90 | 0.00 | 0.00 | 1000.44 | 1158.46 |
| Garcia, Sarah,11907 | 8135.33 | 0.00 | 3399.99 | 2297.28 | 2438.06 |
| Perez, Whitney,16619 | 97.58 | 0.00 | 0.00 | 67.59 | 29.99 |
| Chandra, Gerald,25131 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gao, Stacey,16662 | 4355.71 | 3578.27 | 0.00 | 777.44 | 0.00 |
| Diaz, Gloria,25270 | 1854.58 | 699.10 | 0.00 | 0.00 | 1155.48 |
| Munoz, Deanna,11054 | 8223.02 | 3399.99 | 0.00 | 2403.97 | 2419.06 |
| Arthur, Kristi, W,16675 | 4385.03 | 3578.27 | 0.00 | 806.76 | 0.00 |
| Lu, Suzanne, K,16712 | 4417.75 | 3578.27 | 0.00 | 839.48 | 0.00 |
| Yuan, Bethany, G,11030 | 6471.32 | 3399.99 | 0.00 | 0.00 | 3071.33 |
| Perez, Joel,16684 | 4158.24 | 3578.27 | 0.00 | 0.00 | 579.97 |
| She, Alvin, E,16657 | 5900.55 | 3578.27 | 0.00 | 0.00 | 2322.28 |
| Powell, Jeremy,11048 | 6498.24 | 3374.99 | 0.00 | 0.00 | 3123.25 |
| Scott, Savannah, E,16929 | 4733.75 | 3578.27 | 0.00 | 0.00 | 1155.48 |
| Nath, Jaime,11033 | 6495.29 | 3374.99 | 0.00 | 0.00 | 3120.30 |
| Lopez, Heidi,11052 | 8131.32 | 3374.99 | 0.00 | 2337.27 | 2419.06 |
| Lee, Dalton, J,16931 | 4767.73 | 3578.27 | 0.00 | 0.00 | 1189.46 |
| Lu, Rosa, A,16663 | 4471.74 | 3578.27 | 0.00 | 893.47 | 0.00 |
| Sanz, Kellie,16708 | 4406.74 | 3578.27 | 0.00 | 828.47 | 0.00 |
| Goel, Derek,17045 | 4480.73 | 3578.27 | 0.00 | 902.46 | 0.00 |
| Serrano, Derrick,16707 | 4377.75 | 3578.27 | 0.00 | 799.48 | 0.00 |
| Pal, Mitchell, R,16742 | 6044.59 | 3578.27 | 0.00 | 2466.32 | 0.00 |
| Xie, Cristina, C,17050 | 4496.23 | 3578.27 | 0.00 | 0.00 | 917.96 |
| Lu, Krystal,17049 | 4347.76 | 3578.27 | 0.00 | 0.00 | 769.49 |
| Wang, Alan,13622 | 6841.43 | 0.00 | 0.00 | 2071.42 | 4770.01 |
| Navarro, Daisy,27514 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Ruiz, Melody,13621 | 167.40 | 0.00 | 0.00 | 0.00 | 167.40 |
| Zhu, Jamie, J,13140 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Smith, Allen,14072 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Shan, Bridget,29338 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Madan, Geoffrey, M,15241 | 51.91 | 0.00 | 0.00 | 0.00 | 51.91 |
| Liu, Karen, F,14008 | 63.97 | 0.00 | 0.00 | 34.99 | 28.98 |
| Carlson, Lance, E,22856 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Liu, Bianca, K,11458 | 31.92 | 0.00 | 0.00 | 23.97 | 7.95 |
| 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 |
| Sai, Ronald, B,13643 | 6799.45 | 0.00 | 0.00 | 2071.42 | 4728.03 |
| Goel, Bethany,27511 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| 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 |
| Goel, Jodi,20447 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Ma, Amy, E,17309 | 6030.61 | 3578.27 | 0.00 | 0.00 | 2452.34 |
| Kumar, Deborah, K,17308 | 6021.62 | 3578.27 | 0.00 | 0.00 | 2443.35 |
| 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 |
| Goel, Carl, S,17249 | 4426.74 | 3578.27 | 0.00 | 0.00 | 848.47 |
| Rana, Darren, M,17257 | 4480.73 | 3578.27 | 0.00 | 0.00 | 902.46 |
| Zhou, Jon, L,11060 | 8153.02 | 3399.99 | 0.00 | 2319.99 | 2433.04 |
| 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 |
| Goel, Nichole, A,17277 | 4426.74 | 3578.27 | 0.00 | 0.00 | 848.47 |
| Kumar, Chad,11095 | 8158.01 | 3374.99 | 0.00 | 2363.96 | 2419.06 |
| Torres, Gina,17904 | 4733.75 | 3578.27 | 0.00 | 0.00 | 1155.48 |
| Kapoor, Veronica, G,20253 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Ramos, Roberto, M,13159 | 208.18 | 0.00 | 0.00 | 0.00 | 208.18 |
| Goel, Bradley,15803 | 66.26 | 0.00 | 0.00 | 0.00 | 66.26 |
| Yuan, Roger,19622 | 61.75 | 0.00 | 0.00 | 0.00 | 61.75 |
| Chen, Rosa,23435 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Sullivan, Carla, A,20611 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Li, Wesley,23322 | 3042.82 | 0.00 | 0.00 | 2443.35 | 599.47 |
| Chander, Misty,17333 | 80.94 | 0.00 | 0.00 | 0.00 | 80.94 |
| Zhou, Colleen,23122 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Powell, Elizabeth, K,28306 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Yuan, Bradley,17920 | 4733.75 | 3578.27 | 0.00 | 0.00 | 1155.48 |
| Ross, Adam,11099 | 8215.99 | 3399.99 | 0.00 | 2363.96 | 2452.04 |
| Subram, Tabitha, C,17511 | 4150.53 | 3578.27 | 0.00 | 572.26 | 0.00 |
| Zhou, Cedric,17514 | 4142.23 | 3578.27 | 0.00 | 563.96 | 0.00 |
| Anand, Andrés,11096 | 8063.04 | 3374.99 | 0.00 | 2294.99 | 2393.06 |
| Lal, Shawna,17924 | 4733.75 | 3578.27 | 0.00 | 0.00 | 1155.48 |
| Tang, Bridget,17730 | 4752.23 | 3578.27 | 0.00 | 0.00 | 1173.96 |
| Ye, Leah,11077 | 8169.03 | 3374.99 | 0.00 | 2374.98 | 2419.06 |
| Navarro, Carolyn,11069 | 8104.05 | 3399.99 | 0.00 | 2319.99 | 2384.07 |
| Suri, Cesar,17512 | 4170.54 | 3578.27 | 0.00 | 592.27 | 0.00 |
| Xu, Tracy, L,17916 | 4787.74 | 3578.27 | 0.00 | 0.00 | 1209.47 |
| Martinez, Daniel, P,17725 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Anderson, Blake,11076 | 8159.04 | 3399.99 | 0.00 | 2374.98 | 2384.07 |
| Ortega, Joanna,17909 | 4761.74 | 3578.27 | 0.00 | 0.00 | 1183.47 |
| Malhotra, Cory, E,17923 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Raji, Willie, T,11070 | 8165.55 | 3399.99 | 0.00 | 2345.22 | 2420.34 |
Generated 2024-09-20 05:27:29.768 UTC