[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Carlson, Tanya,16183 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Munoz, Latasha,11967 | 8153.02 | 0.00 | 3374.99 | 0.00 | 4778.03 |
| Chandra, Cesar, R,20236 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
| Sai, Rachael,11912 | 8095.32 | 0.00 | 3374.99 | 0.00 | 4720.33 |
| Becker, Kelsey, G,11968 | 8079.05 | 0.00 | 3399.99 | 2294.99 | 2384.07 |
| Guo, Tiffany,25927 | 1272.52 | 0.00 | 699.10 | 0.00 | 573.42 |
| Goel, Jodi,20447 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Mehta, Evelyn, S,20420 | 4132.24 | 0.00 | 3578.27 | 553.97 | 0.00 |
| Andersen, Jenny,20259 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Jai, Bonnie,11977 | 8212.50 | 0.00 | 3399.99 | 0.00 | 4812.51 |
| Hu, Cara,20608 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Coleman, Jocelyn,20606 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Shan, Johnny,11999 | 7043.27 | 0.00 | 3399.99 | 0.00 | 3643.28 |
| Chapman, Kathryn,11988 | 8078.02 | 0.00 | 3374.99 | 0.00 | 4703.03 |
| Yang, Shannon,12001 | 8113.01 | 0.00 | 3374.99 | 0.00 | 4738.02 |
| Sharma, Donna,11998 | 6962.10 | 0.00 | 3374.99 | 1249.84 | 2337.27 |
| Anand, Kelli, A,20451 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Blanco, Jésus, E,20448 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Yang, Colin, J,20612 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Ross, Brandon,14132 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Perez, Edgar, B,29318 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Carlson, Robin,19786 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Zhu, Christy,11003 | 8139.29 | 3399.99 | 0.00 | 2318.96 | 2420.34 |
| Lal, Kelsey, T,24913 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Chen, Jaclyn, C,22847 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Arun, Barry,27700 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gray, Stephanie,17064 | 4506.76 | 3578.27 | 0.00 | 0.00 | 928.49 |
| Romero, Dwayne,28314 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| He, Curtis, D,24921 | 2180.41 | 0.00 | 0.00 | 1000.44 | 1179.97 |
| Gutierrez, Francis,25245 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Kumar, Wayne,17502 | 6070.59 | 0.00 | 3578.27 | 0.00 | 2492.32 |
| Blanco, Ricky, F,16606 | 67.17 | 0.00 | 0.00 | 0.00 | 67.17 |
| Wilson, Sam,25947 | 1854.58 | 0.00 | 699.10 | 0.00 | 1155.48 |
| Sanz, Cheryl, G,14046 | 5645.24 | 0.00 | 0.00 | 3340.26 | 2304.98 |
| Shan, Shaun,24274 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Nara, Cedric, M,21875 | 4921.69 | 0.00 | 2443.35 | 0.00 | 2478.34 |
| Martin, Max, A,16030 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Xu, Shawna,23419 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ye, Edwin,18334 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Barnes, Julia, R,21999 | 4921.69 | 0.00 | 0.00 | 2443.35 | 2478.34 |
| Ortega, Meghan, E,22004 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Raje, Louis, M,25707 | 1262.06 | 0.00 | 699.10 | 0.00 | 562.96 |
| Malhotra, Kristopher, L,15265 | 2897.57 | 0.00 | 0.00 | 2049.10 | 848.47 |
| Muñoz, Alberto, J,13008 | 125.51 | 0.00 | 0.00 | 0.00 | 125.51 |
| Nath, Keith,19617 | 61.75 | 0.00 | 0.00 | 0.00 | 61.75 |
| Dominguez, Roy, C,29189 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Rai, Karl, M,25273 | 1898.07 | 699.10 | 0.00 | 0.00 | 1198.97 |
| Vance, Monica, G,12338 | 8265.00 | 0.00 | 3374.99 | 0.00 | 4890.01 |
| Holt, Alisha,28350 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Mr., Solanki, Ajay,18295 | 144.27 | 0.00 | 0.00 | 0.00 | 144.27 |
| Nara, Grant,12995 | 6850.58 | 0.00 | 0.00 | 2049.10 | 4801.48 |
| Carter, Sophia, D,25230 | 80.96 | 0.00 | 0.00 | 0.00 | 80.96 |
| Zheng, Omar, C,14522 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
| Vazquez, Joe, C,20418 | 4207.24 | 0.00 | 3578.27 | 628.97 | 0.00 |
| Xie, Kelli, J,20452 | 6156.70 | 0.00 | 3578.27 | 0.00 | 2578.43 |
| Bryant, Fernando, M,20609 | 6117.69 | 0.00 | 3578.27 | 0.00 | 2539.42 |
| Johnson, Morgan, E,12011 | 4735.81 | 0.00 | 3374.99 | 618.47 | 742.35 |
| Shan, Keith, T,20996 | 4149.99 | 0.00 | 3578.27 | 0.00 | 571.72 |
| Rubio, Sabrina, A,20984 | 4153.25 | 0.00 | 3578.27 | 0.00 | 574.98 |
| Prasad, Preston, C,20812 | 4127.25 | 0.00 | 3578.27 | 548.98 | 0.00 |
| Sanders, Devin, J,12014 | 3949.97 | 0.00 | 3399.99 | 0.00 | 549.98 |
| Martinez, Ann,12009 | 8195.50 | 0.00 | 3399.99 | 0.00 | 4795.51 |
| Garcia, Ruth,20623 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Gutierrez, Rodney, J,20628 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Navarro, Theresa,20627 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Prasad, Gerald, B,12035 | 81.24 | 0.00 | 0.00 | 64.97 | 16.27 |
| Munoz, Monique,24008 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Garcia, Ruben,19613 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Kumar, Tony, P,19783 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Vance, Jillian, D,15230 | 148.98 | 0.00 | 0.00 | 0.00 | 148.98 |
| Chander, Julie, E,18763 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Sun, Lacey, L,15131 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Gomez, Hector, A,29337 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Raje, Misty, A,23544 | 3971.01 | 0.00 | 0.00 | 2181.56 | 1789.45 |
| Gonzalez, Meredith,22171 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Hu, Crystal,27980 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| She, Sheena, R,23008 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Sanchez, Michele,23543 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Huang, Lacey, J,11951 | 63.52 | 0.00 | 0.00 | 0.00 | 63.52 |
| Sai, Regina,21192 | 4229.32 | 0.00 | 2443.35 | 0.00 | 1785.97 |
| Yang, Curtis,11110 | 8093.03 | 0.00 | 3399.99 | 2294.99 | 2398.05 |
| Ye, Brent,28922 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Raje, Wayne, A,21372 | 74.96 | 0.00 | 0.00 | 0.00 | 74.96 |
| Campbell, Jason, J,13625 | 6962.14 | 0.00 | 0.00 | 2049.10 | 4913.04 |
| Lin, Jaclyn,28721 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Cai, Trisha,18265 | 64.98 | 0.00 | 0.00 | 0.00 | 64.98 |
| Hu, Alejandro,13125 | 138.54 | 0.00 | 0.00 | 0.00 | 138.54 |
| West, Colleen, C,13128 | 6817.14 | 0.00 | 0.00 | 2049.10 | 4768.04 |
| Taylor, Ashley, E,18215 | 150.97 | 0.00 | 0.00 | 0.00 | 150.97 |
| Anand, Ricardo,21383 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Liang, Brittney, R,26182 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Flores, Alexandra, C,26165 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Navarro, Francis, J,27520 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Li, Jake, L,19583 | 97.96 | 0.00 | 0.00 | 0.00 | 97.96 |
| Browning, Javier,23120 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Goel, Barbara,12988 | 6915.44 | 0.00 | 0.00 | 2049.10 | 4866.34 |
| Vazquez, Hector, E,19772 | 6030.61 | 0.00 | 3578.27 | 0.00 | 2452.34 |
| Raman, Mayra, P,20990 | 4196.22 | 0.00 | 3578.27 | 0.00 | 617.95 |
| Serrano, Max, E,12010 | 8203.50 | 0.00 | 3374.99 | 0.00 | 4828.51 |
| Rubio, Kristy,12243 | 3914.98 | 0.00 | 3374.99 | 0.00 | 539.99 |
| Suarez, Jerome, L,20622 | 6139.59 | 0.00 | 3578.27 | 0.00 | 2561.32 |
| Nath, Ricardo, C,12039 | 8213.00 | 0.00 | 3374.99 | 0.00 | 4838.01 |
| Ortega, Monique, C,12355 | 6818.11 | 0.00 | 2049.10 | 0.00 | 4769.01 |
| Yuan, Tamara, E,21166 | 4909.67 | 0.00 | 2443.35 | 0.00 | 2466.32 |
| Garcia, Carolyn,20999 | 2735.53 | 0.00 | 2181.56 | 0.00 | 553.97 |
| Rodriguez, Carolyn,21002 | 2992.33 | 0.00 | 2443.35 | 0.00 | 548.98 |
| Ortega, Lance, C,12354 | 6797.13 | 0.00 | 2049.10 | 0.00 | 4748.03 |
| Moreno, Hector,21183 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Raje, Derek,12574 | 2626.39 | 0.00 | 2071.42 | 0.00 | 554.97 |
| Ashe, Joanna, F,20997 | 2744.52 | 0.00 | 2181.56 | 0.00 | 562.96 |
| Flores, Katherine,21180 | 3882.55 | 0.00 | 2181.56 | 0.00 | 1700.99 |
| She, Corey, T,21214 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Nath, Cassie,24606 | 2155.92 | 0.00 | 1000.44 | 1155.48 | 0.00 |
| Deng, Peter, A,24006 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Malhotra, Tina, C,27584 | 599.47 | 0.00 | 0.00 | 0.00 | 599.47 |
| Romero, Jessie,25030 | 2180.41 | 0.00 | 0.00 | 1000.44 | 1179.97 |
| Rana, Joe, D,11916 | 8178.51 | 0.00 | 3374.99 | 2405.47 | 2398.05 |
| West, Nathan,24370 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Chande, Alvin, W,24893 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Gutierrez, Diana,19676 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Gutierrez, Ricky,19773 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Moreno, Kristine, K,28481 | 778.62 | 0.00 | 0.00 | 0.00 | 778.62 |
| Sanz, Hector,27344 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Patterson, Antonio, G,11963 | 8068.03 | 0.00 | 3374.99 | 2294.99 | 2398.05 |
| Zeng, Jon, O,14310 | 5200.66 | 0.00 | 0.00 | 2071.42 | 3129.24 |
Generated 2024-11-10 02:36:48.136 UTC