[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 125 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Mehta, Cindy, A,21943 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Pal, Christy, R,18739 | 5371.74 | 0.00 | 3578.27 | 1793.47 | 0.00 |
| Butler, Destiny,27865 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Dominguez, Rebekah,27877 | 1228.83 | 0.00 | 0.00 | 0.00 | 1228.83 |
| Rodriguez, Ebony,14517 | 82.97 | 0.00 | 0.00 | 0.00 | 82.97 |
| Dominguez, Gina, L,20213 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| She, Gregory,18458 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Malhotra, Cory, E,17923 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Johnston, Tamara, H,18492 | 218.26 | 0.00 | 0.00 | 0.00 | 218.26 |
| Romero, Lawrence, C,16687 | 6070.59 | 3578.27 | 0.00 | 2492.32 | 0.00 |
| Yang, Connor,17735 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Alonso, Joanna, M,27862 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Wang, Randy, G,25125 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Randall, Toni,16605 | 66.26 | 0.00 | 0.00 | 27.28 | 38.98 |
| Arun, Denise,28218 | 18.97 | 0.00 | 0.00 | 0.00 | 18.97 |
| Dominguez, Robyn, P,23305 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Rana, Rachael, A,18270 | 94.47 | 0.00 | 0.00 | 0.00 | 94.47 |
| Sai, Ronald, B,13643 | 6799.45 | 0.00 | 0.00 | 2071.42 | 4728.03 |
| Ramos, Roy, A,24482 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Rodriguez, Arthur,15438 | 3788.68 | 0.00 | 0.00 | 2071.42 | 1717.26 |
| Kumar, Kurt, L,27360 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Vazquez, Roy,26029 | 1930.76 | 0.00 | 782.99 | 0.00 | 1147.77 |
| Travers, Reginald,28488 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Gill, Latasha, M,25713 | 1288.06 | 0.00 | 699.10 | 0.00 | 588.96 |
| Parker, Gabriella,21394 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Stone, Christine, D,25948 | 1819.59 | 0.00 | 699.10 | 0.00 | 1120.49 |
| Raman, Levi,29114 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Taylor, Christopher, E,21171 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Huang, Sandra, C,16523 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Smith, Arthur,18240 | 6098.58 | 0.00 | 3578.27 | 2520.31 | 0.00 |
| Hu, Omar, S,28954 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Tang, Colin,14323 | 5222.02 | 0.00 | 0.00 | 2071.42 | 3150.60 |
| Mehta, Denise,13080 | 6844.41 | 0.00 | 0.00 | 2049.10 | 4795.31 |
| Ruiz, Melody,13621 | 167.40 | 0.00 | 0.00 | 0.00 | 167.40 |
| Perez, Ivan, S,23408 | 4218.82 | 0.00 | 0.00 | 2443.35 | 1775.47 |
| Li, Lisa, J,24600 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Schmidt, Monica,12012 | 73.96 | 0.00 | 0.00 | 8.99 | 64.97 |
| Ross, Mya, E,27715 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Murphy, Jill, J,24902 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Lal, Bradley,13156 | 2663.69 | 0.00 | 0.00 | 2071.42 | 592.27 |
| Suri, Toni,18464 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Pal, Gilbert,27744 | 643.95 | 0.00 | 0.00 | 643.95 | 0.00 |
| Zeng, Dennis, S,13050 | 5651.25 | 0.00 | 0.00 | 2071.42 | 3579.83 |
| Martinez, Ian,12585 | 2629.07 | 0.00 | 2049.10 | 0.00 | 579.97 |
| Raje, Carly, J,15576 | 4344.09 | 0.00 | 0.00 | 2049.10 | 2294.99 |
| Li, Gilbert,23999 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Zheng, Shannon, M,14678 | 49.99 | 0.00 | 0.00 | 49.99 | 0.00 |
| Griffin, Caroline,17726 | 4721.73 | 0.00 | 3578.27 | 0.00 | 1143.46 |
| Xu, Terry,24228 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| He, Jorge,20268 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Sharma, Julie, R,18191 | 94.47 | 0.00 | 0.00 | 8.99 | 85.48 |
| Jimenez, Marie, C,24176 | 3042.82 | 0.00 | 0.00 | 2443.35 | 599.47 |
| Zhao, Lacey, M,27713 | 1158.96 | 0.00 | 0.00 | 0.00 | 1158.96 |
| Gao, Christy, D,26204 | 1967.45 | 0.00 | 0.00 | 782.99 | 1184.46 |
| Sharma, Sharon, T,25294 | 1882.57 | 699.10 | 0.00 | 0.00 | 1183.47 |
| Liu, Warren,15014 | 3860.87 | 0.00 | 0.00 | 2071.42 | 1789.45 |
| Chapman, Pamela, L,27145 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Jai, Carly,22986 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Zhu, Amy, W,26664 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Rana, Henry,27342 | 1348.46 | 0.00 | 0.00 | 782.99 | 565.47 |
| Madan, Terrance,24910 | 2183.91 | 0.00 | 0.00 | 1000.44 | 1183.47 |
| Raje, Kelli, A,28136 | 2384.07 | 0.00 | 0.00 | 2384.07 | 0.00 |
| Cai, Willie, S,25960 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Vance, Kristi, T,28338 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Huang, Wesley,29320 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Wood, Richard, W,24377 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Yang, Colleen,22167 | 123.98 | 0.00 | 0.00 | 123.98 | 0.00 |
| Sharma, Carl,21375 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Ferrier, Jaclyn, D,17299 | 4382.75 | 3578.27 | 0.00 | 0.00 | 804.48 |
| Rai, Colleen,28933 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Sai, Jay, A,23427 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Li, Jaclyn,18281 | 6081.10 | 0.00 | 3578.27 | 0.00 | 2502.83 |
| Xu, Tara,19592 | 5377.23 | 0.00 | 3578.27 | 0.00 | 1798.96 |
| Sanz, Monique, R,24273 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Nara, Tommy,16729 | 38.92 | 0.00 | 0.00 | 0.00 | 38.92 |
| Smith, Christian, L,14313 | 222.44 | 0.00 | 0.00 | 0.00 | 222.44 |
| Suri, Adriana,18463 | 4726.04 | 0.00 | 3578.27 | 0.00 | 1147.77 |
| Madan, Patricia, L,22988 | 4194.33 | 0.00 | 0.00 | 2443.35 | 1750.98 |
| Thompson, Fernando,16350 | 5903.19 | 3578.27 | 0.00 | 0.00 | 2324.92 |
| Weber, Cory,16739 | 81.26 | 0.00 | 0.00 | 31.27 | 49.99 |
| Jai, Latoya, S,21229 | 4198.33 | 0.00 | 2443.35 | 0.00 | 1754.98 |
| Torres, Danielle, G,22947 | 75.97 | 0.00 | 0.00 | 75.97 | 0.00 |
| Ms., Ryan, Justine, J.,23079 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Kumar, Rafael, L,19088 | 24.27 | 0.00 | 0.00 | 2.29 | 21.98 |
| Sharma, Dustin, M,18484 | 6093.20 | 0.00 | 3578.27 | 2514.93 | 0.00 |
| Martin, Jay,19597 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Sutton, Jaime, L,16630 | 5973.24 | 3578.27 | 0.00 | 0.00 | 2394.97 |
| Hernandez, Darren, A,18709 | 6098.54 | 0.00 | 3578.27 | 2520.27 | 0.00 |
| Alvarez, Lori, C,26662 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Chande, Bonnie, L,23992 | 3167.82 | 0.00 | 0.00 | 2443.35 | 724.47 |
| Martin, Gerald, K,17284 | 90.25 | 0.00 | 0.00 | 31.27 | 58.98 |
| Saunders, Bobby, D,22205 | 120.48 | 0.00 | 0.00 | 0.00 | 120.48 |
| Suri, Jarrod, E,12004 | 8114.04 | 0.00 | 3374.99 | 0.00 | 4739.05 |
| Shan, Keith, T,20996 | 4149.99 | 0.00 | 3578.27 | 0.00 | 571.72 |
| Xie, Alvin, M,16617 | 160.55 | 0.00 | 0.00 | 69.97 | 90.58 |
| Ms., Sherwood, Irma, J.,24598 | 4228.31 | 0.00 | 0.00 | 2443.35 | 1784.96 |
| She, Roger, L,15724 | 4359.07 | 0.00 | 0.00 | 2049.10 | 2309.97 |
| Pal, Jenny,15132 | 151.94 | 0.00 | 0.00 | 0.00 | 151.94 |
| Nara, Cassie,13642 | 79.97 | 0.00 | 0.00 | 0.00 | 79.97 |
| Munoz, Audrey, V,12003 | 8256.50 | 0.00 | 3374.99 | 0.00 | 4881.51 |
| Saunders, Ruben, G,27983 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Raje, Shawn,17054 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Li, Lacey,17515 | 4143.26 | 0.00 | 3578.27 | 0.00 | 564.99 |
| Lu, Willie,21191 | 4169.33 | 0.00 | 2443.35 | 0.00 | 1725.98 |
| Raji, Derek, D,19591 | 63.42 | 0.00 | 0.00 | 0.00 | 63.42 |
| Jai, Alison,23657 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gonzalez, Brandy,27368 | 132.97 | 0.00 | 0.00 | 132.97 | 0.00 |
| Perez, Kyle, J,16180 | 4386.37 | 0.00 | 0.00 | 2049.10 | 2337.27 |
| Torres, Bailey,18259 | 30.97 | 0.00 | 0.00 | 8.99 | 21.98 |
| Guo, Autumn, A,14213 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Pal, Arturo, P,29303 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Williams, Nicholas, A,25809 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Evans, Carlos, J,23538 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Johnson, Sydney,19571 | 90.95 | 0.00 | 0.00 | 33.98 | 56.97 |
| Wu, Ernest, L,11147 | 8195.50 | 0.00 | 3374.99 | 0.00 | 4820.51 |
| Zheng, Dawn, F,19579 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Shen, Karl, M,15151 | 4344.09 | 0.00 | 0.00 | 2049.10 | 2294.99 |
| Ramos, Lance, S,28949 | 2473.05 | 0.00 | 0.00 | 2473.05 | 0.00 |
| Sanz, Bruce,23117 | 3931.52 | 0.00 | 0.00 | 2181.56 | 1749.96 |
| Alvarez, Marc, B,18221 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Goel, April, C,16166 | 108.85 | 0.00 | 0.00 | 69.97 | 38.88 |
| Lal, Mario, T,23345 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Chander, Omar, W,17241 | 4382.75 | 3578.27 | 0.00 | 0.00 | 804.48 |
| Gill, Alberto, P,17733 | 4758.24 | 0.00 | 3578.27 | 0.00 | 1179.97 |
Generated 2025-11-06 11:58:24.911 UTC