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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Watson, Alexandra, H,252491868.56699.100.000.001169.46
Arthur, Tabitha, E,164824783.743578.270.001205.470.00
Wang, Shannon,110176434.313374.990.002316.97742.35
Holt, Krystal,165184698.763578.270.000.001120.49
Zhang, Warren, L,252521893.05699.100.000.001193.95
She, Melvin,165164733.753578.270.001155.480.00
Huang, Sandra, C,165234698.763578.270.000.001120.49
Thompson, Fernando,163505903.193578.270.000.002324.92
Johnson, Elizabeth,110048196.013399.990.002376.962419.06
Tang, Dawn, R,164965960.233578.270.000.002381.96
Chander, Yolanda,165194752.753578.270.000.001174.48
Alvarez, Janet, G,110068119.033399.990.002334.972384.07
Walker, Anthony, T,252501883.56699.100.000.001184.46
Carlson, Shannon, C,110098091.333374.990.002297.282419.06
Stewart, Ariana,167436070.593578.270.000.002492.32
Raje, Devon,292892433.040.000.000.002433.04
Andersen, Willie, M,2797064.470.000.000.0064.47
Chen, Willie, C,2832229.480.000.000.0029.48
Brown, Cameron, D,13041153.950.000.000.00153.95
Sanz, Eddie, A,19580173.930.000.000.00173.93
Ramos, Briana, J,143033636.910.000.002049.101587.81
Shen, Priscilla, A,28215589.960.000.000.00589.96
Ramos, Joe,123536765.460.002071.420.004694.04
Sanchez, George, M,126806880.100.002049.100.004831.00
Madan, Summer, D,123476839.120.002049.100.004790.02
Ma, Franklin,244853356.040.000.002181.561174.48
Munoz, Cheryl, C,136326838.460.000.002071.424767.04
Sanders, Arianna, E,228594.990.000.000.004.99
Raje, Lindsay, L,206136056.610.003578.270.002478.34
Diaz, Briana,131316737.150.000.002049.104688.05
Xu, Karl,233213060.820.000.002443.35617.47
Raje, Gilbert,110558168.013374.990.002394.972398.05
Xu, Alan,167416056.613578.270.002478.340.00
Romero, Lawrence, C,166876070.593578.270.002492.320.00
Lu, Suzanne, K,167124417.753578.270.000.00839.48
Lu, Jaclyn, D,110476582.333399.990.000.003182.34
Romero, Renee, E,166395908.253578.270.000.002329.98
Dominguez, Wendy,110356451.313374.990.000.003076.32
Hernandez, Diana, F,110386437.333374.990.000.003062.34
Perez, Joel,166844158.243578.270.000.00579.97
Guo, Lacey,167446070.593578.270.002492.320.00
Lu, Trisha,255551277.56699.100.000.00578.46
Stone, Denise,110326525.563374.990.000.003150.57
Goel, Derek,170454480.733578.270.000.00902.46
Gutierrez, Natasha,170484382.753578.270.000.00804.48
Serrano, Derrick,167074377.753578.270.000.00799.48
Pal, Mitchell, R,167426044.593578.270.002466.320.00
King, Evan,166375900.553578.270.000.002322.28
Gomez, Tabitha, L,166886081.103578.270.002502.830.00
Lu, Krystal,170494347.763578.270.000.00769.49
Powell, Lucas, T,18278158.950.000.000.00158.95
Rodriguez, Allen, L,177324752.750.003578.270.001174.48
Raji, Tammy, K,170714417.753578.270.000.00839.48
Wang, Alejandro,173106029.573578.270.000.002451.30
Chen, Cedric, R,170654417.753578.270.000.00839.48
Diaz, Marc,110588248.023399.990.002374.982473.05
Moore, Michael,172474432.723578.270.000.00854.45
Gomez, Anne,1304562.270.000.000.0062.27
Shan, Peter,2428027.770.000.000.0027.77
Wang, Trisha, V,172594404.733578.270.000.00826.46
Zeng, Ernest, M,12992158.510.000.000.00158.51
Griffin, Brianna, K,1648773.240.000.000.0073.24
Chander, Omar, W,172414382.753578.270.000.00804.48
Lopez, Luis, P,173344347.763578.270.000.00769.49
Evans, Carlos, J,235384198.330.000.002443.351754.98
Price, Isabella, L,172784382.750.003578.270.00804.48
Alvarez, Tanya,172796021.620.003578.270.002443.35
Rubio, Randall, M,172866029.570.003578.270.002451.30
Munoz, Alfredo, C,233142744.520.000.002181.56562.96
Allen, Alexandra, B,172934417.750.003578.270.00839.48
Li, Karen, K,179214698.760.003578.270.001120.49
Clark, Sydney,1661067.580.000.0032.6034.98
Ruiz, Bruce, W,16171103.860.000.000.00103.86
Hernandez, Max,1819263.970.000.000.0063.97
Jimenez, Latasha, E,13121121.250.000.000.00121.25
Ross, Adam,110998215.990.003399.992363.962452.04
Yuan, Louis, C,181934145.540.003578.270.00567.27
Li, Aimee,179154792.730.003578.270.001214.46
Nara, Dustin, M,179104698.760.003578.270.001120.49
Gill, Alberto, P,177334758.240.003578.270.001179.97
Chande, Cassie,111038182.500.003374.992388.452419.06
Xu, Tracy, L,179164787.740.003578.270.001209.47
Williams, Anna, R,175044362.740.003578.270.00784.47
Martinez, Daniel, P,177254698.760.003578.270.001120.49
Anderson, Blake,110768159.040.003399.992374.982384.07
Chander, Edwin, T,173704742.740.003578.270.001164.47
Vazquez, Daisy, L,255601288.060.00699.100.00588.96
Zeng, Suzanne,179184733.750.003578.270.001155.48
Yang, Connor,177354752.750.003578.270.001174.48
Griffin, Caroline,177264721.730.003578.270.001143.46
Lal, Katie, E,182106044.590.003578.272466.320.00
Jordan, Ross, F,111248129.020.003399.992309.972419.06
Harris, Eduardo, S,182386030.610.003578.272452.340.00
Lewis, Justin, L,2830374.980.000.000.0074.98
Cai, Susan,19101104.420.000.000.00104.42
Jackson, Joshua,1723583.980.000.000.0083.98
Vazquez, Shannon,2603588.980.000.000.0088.98
Prasad, Dominic, D,1996246.750.000.000.0046.75
Romero, Billy,204194.990.000.000.004.99
Dominguez, Diana, L,292922393.060.000.000.002393.06
Sun, Shannon,120077023.780.003399.990.003623.79
Martinez, Meredith, M,190956056.610.003578.270.002478.34
Huang, Brent,182206021.620.003578.272443.350.00
Sharma, Tony,182416058.210.003578.272479.940.00
Rana, Ivan, K,181964133.240.003578.270.00554.97
Fernandez, Candace,111058095.990.003399.992294.992401.01
Yang, Heather,182756021.620.003578.272443.350.00
Jiménez, Beth, H,111208242.490.003374.990.004867.50
Xie, Karla,182014157.730.003578.270.00579.46
Nara, Latoya, J,182086035.600.003578.272457.330.00
Goel, Misty, M,182456021.620.003578.270.002443.35
Navarro, Kristine, B,255661253.070.00699.100.00553.97
Sharma, Jodi, N,182606035.600.003578.272457.330.00
Carson, Shaun,111264972.370.003399.990.001572.38
Sanz, Ricky,182516035.600.003578.272457.330.00
Sun, Alvin,182526021.620.003578.272443.350.00
Li, Jaclyn,182816081.100.003578.270.002502.83
Xu, Clayton,184886056.610.003578.272478.340.00
Wu, Mandy,183096090.590.003578.272512.320.00
Sanz, Reginald, K,1752274.950.000.000.0074.95
Perez, Whitney,1661997.580.000.0067.5929.99
Chandra, Gerald,251314.990.000.000.004.99
Alonso, Casey, E,234223911.530.000.002181.561729.97
Xu, Arturo,136196808.100.000.002049.104759.00
Kim, Kari, S,114458098.030.003399.992304.982393.06
Phillips, Jeremy, E,184956021.620.003578.272443.350.00
Griffin, Grace,114438235.000.003374.990.004860.01
Taylor, Jennifer,184706021.620.003578.272443.350.00
Deng, Carl,182846029.570.003578.272451.300.00
Martinez, Tina, J,184614748.240.003578.270.001169.97
Suri, Adriana,184634726.040.003578.270.001147.77
Nara, Johnny, R,184896081.100.003578.272502.830.00
Madan, Francisco, S,257061239.090.00699.100.00539.99
Patterson, Kyle,114488132.010.003374.992318.962438.06
Lal, Kenneth, J,187015357.740.003578.271779.470.00
Wu, Christy, D,255681253.070.00699.100.00553.97
Ye, Ramon,113574943.800.003374.990.001568.81
Chander, Bethany, K,114468237.010.003399.992354.982482.04
Hu, Alvin, E,114498130.320.003374.992362.272393.06
Mehta, Preston, G,186926035.600.003578.272457.330.00
Gonzalez, Devin,184856063.210.003578.272484.940.00
Lopez, Adriana, A,120028145.330.003374.990.004770.34
Nara, Leonard, G,11045114.960.000.000.00114.96
Diaz, Jay,1669231.270.000.000.0031.27
Munoz, Anne,1579898.960.000.000.0098.96
Rai, Bradley,1910079.260.000.000.0079.26
Subram, Joe,136316817.120.000.002049.104768.02
Ortega, Julio, M,118928119.030.003399.990.004719.04
Navarro, Daisy,27514539.990.000.000.00539.99
Zhu, Jamie, J,1314069.990.000.000.0069.99
Ms., Sandidge, Mary, R.,14016121.060.000.000.00121.06
Zeng, Cara,204446085.590.003578.270.002507.32
Carlson, Orlando, J,118938123.030.003374.992319.992428.05
Young, Marcus, A,184946037.890.003578.272459.620.00
Malhotra, Cynthia,113585034.780.003374.990.001659.79
Mehta, Brett,114508173.260.003374.992370.222428.05
Murphy, Seth, A,257041239.090.00699.100.00539.99
Gutierrez, Adrienne,189064217.220.003578.27638.950.00
Hill, Adam,187406056.610.003578.272478.340.00
Alonso, Gary, C,187675314.250.003578.270.001735.98
She, Latoya, A,117508148.020.003399.990.004748.03
Gomez, Andy,187215333.250.003578.270.001754.98
Zheng, Darryl,187066060.500.003578.270.002482.23
Luo, Tamara,187386089.590.003578.270.002511.32
Ortega, Janet, L,117548163.530.003399.992319.992443.55
Gutierrez, Jaime, C,114578211.480.003374.992359.962476.53
Fernandez, Denise, A,187246056.510.003578.272478.240.00
Martinez, Sarah, S,126706785.130.002049.100.004736.03
Martin, Craig, M,2501274.460.000.000.0074.46
Henderson, Marcus, D,1521268.960.000.000.0068.96
Wu, Nuan,292932384.070.000.000.002384.07
Diaz, Stacy, L,123406752.130.002049.100.004703.03
James, Mariah, M,1910430.970.000.000.0030.97
Liu, Karen, F,1400863.970.000.0034.9928.98
Romero, Ruben,1663268.870.000.000.0068.87
Liu, Bianca, K,1145831.920.000.000.0031.92
Deng, Colin, B,1829932.220.000.000.0032.22
He, Colin, B,143005322.730.000.002071.423251.31
Ortega, Felicia, J,1175347.920.000.000.0047.92
Ashe, Maurice,204306056.610.003578.270.002478.34
Zeng, Marshall, M,209874132.240.003578.270.00553.97
Lal, Carl, C,2895044.980.000.000.0044.98
Butler, Carson, T,12672381.970.000.000.00381.97
Huang, Alan, A,126716802.130.002049.100.004753.03
Stone, Colin, K,126736768.140.002049.100.004719.04
Gomez, Ricky,187376021.620.003578.272443.350.00
Deng, Tasha,114598141.330.003399.992322.282419.06
Ortega, Linda, C,117568078.020.003374.990.004703.03
Gao, Edwin,257161302.590.00699.100.00603.49
Sun, Candice, A,195686060.500.003578.270.002482.23
Saunders, Patricia, J,195655308.240.003578.270.001729.97
Subram, Troy, R,196076054.220.003578.270.002475.95
Gomez, Randall, R,117628228.010.003399.992389.962438.06
Powell, Kaitlyn,195985310.530.003578.270.001732.26
Prasad, Meagan,196116054.220.003578.270.002475.95
Suarez, Alfredo,196015314.250.003578.270.001735.98
Martinez, Kari,196096093.200.003578.270.002514.93
Gao, Krystal,258211879.070.00699.100.001179.97
Sun, Franklin,196155279.260.003578.270.001700.99
Fernandez, Tammy, A,258254.990.000.000.004.99
Yuan, Willie,234214208.310.000.002443.351764.96
Kennedy, Devon, J,131336813.120.000.002049.104764.02
Arun, Brenda,136306824.730.000.002071.424753.31
Shen, Gilbert, C,120056984.810.003399.990.003584.82
Barnes, Angelica,1512877.270.000.000.0077.27
Srini, Kristopher, A,2399739.980.000.000.0039.98
Carlson, Krista,28209574.980.000.000.00574.98
Wood, Julia, L,123566810.130.002049.100.004761.03
Garcia, Charles, M,2025037.270.000.000.0037.27
Lal, Colin, M,1664069.970.000.000.0069.97
Butler, Gavin, D,2294971.970.000.000.0071.97
Suri, Gerald,13617116.920.000.000.00116.92
Lopez, Bruce,235403626.820.000.002443.351183.47
Xie, Kurt, A,14344126.950.000.000.00126.95
Torres, Sebastian, V,258311882.570.00699.100.001183.47
Ortega, Danny, K,197946098.580.003578.270.002520.31
Nath, Louis, C,258301833.570.00699.100.001134.47
Shan, Derek, R,197826089.590.003578.270.002511.32
Zhou, Warren,197916058.210.003578.270.002479.94
Watson, Nathaniel, H,258261854.580.00699.100.001155.48
Liu, Clarence,197976021.620.003578.270.002443.35
Nara, Karla, C,258271873.580.00699.100.001174.48
Mehta, Arthur, A,199576035.600.003578.270.002457.33
Wu, Amy,197906089.590.003578.270.002511.32
Lu, Ronnie,199506098.540.003578.270.002520.27
Liu, Darryl,199476056.510.003578.270.002478.24
Barnes, Mariah, H,196216021.620.003578.270.002443.35
Nara, Cristina, R,197926056.610.003578.270.002478.34
Mr., Spencer, Phil,199606120.110.003578.270.002541.84
Carlson, Byron,119008257.010.003399.992374.982482.04
Raji, Kate, L,119038108.040.003374.992294.992438.06
Scott, Timothy,196315279.260.003578.270.001700.99
Zimmerman, Krystal,1722877.270.000.000.0077.27
Suarez, Meredith,150323800.080.000.002049.101750.98
Yuan, Alicia,252252129.920.000.001000.441129.48
Wu, Alisha,2365459.980.000.000.0059.98
Reed, Steven,2437327.770.000.000.0027.77
Zhou, Colleen,2312213.980.000.000.0013.98
Sanz, Diane, M,2015313.980.000.000.0013.98
Navarro, Teresa, E,258167.280.000.000.007.28
Carlson, Alfredo,16178108.850.000.000.00108.85
Hernandez, Melody, E,28212619.460.000.000.00619.46
Nara, Rafael, J,1705296.920.000.000.0096.92
Ramos, Michele, J,1957496.740.000.000.0096.74
Gonzalez, Summer, L,2026660.470.000.000.0060.47
Raji, Carly, L,233464.990.000.000.004.99
Tang, Shawn,258321850.860.00699.100.001151.76
Xu, Mindy,202466035.600.003578.270.002457.33
Guo, Jamie,201514152.730.003578.27574.460.00
Dominguez, Gina, L,202136029.570.003578.270.002451.30

Generated 2024-11-09 16:24:07.903 UTC