[ROOT]  dt  FactInternetSale  WHERE DimCurrency.AlternateKey EQ 'AUD'  >   PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount   <  ORDER BY 2020   SHUFFLE   <  SKIP 500  >   <  TAKE 250  >   

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Sai, Kari, E,1423183.970.000.0024.9958.98
Tang, Latoya, F,229103882.550.000.002181.561700.99
Suri, Cassandra, B,1871787.210.000.000.0087.21
Torres, Sebastian, V,258311882.570.00699.100.001183.47
Beck, Alisha, E,1146347.920.000.007.9539.97
Anand, Katrina, L,187265314.250.003578.271735.980.00
Lin, Kelli, A,2139229.990.000.000.0029.99
Yang, Randy, E,240002983.340.000.002443.35539.99
Ruiz, Bruce, W,16171103.860.000.000.00103.86
Lal, Karl, R,142645217.730.000.002822.762394.97
Parker, Gabriella,213944657.510.002181.560.002475.95
Ortega, Briana, L,29346567.760.000.000.00567.76
Zheng, Alisha,222034624.910.000.002181.562443.35
Goel, Bradley,1580366.260.000.000.0066.26
Hernandez, Melinda,16174140.450.000.000.00140.45
Johnston, Tamara, H,18492218.260.000.000.00218.26
Deng, Deborah,233242730.540.000.002181.56548.98
Gonzalez, Veronica, C,233113337.040.000.003337.040.00
Huang, Arturo,289522473.040.000.002473.040.00
Zhang, Susan, S,1821638.920.000.008.9929.93
Watson, Anna,202386021.620.003578.270.002443.35
Zeng, Warren, R,244773302.050.000.002181.561120.49
Guo, Susan, A,2654314.230.000.0014.230.00
Guo, Lisa, S,1731478.960.000.000.0078.96
Kapoor, Brett, L,2214769.990.000.000.0069.99
Goel, Tommy,229093980.520.000.002181.561798.96
Rodriguez, Douglas, W,196525314.250.003578.270.001735.98
Gonzalez, Francisco, L,122453967.260.003399.990.00567.27
Subram, Tabitha, C,175114150.530.003578.27572.260.00
Perez, Brett, M,28313647.940.000.000.00647.94
Pal, Jenny,15132151.940.000.000.00151.94
Navarro, Mathew, A,1967337.290.000.000.0037.29
Hernandez, Raquel, W,139974586.350.000.002071.422514.93
Serrano, Tabitha,283272407.040.000.002407.040.00
Liu, Glenn,188994118.260.003578.27539.990.00
Subram, Martin, S,1959032.280.000.0032.280.00
Sharma, Alvin, M,195866056.610.003578.270.002478.34
Lin, Autumn, E,182726056.610.003578.272478.340.00
Jenkins, Amanda,152144490.880.000.002071.422419.46
Jiménez, Orlando, M,21283124.940.000.000.00124.94
Gutierrez, Jaime, A,2522739.980.000.000.0039.98
Munoz, Robyn,142145759.870.000.002049.103710.77
Xu, Tonya,1732480.940.000.000.0080.94
Hernandez, Julio, J,2307815.230.000.000.0015.23
Alonso, Billy, M,2285239.990.000.000.0039.99
Ma, Curtis,28119574.980.000.000.00574.98
Mehta, Cesar, J,202415347.230.003578.270.001768.96
Martin, Briana, L,152132818.590.000.002049.10769.49
Rubio, Sabrina, A,209844153.250.003578.270.00574.98
Anand, Calvin, E,2871729.480.000.000.0029.48
Shan, Bethany, L,139735185.680.000.002071.423114.26
Zheng, Claudia,186916070.590.003578.272492.320.00
Alexander, David,1578398.960.000.000.0098.96
Chandra, Veronica,146815178.400.000.002049.103129.30
Dominguez, Sabrina, M,28116617.470.000.000.00617.47
She, Colleen, E,2931269.970.000.000.0069.97
Chapman, Jodi, L,229663917.540.000.002181.561735.98
Gill, Erika, A,182024143.260.003578.270.00564.99
Sanchez, Lydia, S,125792589.090.002049.100.00539.99
Arthur, Carla,1671091.260.000.000.0091.26
Garcia, Donald,189296029.570.003578.270.002451.30
Parker, Mason, W,259236.280.000.006.280.00
Hernandez, Jessie, A,241722735.530.000.002181.56553.97
Sara, Barry, R,139656872.390.000.002071.424800.97
Li, Gilbert,239992730.540.000.002181.56548.98
Fernandez, Rachael, M,239933072.320.000.002443.35628.97
Guo, Trisha,1825345.950.000.000.0045.95
Guo, Micah, M,241632756.540.000.002181.56574.98
Gill, Billy, L,1670092.970.000.000.0092.97
Zhu, Edwin,2714878.980.000.000.0078.98
Ye, Gilbert,29344548.980.000.000.00548.98
Liu, Karen, F,1400863.970.000.0034.9928.98
Wang, Autumn,130495647.220.000.002071.423575.80
Wilson, Zachary,255581307.06699.100.000.00607.96
Ramos, Paula, W,213764.990.000.000.004.99
Gonzales, Alexis,2352121.980.000.000.0021.98
Jenkins, Anna, M,1723491.260.000.000.0091.26
Serrano, Anne,242443617.830.000.002443.351174.48
Shan, Elijah, L,267951992.460.000.00782.991209.47
Hill, Adam,187406056.610.003578.272478.340.00
Wang, Nathan,140396808.130.000.002049.104759.03
Gao, Jon, C,114568224.460.003399.992391.432433.04
Ferrier, Mathew,2342639.980.000.000.0039.98
Rodriguez, Toni, J,2525139.980.000.000.0039.98
Alvarez, Pedro, E,28120539.990.000.000.00539.99
Wilson, Jasmine,173296021.623578.270.000.002443.35
Moreno, Roberto, R,212063882.550.002181.560.001700.99
Wang, Micah, C,146765188.410.000.002049.103139.31
Perez, Stefanie,27518123.980.000.000.00123.98
Vazquez, Randall, Z,2118635.000.000.000.0035.00
Sara, Donald, M,251142155.920.000.001000.441155.48
Becker, Jenny,1729092.970.000.000.0092.97
Rana, Nancy, H,261501992.460.00782.990.001209.47
Alonso, Alfredo, T,233232745.330.000.002181.56563.77
Goel, Barbara,129886915.440.000.002049.104866.34
Sanchez, Cynthia, S,236623917.540.000.002181.561735.98
Zhao, Jaclyn, D,261671903.480.000.00782.991120.49
Lin, Damien, L,234143391.030.000.003391.030.00
Perez, Ronald,259441274.080.00699.100.00574.98
Huang, Brent,182206021.620.003578.272443.350.00
Patterson, Ashley, R,187366035.600.003578.272457.330.00
Chander, Gregory, J,2200174.980.000.000.0074.98
Zeng, Colleen, L,2830491.970.000.0091.970.00
Liu, Darryl,199476056.510.003578.270.002478.24
Ortega, Joanna,179094761.740.003578.270.001183.47
Martinez, Ethan, C,202605314.250.003578.270.001735.98
Ma, Brittney,125842633.390.002071.420.00561.97
Zimmerman, Krystal,1722877.270.000.000.0077.27
Sullivan, Ruth,277231155.480.000.000.001155.48
Shen, Mitchell, M,229044759.990.000.002181.562578.43
Xu, Clarence,218774624.910.002181.560.002443.35
Blanco, Billy,233162835.020.000.002181.56653.46
Lal, Corey, H,233132906.030.000.002181.56724.47
Luo, Devon, D,228504657.510.000.002181.562475.95
Lal, Terry,182776070.590.003578.270.002492.32
Kumar, Tonya, A,229344173.320.000.002443.351729.97
Gill, Jaime, M,261521938.470.00782.990.001155.48
Smith, Adriana,187025333.250.003578.271754.980.00
Andersen, Tracy,208154118.260.003578.27539.990.00
Zheng, Dennis, E,255671239.090.00699.100.00539.99
Raman, Cindy,161574391.410.000.002071.422319.99
Sara, Geoffrey,261881938.470.000.00782.991155.48
Miller, Zachary, M,151692919.890.000.002071.42848.47
Gill, Diana,257101239.090.00699.100.00539.99
Martin, Naomi, A,15593116.260.000.0088.9827.28
Sai, Abby, L,111018262.520.003399.992439.992422.54
Rubio, Kristy,122433914.980.003374.990.00539.99
Ortega, Janet, L,117548163.530.003399.992319.992443.55
Ma, Amy, E,173096030.613578.270.000.002452.34
Schmidt, Kaitlin,13628191.250.000.000.00191.25
Kapoor, Denise, M,187256044.590.003578.272466.320.00
Weber, Cory,1673981.260.000.0031.2749.99
Jimenez, Naomi,249222145.920.000.001000.441145.48
Pal, Omar,277141155.480.000.000.001155.48
Malhotra, Marco, L,29459805.330.000.000.00805.33
Rana, Carla, K,195935306.540.003578.270.001728.27
Hernandez, Victor, T,2353759.980.000.000.0059.98
Gomez, Sheila, J,211654673.880.002181.560.002492.32
Gao, Susan,274711386.480.000.00782.99603.49
Sara, Ebony,249232159.400.000.001000.441158.96
Zhao, Jamie,1617972.160.000.000.0072.16
Gao, Curtis, D,204295377.750.003578.270.001799.48
Beck, Alicia, L,172484382.753578.270.000.00804.48
Davis, Morgan, J,273591344.470.000.00782.99561.48
Sun, Rafael,267491322.980.000.001322.980.00
Foster, Madison,140386819.120.000.002049.104770.02
Lal, Nina, L,142635647.930.000.002049.103598.83
Chander, Brad, K,2138269.990.000.0069.990.00
Garcia, Charles, M,2025037.270.000.000.0037.27
Morgan, Melissa, M,2022274.450.000.000.0074.45
Ye, Tamara, A,2024360.470.000.000.0060.47
Xu, Barbara,1407459.880.000.000.0059.88
Suri, Barry,1525378.960.000.000.0078.96
Sanchez, Clifford,21188123.960.000.000.00123.96
Gomez, Mallory, R,248987.280.000.000.007.28
Pal, Gilbert,27744643.950.000.00643.950.00
Ma, Jeffery,1826469.970.000.000.0069.97
Raje, Marshall, J,1926742.280.000.000.0042.28
Sullivan, Kaitlin,1691970.950.000.000.0070.95
Ward, Haley, J,166315900.553578.270.000.002322.28
Li, Trisha, A,182966117.690.003578.272539.420.00
Zhou, Kelvin,2023160.470.000.000.0060.47
Sanz, Marvin,196126029.570.003578.270.002451.30
Andersen, Drew, K,224123018.330.000.002443.35574.98
Jai, Maurice,229324169.330.000.004169.330.00
Serrano, Orlando,195616021.620.003578.270.002443.35
Arun, Barry,2770039.980.000.000.0039.98
Kumar, Mindy, R,127006860.440.000.002071.424789.02
Alexander, Olivia, L,146675295.410.000.002049.103246.31
Xu, Crystal, E,157544416.380.000.002071.422344.96
Gill, Roy,29465791.320.000.000.00791.32
Raje, Jodi, E,1963074.450.000.000.0074.45
Hill, Luis,275001371.950.000.00782.99588.96
Shen, Cedric,2220974.980.000.000.0074.98
Jai, Jaime, M,248944.990.000.004.990.00
Xu, Alison,14227114.960.000.0049.9964.97
Martinez, Cory, A,1512581.260.000.0031.2749.99
Lal, Julie, A,283092419.060.000.002419.060.00
Zheng, Jaclyn, F,119108113.030.003374.992319.992418.05
He, Colin, B,143005322.730.000.002071.423251.31
Chandra, Jermaine, A,142995108.760.000.002071.423037.34
Ramos, Jay, D,218824886.700.000.002443.352443.35
Perez, Cesar, L,27982603.490.000.000.00603.49
Dominguez, Theresa, L,187695304.250.003578.270.001725.98
Nelson, Julia, L,11102102.910.000.000.00102.91
Raji, Brad, C,234093917.540.000.002181.561735.98
Serrano, Mathew, A,29186603.490.000.000.00603.49
Evans, Jonathan, D,151854393.700.000.002071.422322.28
Zeng, Alisha, A,15727134.460.000.000.00134.46
Xie, Drew, A,20218104.690.000.000.00104.69
Alvarez, Adrienne, L,17067113.960.000.000.00113.96
Gao, Tiffany, E,163525948.493578.270.000.002370.22
Xu, Cara,235263563.840.000.003563.840.00
Lal, Alicia,157344426.410.000.002071.422354.99
Butler, Carson, T,12672381.970.000.000.00381.97
Martin, Marc, J,110396636.583399.990.000.003236.59
Chande, Ashlee, N,230967.280.000.000.007.28
Liang, Martha,165254752.753578.270.000.001174.48
She, Cedric, R,125802589.090.002049.100.00539.99
Jimenez, Walter,172324347.763578.270.000.00769.49
Liang, Ronnie,2458430.480.000.000.0030.48
Patel, Gerald,230954.990.000.000.004.99
Xie, Wayne, S,183026029.570.003578.272451.300.00
Raji, Kate, L,119038108.040.003374.992294.992438.06
Raje, Christy,231003007.120.000.002443.35563.77
Green, Sydney,23522120.470.000.000.00120.47
She, Tamara, M,142245621.220.000.002049.103572.12
Pal, Clayton,27721166.280.000.000.00166.28
Sanz, Craig, M,2199374.980.000.0074.980.00
Gill, Byron, J,184836056.610.003578.272478.340.00
Ortega, Reginald, K,264291938.470.000.00782.991155.48
Andersen, Nicolas, A,2759439.980.000.0039.980.00
Butler, Destiny,278652419.060.000.000.002419.06
Li, Krystal, A,249122120.930.000.001000.441120.49
Murphy, Alexa,182766106.600.003578.270.002528.33
Kapoor, Rachael, D,1191162.460.000.000.0062.46
Price, Deb,245023623.320.000.002443.351179.97
Zhang, Lacey, L,141273809.570.000.003809.570.00
He, Jake, M,2447212.940.000.000.0012.94
Alonso, Renee,241662789.520.000.002181.56607.96
Zhao, Alisha, M,2198835.000.000.000.0035.00
Zhao, Heather,245964168.830.000.002443.351725.48
Huang, Alan, A,126716802.130.002049.100.004753.03
Shen, Bonnie,2140574.980.000.000.0074.98
Malhotra, Kristopher, L,152652897.570.000.002049.10848.47
Yuan, Keith, N,229263936.540.000.002181.561754.98
Madan, Cassandra, D,29068751.340.000.000.00751.34
Travers, Danny,1258777.270.000.000.0077.27
Jimenez, Marie, C,241763042.820.000.002443.35599.47
Garcia, Troy, M,292904.990.000.004.990.00
Arun, Gerald,259401277.560.00699.100.00578.46
Jai, Tommy, C,150272853.570.000.002049.10804.47
Ward, Jessica,155874423.380.000.002071.422351.96
Huang, Barbara,264421919.750.000.00782.991136.76
Russell, Cassidy, N,2614427.770.000.000.0027.77
Gonzalez, Ann,118948223.000.003374.992394.972453.04
Suri, Rachael, J,18279162.020.000.000.00162.02
Sharma, Corey, M,17495119.910.000.000.00119.91
Liu, Warren,150143860.870.000.002071.421789.45
Torres, Sabrina, E,204254118.260.003578.27539.990.00
Ma, Laura, L,245033617.830.000.002443.351174.48
Rodriguez, Wyatt, D,212184661.500.002181.560.002479.94
Romero, Desiree, J,1723932.280.000.000.0032.28
Goel, Dale, M,204164118.260.003578.27539.990.00
Wu, Warren, M,1560263.970.000.000.0063.97
Blanco, Monique, W,141033612.220.000.002855.89756.33
Lu, Jeffery, B,199716056.610.003578.270.002478.34
Gonzalez, Carolyn, H,224072756.540.000.002181.56574.98
Jai, Michele, E,212254732.860.002181.560.002551.30
Muñoz, Pedro, A,234333882.550.000.002181.561700.99

Generated 2025-11-02 04:55:21.328 UTC