[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 | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Yuan, Kathryn, L,23106 | 3956.01 | 0.00 | 0.00 | 2181.56 | 1774.45 |
| Shan, Carl, D,24919 | 2212.89 | 0.00 | 0.00 | 1000.44 | 1212.45 |
| Sanchez, Michelle, R,26569 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Lal, Barbara, W,23101 | 2795.01 | 0.00 | 0.00 | 2181.56 | 613.45 |
| Munoz, Ebony,13106 | 5697.52 | 0.00 | 0.00 | 2071.42 | 3626.10 |
| Ramos, Joy,13129 | 6823.15 | 0.00 | 0.00 | 2049.10 | 4774.05 |
| Munoz, Craig, V,13076 | 6862.14 | 0.00 | 0.00 | 2049.10 | 4813.04 |
| Peterson, Juan, H,13082 | 6906.39 | 0.00 | 0.00 | 2071.42 | 4834.97 |
| Raji, Grant, R,16185 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Xu, Colleen, C,18325 | 108.85 | 0.00 | 0.00 | 38.88 | 69.97 |
| Lu, Ramon, B,16738 | 44.95 | 0.00 | 0.00 | 13.98 | 30.97 |
| Alonso, Krista, P,20212 | 100.74 | 0.00 | 0.00 | 0.00 | 100.74 |
| Serrano, Leslie, T,14014 | 62.27 | 0.00 | 0.00 | 0.00 | 62.27 |
| Gutierrez, Natasha,17048 | 4382.75 | 3578.27 | 0.00 | 0.00 | 804.48 |
| Sara, Ann, A,23576 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Griffin, Noah, E,29118 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Flores, Katherine,21180 | 3882.55 | 0.00 | 2181.56 | 0.00 | 1700.99 |
| Andersen, Carl, J,11057 | 8088.04 | 3374.99 | 0.00 | 2319.99 | 2393.06 |
| Lal, Shaun, H,17056 | 4417.75 | 3578.27 | 0.00 | 0.00 | 839.48 |
| Jai, Carly,22986 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Yuan, Keith, N,22926 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Martin, Deanna,13091 | 6864.95 | 0.00 | 0.00 | 2071.42 | 4793.53 |
| Zhou, Heather, M,24914 | 2149.91 | 0.00 | 0.00 | 1000.44 | 1149.47 |
| Garcia, Martin, l,23332 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Alonso, Armando, M,13647 | 6793.15 | 0.00 | 0.00 | 2049.10 | 4744.05 |
| Lin, Damien, L,23414 | 3391.03 | 0.00 | 0.00 | 3391.03 | 0.00 |
| Browning, Javier,23120 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Ramos, Danny,23121 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Raji, Brad, C,23409 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Sharma, Jerry, C,13651 | 6812.12 | 0.00 | 0.00 | 2049.10 | 4763.02 |
| Sai, Ronald, B,13643 | 6799.45 | 0.00 | 0.00 | 2071.42 | 4728.03 |
| Moreno, Bruce, F,26652 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Sanz, Lawrence, M,14030 | 6905.47 | 0.00 | 0.00 | 2071.42 | 4834.05 |
| Fernandez, Rachael, M,23993 | 3072.32 | 0.00 | 0.00 | 2443.35 | 628.97 |
| Serrano, Max, E,12010 | 8203.50 | 0.00 | 3374.99 | 0.00 | 4828.51 |
| Nath, Ricardo, C,12039 | 8213.00 | 0.00 | 3374.99 | 0.00 | 4838.01 |
| Zhao, Bianca,13971 | 6772.13 | 0.00 | 0.00 | 2049.10 | 4723.03 |
| Ms., Robinson, Dorothy, B.,11952 | 8169.00 | 0.00 | 3374.99 | 2395.96 | 2398.05 |
| Navarro, Latasha, L,11100 | 8172.51 | 0.00 | 3374.99 | 2399.47 | 2398.05 |
| Ruiz, Adrienne,13523 | 67.26 | 0.00 | 0.00 | 0.00 | 67.26 |
| Suarez, Jacquelyn, C,11010 | 8088.04 | 3399.99 | 0.00 | 2294.99 | 2393.06 |
| Pal, Arturo, P,29303 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Zhao, Jessie, R,11027 | 6591.57 | 3399.99 | 0.00 | 0.00 | 3191.58 |
| Goel, Karl,18705 | 59.26 | 0.00 | 0.00 | 0.00 | 59.26 |
| Alvarez, Mathew, L,17494 | 111.96 | 0.00 | 0.00 | 0.00 | 111.96 |
| Sai, Rachael,11912 | 8095.32 | 0.00 | 3374.99 | 0.00 | 4720.33 |
| Munoz, Alfredo, C,23314 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Jimenez, Naomi,24922 | 2145.92 | 0.00 | 0.00 | 1000.44 | 1145.48 |
| Lal, Corey, H,23313 | 2906.03 | 0.00 | 0.00 | 2181.56 | 724.47 |
| Madan, Johnathan, D,13626 | 6909.09 | 0.00 | 0.00 | 2049.10 | 4859.99 |
| Alvarez, Diana,13638 | 6832.12 | 0.00 | 0.00 | 2049.10 | 4783.02 |
| Sanz, Bruce,23117 | 3931.52 | 0.00 | 0.00 | 2181.56 | 1749.96 |
| Liu, Krystal, D,13526 | 4549.76 | 0.00 | 0.00 | 2071.42 | 2478.34 |
| Martinez, Pamela, A,13529 | 4614.86 | 0.00 | 0.00 | 2071.42 | 2543.44 |
| Kumar, Misty, H,25010 | 1540.43 | 0.00 | 0.00 | 1000.44 | 539.99 |
| Chandra, Tina, S,13974 | 5237.73 | 0.00 | 0.00 | 2071.42 | 3166.31 |
| Chen, Aimee,26591 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Ortega, Max,23413 | 3617.83 | 0.00 | 0.00 | 3617.83 | 0.00 |
| Sai, Lydia, L,13968 | 5181.70 | 0.00 | 0.00 | 2862.74 | 2318.96 |
| Sai, Emmanuel,23417 | 3337.04 | 0.00 | 0.00 | 3337.04 | 0.00 |
| Hall, Amanda,26656 | 1345.95 | 0.00 | 0.00 | 1345.95 | 0.00 |
| Alonso, Alfredo, T,23323 | 2745.33 | 0.00 | 0.00 | 2181.56 | 563.77 |
| Moyer, Mario,23420 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Sutton, Kern, A,26660 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Shan, Kristin,23416 | 3598.83 | 0.00 | 0.00 | 3598.83 | 0.00 |
| Zheng, Roger,29321 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Serrano, Diane, E,14857 | 87.97 | 0.00 | 0.00 | 78.98 | 8.99 |
| Hill, James, S,29317 | 2438.06 | 0.00 | 0.00 | 0.00 | 2438.06 |
| Goel, Alejandro, K,13077 | 6766.63 | 0.00 | 0.00 | 2049.10 | 4717.53 |
| Jimenez, Kathleen,26654 | 1346.76 | 0.00 | 0.00 | 1346.76 | 0.00 |
| Guo, Margaret,23431 | 4158.32 | 0.00 | 0.00 | 2443.35 | 1714.97 |
| Yuan, Mitchell,26744 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Martinez, Monica, A,14129 | 3750.09 | 0.00 | 0.00 | 2049.10 | 1700.99 |
| Liu, Lacey, L,23545 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Roberts, Jordan,23432 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Sharma, Edwin, K,25021 | 1554.41 | 0.00 | 0.00 | 1000.44 | 553.97 |
| Hernandez, Raquel, W,13997 | 4586.35 | 0.00 | 0.00 | 2071.42 | 2514.93 |
| Sanz, Cheryl, G,14046 | 5645.24 | 0.00 | 0.00 | 3340.26 | 2304.98 |
| Navarro, Javier,14131 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Ramos, Tanya, R,14045 | 6804.13 | 0.00 | 0.00 | 2049.10 | 4755.03 |
| Cook, Isaac, M,13994 | 4528.75 | 0.00 | 0.00 | 2071.42 | 2457.33 |
| Moore, Thomas,14010 | 3861.39 | 0.00 | 0.00 | 3861.39 | 0.00 |
| Chande, Derek,26743 | 1371.95 | 0.00 | 0.00 | 1371.95 | 0.00 |
| Mehta, Cassandra,23014 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Goel, Karla, L,11146 | 112.93 | 0.00 | 0.00 | 53.95 | 58.98 |
| Yang, Connor,17735 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Yuan, Rafael, J,20625 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Sun, Lacey, L,15131 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Cooper, Katherine, R,14314 | 122.95 | 0.00 | 0.00 | 0.00 | 122.95 |
| Peterson, Lucas,17298 | 174.45 | 0.00 | 0.00 | 0.00 | 174.45 |
| Shen, Brendan, L,14305 | 3652.20 | 0.00 | 0.00 | 2049.10 | 1603.10 |
| Henderson, Xavier, K,12993 | 96.25 | 0.00 | 0.00 | 0.00 | 96.25 |
| Prasad, Meagan,19611 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Raman, Harold, F,28484 | 778.62 | 0.00 | 0.00 | 0.00 | 778.62 |
| Beck, Alisha, E,11463 | 47.92 | 0.00 | 0.00 | 7.95 | 39.97 |
| Munoz, Robyn,14214 | 5759.87 | 0.00 | 0.00 | 2049.10 | 3710.77 |
| Ruiz, Naomi,23649 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Cai, Candice,26747 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Ross, Brandon,14132 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Mitchell, Wyatt, A,14048 | 5123.74 | 0.00 | 0.00 | 2071.42 | 3052.32 |
| Serrano, Francis, R,23547 | 3598.83 | 0.00 | 0.00 | 2443.35 | 1155.48 |
| Alexander, Austin,26673 | 1505.76 | 0.00 | 0.00 | 1505.76 | 0.00 |
| Suarez, Ruben,14031 | 6964.42 | 0.00 | 0.00 | 2049.10 | 4915.32 |
| Lopez, Bruce,23540 | 3626.82 | 0.00 | 0.00 | 2443.35 | 1183.47 |
| Martin, Justin,23542 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Nath, Katie, A,23434 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Hernandez, Ebony, S,23574 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Serrano, Joanna, J,26663 | 1976.94 | 0.00 | 0.00 | 782.99 | 1193.95 |
| Chen, Rosa,23435 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Romero, Jessie,25030 | 2180.41 | 0.00 | 0.00 | 1000.44 | 1179.97 |
| Lopez, Rachael,23425 | 3951.52 | 0.00 | 0.00 | 2181.56 | 1769.96 |
| Romero, Gina,14234 | 5687.72 | 0.00 | 0.00 | 2071.42 | 3616.30 |
| Anand, Alison, J,24009 | 2746.04 | 0.00 | 0.00 | 2181.56 | 564.48 |
| Thomas, Sydney,14322 | 5111.44 | 0.00 | 0.00 | 2049.10 | 3062.34 |
| Yuan, Tamara, E,21166 | 4909.67 | 0.00 | 2443.35 | 0.00 | 2466.32 |
| Wood, Jacqueline,16705 | 97.96 | 0.00 | 0.00 | 0.00 | 97.96 |
| Ruiz, Hector,27592 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Serrano, Neil, L,17076 | 103.46 | 0.00 | 0.00 | 0.00 | 103.46 |
| Lal, Cristina, M,14671 | 2934.37 | 0.00 | 0.00 | 2071.42 | 862.95 |
| Davis, Nicole,22957 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Pal, Mohamed, D,12698 | 6786.75 | 0.00 | 2071.42 | 0.00 | 4715.33 |
| Ramirez, Mason, K,25107 | 2143.90 | 0.00 | 0.00 | 1000.44 | 1143.46 |
| Campbell, Devin,23653 | 3975.03 | 0.00 | 0.00 | 2181.56 | 1793.47 |
| Sanders, Devin, J,12014 | 3949.97 | 0.00 | 3399.99 | 0.00 | 549.98 |
| Ramos, Byron,14306 | 3653.23 | 0.00 | 0.00 | 2071.42 | 1581.81 |
Generated 2025-11-01 06:37:23.667 UTC