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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Zeng, Alvin, M,11118115.850.000.000.00115.85
Lopez, Luis, P,173344347.763578.270.000.00769.49
Alvarez, Diana,136386832.120.000.002049.104783.02
Lin, Dawn, N,15805127.470.000.000.00127.47
Martin, Adrienne,1995239.460.000.0025.4813.98
Muñoz, Pedro, A,234333882.550.000.002181.561700.99
Gonzalez, Clifford,245053302.050.000.002181.561120.49
Alonso, Armando, M,136476793.150.000.002049.104744.05
She, Tamara, M,142245621.220.000.002049.103572.12
Xu, Alicia,1137079.970.000.000.0079.97
Lee, David, J,221994693.880.002181.560.002512.32
Shan, Bethany, L,139735185.680.000.002835.702349.98
King, Evan,166375900.553578.270.000.002322.28
Cai, Jeffery, A,155822907.560.000.002049.10858.46
Hernandez, Krista, J,269181399.940.000.00782.99616.95
Rana, Pedro, F,139706843.140.000.002049.104794.04
Kumar, Jaime, O,290613.990.000.000.003.99
Lee, Destiny,1705883.980.000.000.0083.98
Huang, Eugene, L,110016383.883374.990.002419.93588.96
Zheng, Rosa, G,166295933.263578.270.000.002354.99
Chande, Ricardo, L,244714.990.000.004.990.00
Zhang, Tiffany, R,1731843.970.000.0043.970.00
Martin, Anna, L,209884118.260.003578.27539.990.00
Kumar, Keith, M,252247.280.000.007.280.00
Zhao, Kristen,169307.950.000.007.950.00
Rubio, Kendra,170474347.763578.270.00769.490.00
Dominguez, Theresa, L,187695304.250.003578.271725.980.00
Hernandez, Melinda,16174140.450.000.0092.4847.97
Carson, Kelvin, A,119958249.010.003399.990.004849.02
Carlson, Ebony,139596858.420.000.002049.104809.32
Ma, Curtis,28119574.980.000.000.00574.98
Navarro, Monique, R,1524073.960.000.000.0073.96
Dominguez, Lee, R,245974009.500.000.002181.561827.94
Zhang, Kristen,274841322.980.000.00782.99539.99
Subram, Ronald, P,27733157.290.000.000.00157.29
Alonso, Brandi,1706186.270.000.000.0086.27
Shen, Cristina,267681371.950.000.001371.950.00
Xie, Derek,142875141.430.000.002049.103092.33
Gomez, Jerome, J,250572120.930.000.001000.441120.49
Ross, Arianna, E,267741331.970.000.001331.970.00
Gao, Micah, W,251062170.920.000.001000.441170.48
Sara, Troy, R,225832821.510.000.002181.56639.95
Huang, Wesley,2932023.970.000.000.0023.97
Wang, Laura, L,2614669.990.000.000.0069.99
Schmidt, Kaitlin,13628191.250.000.0032.27158.98
Blanco, Jimmy, V,14013138.450.000.00103.4634.99
Beck, Cedric, L,2240369.990.000.0069.990.00
Blanco, Lee, M,166605898.263578.270.000.002319.99
Guo, Autumn, A,1421386.260.000.0058.9827.28
Wu, Shannon, F,152682840.910.000.002071.42769.49
Zhao, Colin, D,242412997.320.000.002443.35553.97
Goldstein, Brendan,135182638.360.000.002049.10589.26
Gomez, Marc, J,2188039.990.000.000.0039.99
Torres, Alfredo,2768574.980.000.000.0074.98
Richardson, Abigail, S,142365710.230.000.002071.423638.81
Rodriguez, Brett,2513439.980.000.000.0039.98
Alvarez, Larry, T,142355682.200.000.002071.423610.78
She, Gregory,184584733.750.003578.270.001155.48
Li, Crystal, L,143255152.700.000.002049.103103.60
Andersen, Brendan,151215202.730.000.002071.423131.31
Ramos, Naomi, M,236564144.340.000.002443.351700.99
Jai, Brendan,26755123.980.000.000.00123.98
Zhang, Damien, C,267581322.980.000.001322.980.00
Zhang, Dawn, A,1422282.260.000.000.0082.26
Wang, Kelvin, S,151434366.410.000.002071.422294.99
Raman, Abby, T,151225193.720.000.002071.423122.30
Lopez, Virginia, J,273381339.920.000.001339.920.00
Torres, Melinda, J,140336809.960.000.002071.424738.54
Liu, Randy,150153804.080.000.002049.101754.98
Ramos, Roy, A,244823882.550.000.002181.561700.99
Serrano, Deanna, W,151444344.090.000.002049.102294.99
Guo, Cedric, R,274871322.980.000.00782.99539.99
Zhu, Lacey,241672983.340.000.002443.35539.99
Munoz, Sheila,274881322.980.000.00782.99539.99
Howard, Jesse, D,242492756.540.000.002181.56574.98
Johnson, Morgan, E,120114735.810.003374.99618.47742.35
Luo, Colleen, E,152082951.560.000.002049.10902.46
Dominguez, Raquel, A,274701371.950.000.00782.99588.96
Raji, Michele,151834368.700.000.002071.422297.28
He, Jake, M,2447212.940.000.000.0012.94
Raji, Warren, J,267961957.470.000.00782.991174.48
Lopez, Ross,1844360.470.000.000.0060.47
Gonzalez, Joel, A,150433846.890.000.002071.421775.47
Long, Nicole, C,13624114.970.000.0059.9854.99
Xu, Jaclyn,242522744.520.000.002181.56562.96
Cook, Sydney, D,131185669.900.000.002049.103620.80
Suri, Carmen, E,242502738.490.000.002181.56556.93
Moore, Devin, J,16167102.570.000.000.00102.57
Romero, Frank, M,152092916.560.000.002049.10867.46
Baker, Jose, A,229374179.330.000.002443.351735.98
Jimenez, Marie, C,241763042.820.000.002443.35599.47
Xu, Alejandro, R,265851903.480.000.00782.991120.49
Srini, Deanna,151824391.410.000.002071.422319.99
Sai, Levi,163495898.263578.270.000.002319.99
Blanco, Robyn, R,241793052.310.000.002443.35608.96
Yuan, Sharon,1200855.760.000.000.0055.76
Chen, Jon,269201336.960.000.00782.99553.97
Garcia, Levi, G,2123239.980.000.000.0039.98
He, Ramon,269191350.750.000.00782.99567.76
Gonzalez, Carla, J,183366145.070.003578.270.002566.80
Li, Edwin,269671336.960.000.001336.960.00
Jiménez, Byron,160263804.080.000.002049.101754.98
Black, Russell,1889737.290.000.000.0037.29
Zhang, Glenn, A,139675721.910.000.002049.103672.81
Zeng, Krystal, A,2581461.960.000.000.0061.96
Fernandez, Brenda, L,164934197.253578.270.000.00618.98
Lal, Jodi, J,2294464.470.000.0064.470.00
He, Karen, C,27861539.990.000.000.00539.99
Becker, Leonard, C,22405123.980.000.00123.980.00
Martin, Hector,27860615.470.000.000.00615.47
Vance, Phillip,293082438.060.000.002438.060.00
Zhou, Gilbert,244753945.530.000.002181.561763.97
Garcia, Frederick, J,16489112.730.000.00112.730.00
Sharma, Raul, E,163475918.503578.270.000.002340.23
Ramos, Victor, D,242469.990.000.009.990.00
Saunders, Brandy,119464697.310.003399.99554.97742.35
Kapoor, Dominic, J,1669967.580.000.0032.6034.98
Navarro, Marc,1634637.550.000.006.2831.27
Sanz, Nelson, M,1405649.480.000.0024.4924.99
Goldberg, Mindy,161594411.650.000.002071.422340.23
Raman, Ruben,155802910.900.000.002071.42839.48
Kumar, Lacey,139606871.740.000.002071.424800.32
Sanchez, Andre,155954369.090.000.002049.102319.99
Zheng, Sandra, P,1514163.970.000.000.0063.97
Gonzalez, Edgar, A,156483807.400.000.002071.421735.98
Lal, Mitchell, C,204037.280.000.000.007.28
Gao, Cara, B,156423772.410.000.002071.421700.99
Shen, Kelsey, R,229214647.880.000.002181.562466.32
Suri, Patricia, E,154363772.410.000.002071.421700.99
Liang, Eugene,1397277.270.000.000.0077.27
Srini, Darren, P,155914346.380.000.002049.102297.28
Rubio, Deanna, T,1957333.980.000.000.0033.98
Srini, Carolyn, S,273711350.750.000.00782.99567.76
Moreno, Mallory, P,229124659.900.000.002181.562478.34
Rai, Calvin,152292833.570.000.002049.10784.47
Serrano, Neil, L,17076103.460.000.000.00103.46
Prasad, Ebony,243683946.520.000.002181.561764.96
Munoz, Teresa, R,277121174.480.000.000.001174.48
Chen, Clayton, A,152194399.080.000.002049.102349.98
Collins, Jennifer,113644921.820.003374.990.001546.83
Raman, Geoffrey, P,154353801.390.000.002071.421729.97
Zheng, Jenny, R,119474747.300.003374.99629.96742.35
Rodriguez, Frederick, S,244584144.340.000.002443.351700.99
Deng, Arturo, A,281021299.830.000.000.001299.83
Prasad, Henry, M,243643965.520.000.002181.561783.96
Kumar, Gilbert, L,2814039.980.000.000.0039.98
Arun, Troy, P,152214447.870.000.002071.422376.45
Ma, Darryl, R,1559981.240.000.0049.9731.27
Bell, Stephanie, A,273701322.980.000.00782.99539.99
Watson, Alexandra, H,252491868.56699.100.000.001169.46
Gill, Diane,155784509.900.000.002071.422438.48
Suarez, Jacquelyn, C,110108088.043399.990.002294.992393.06
Stone, Keith,1733140.960.000.000.0040.96
Alvarez, Janet, G,110068119.033399.990.002334.972384.07
Ye, Franklin, L,1395282.260.000.000.0082.26
Verhoff, Rob,110088106.313374.990.004731.320.00
Blanco, Kristi,1546437.270.000.000.0037.27
Walker, Anthony, T,252501883.56699.100.000.001184.46
Blanco, Erika, L,1466990.250.000.000.0090.25
Jimenez, Jill,110286474.623374.990.000.003099.63
Garcia, Ivan, L,173546029.573578.270.000.002451.30
Perez, Ross, E,14307196.260.000.00163.9932.27
Beck, Donna, J,1824784.960.000.000.0084.96
Raje, Lindsay, L,206136056.610.003578.270.002478.34
Ferrier, Jaclyn, D,172994382.753578.270.000.00804.48
Kovar, Mayra, J,173124471.743578.270.000.00893.47
Rai, Tracy, K,170794417.753578.270.000.00839.48
Wilson, Jasmine,173296021.623578.270.000.002443.35
Jimenez, Walter,172324347.763578.270.000.00769.49
Navarro, Tyrone, K,255571262.87699.100.000.00563.77
Allen, Alexandra, B,172934417.753578.270.000.00839.48
Perry, Maria, N,177284730.033578.270.000.001151.76
Li, Karen, K,179214698.763578.270.000.001120.49
Romero, Sabrina, L,28534603.490.000.000.00603.49
Prasad, Dominic, D,1996246.750.000.0016.2730.48
Price, Vanessa, A,2356939.980.000.000.0039.98
Prasad, Darren,1237299.030.000.0096.742.29
Ross, Adam,110998215.993399.990.002363.962452.04
Sharma, Bonnie, R,255621239.09699.100.000.00539.99
Lal, Shawna,179244733.753578.270.000.001155.48
Tang, Bridget,177304752.233578.270.000.001173.96
Li, Lacey,175154143.263578.270.00564.990.00
Vazquez, Daisy, L,255601288.06699.100.000.00588.96
Sun, Leah,177344698.763578.270.000.001120.49
Zeng, Micah, A,255611288.06699.100.000.00588.96
Price, Megan,249072183.910.000.002183.910.00
Suarez, Alberto, G,1871953.990.000.0053.990.00
Saunders, Bobby, D,22205120.480.000.000.00120.48
Sharma, Christian,1580962.590.000.0032.6029.99
Becker, Kathryn,2458813.980.000.000.0013.98
Morgan, Mackenzie, E,16162185.040.000.000.00185.04
Pal, Drew,1190263.040.000.006.2856.76
Lin, Autumn, E,182726056.613578.270.002478.340.00
Griffin, Rachel,182556067.200.003578.270.002488.93
Navarro, Kristine, B,255661253.070.00699.100.00553.97
Chander, Alison,182496044.590.003578.272466.320.00
Perez, Kevin, M,255651239.090.00699.100.00539.99
Sharma, Jodi, N,182606035.600.003578.272457.330.00
Sun, Alvin,182526021.620.003578.272443.350.00
Gill, Erika, A,182024143.260.003578.270.00564.99
Sun, Brittney,113655024.790.003374.990.001649.80
Xu, Clayton,184886056.610.003578.272478.340.00
Anand, Bradley,1962639.460.000.000.0039.46
Navarro, Daisy,27514539.990.000.000.00539.99
Liang, Dennis,14034104.240.000.000.00104.24
Zhang, Claudia,131146807.450.000.002071.424736.03
Henderson, Angela, T,118988179.030.003399.992394.972384.07
Carlson, Orlando, J,118938123.030.003374.992319.992428.05
Andersen, Nina,183386124.580.003578.270.002546.31
Yang, Jamie, S,184654752.750.003578.270.001174.48
Subram, Ann, M,186936021.620.003578.272443.350.00
Romero, Wendy, H,113724965.810.003374.990.001590.82
Zhao, Ernest, C,187005328.230.003578.271749.960.00
Li, Trisha, A,182966117.690.003578.272539.420.00
McDonald, Kaitlin,184936029.570.003578.272451.300.00
Serrano, Shannon, R,183036030.610.003578.272452.340.00
Mehta, Preston, G,186926035.600.003578.272457.330.00
Miller, Edward,113685106.240.003374.990.001731.25
Gill, Byron, J,184836056.610.003578.272478.340.00
Romero, Billy,204194.990.000.004.990.00
Dominguez, Diana, L,292922393.060.000.002393.060.00
Patel, Janelle, T,2911617.270.000.0017.270.00
Wu, Clarence, L,131156779.420.000.002049.104730.32
Goldstein, Dustin,123378137.010.003399.992343.962393.06
Jai, Bonnie,119778212.500.003399.992350.962461.55
Martinez, Meredith, M,190956056.610.003578.272478.340.00
Andersen, Willie, M,2797064.470.000.0064.470.00
Shan, Bridget,2933839.980.000.000.0039.98
Chen, Willie, C,2832229.480.000.0029.480.00
Carlson, Lance, E,228564.990.000.000.004.99
Sanchez, George, M,126806880.100.002049.102369.972461.03
Liu, Bianca, K,1145831.920.000.0023.977.95
Serrano, Max, E,120108203.500.003374.992384.962443.55
Liu, Omar, L,122523938.950.003374.990.00563.96
Diaz, Gloria,252701854.58699.100.000.001155.48
Sharma, Sharon, T,252941882.57699.100.000.001183.47
Munoz, Deanna,110548223.023399.990.002403.972419.06
Arthur, Kristi, W,166754385.033578.270.00806.760.00
Nath, Jaime,110336495.293374.990.000.003120.30
Lu, Trisha,255551277.56699.100.000.00578.46
Lopez, Heidi,110528131.323374.990.002337.272419.06
Stone, Denise,110326525.563374.990.000.003150.57
Coleman, Ethan, G,166936060.503578.270.002482.230.00
Xu, Edwin, J,252721873.58699.100.000.001174.48
Rai, Karl, M,252731898.07699.100.000.001198.97
Martinez, Emmanuel, V,2137039.980.000.000.0039.98
Powell, Lucas, T,18278158.950.000.00123.9634.99
Jai, Carly,229862756.540.000.002181.56574.98
Gomez, Anne,1304562.270.000.0034.9927.28
Shan, Peter,2428027.770.000.000.0027.77

Generated 2024-09-20 00:51:55.811 UTC