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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Gonzalez, Eric, C,1909278.260.000.000.0078.26
Malhotra, Arthur, E,2526725.480.000.0025.480.00
Lopez, Pamela, E,264441938.710.000.00782.991155.72
Lu, Warren, H,289257.280.000.000.007.28
Bailey, Destiny, C,2294158.980.000.000.0058.98
Cai, Karen,225722997.320.000.002443.35553.97
Shen, Dustin,27974553.970.000.000.00553.97
Mehta, Michele,26143123.980.000.000.00123.98
Ortega, Reginald, K,264291938.470.000.00782.991155.48
Garcia, Darren,2871629.480.000.000.0029.48
Hernandez, Marvin, A,230777.280.000.007.280.00
Sai, Bryant, S,225772743.040.000.002181.56561.48
Beck, Bonnie, A,29097548.980.000.000.00548.98
Xu, Trisha,2028237.270.000.000.0037.27
Gill, Carolyn,2309467.930.000.0067.930.00
Ye, Brent,2892229.480.000.000.0029.48
Zhao, Jamie,1617972.160.000.000.0072.16
Griffin, Olivia,2120839.980.000.0039.980.00
Subram, Cassandra, M,1661876.150.000.000.0076.15
Madan, Denise, R,2524839.980.000.000.0039.98
Pal, Terrence, M,1303759.980.000.0034.9924.99
Malhotra, Tina, C,27584599.470.000.000.00599.47
Alonso, Kathleen,2119634.980.000.000.0034.98
Liang, Barbara, T,229533899.490.000.003899.490.00
West, Nathan,2437067.930.000.000.0067.93
Zhu, Wesley, L,1962423.780.000.000.0023.78
She, Nina,229613891.540.000.003891.540.00
Gonzalez, Roy, M,1304059.980.000.000.0059.98
Raman, Cassandra,2871867.970.000.000.0067.97
Goel, Tommy,229093980.520.000.002181.561798.96
Alonso, Billy, M,2285239.990.000.000.0039.99
Xu, Cristina,2501714.980.000.000.0014.98
Vazquez, Casey, S,131326880.620.000.002049.104831.52
Navarro, Mathew, A,1967337.290.000.000.0037.29
Williams, Nicholas, A,2580921.490.000.000.0021.49
Rai, Johnny, A,131356773.140.000.002049.104724.04
Rana, Molly,2155474.980.000.000.0074.98
Yang, Alan, L,1560539.970.000.000.0039.97
Johnson, Logan, K,229313882.550.000.003882.550.00
Zhao, Alisha, M,2198835.000.000.000.0035.00
Raji, Dale,1926542.280.000.000.0042.28
Cai, Warren,249182120.930.000.001000.441120.49
Shen, Misty, S,2501923.970.000.000.0023.97
Jai, Gregory,1634246.470.000.000.0046.47
Kennedy, Devon, J,131336813.120.000.002049.104764.02
Raje, Gregory, C,2291139.980.000.000.0039.98
Malhotra, Janelle,2642569.990.000.000.0069.99
Shan, Carl, D,249192212.890.000.002212.890.00
Suarez, Leslie, C,2295513.980.000.000.0013.98
Nara, Lindsay, M,252474.990.000.000.004.99
Ramos, Joy,131296823.150.000.002049.104774.05
Rodriguez, Harold, M,2118474.980.000.000.0074.98
Gutierrez, Carrie, C,28139127.280.000.000.00127.28
Jai, Carly,229862756.540.000.002181.56574.98
Serrano, Joy, L,14069173.940.000.000.00173.94
Sai, Holly, V,2676937.290.000.000.0037.29
Mehta, Chelsea,229514242.310.000.004242.310.00
Cox, Angel, M,1879330.480.000.000.0030.48
Martin, Reginald,14054210.770.000.000.00210.77
Cox, Nicole, V,229503917.540.000.003917.540.00
Ramos, Cindy, G,11361114.960.000.000.00114.96
Rodriguez, Toni, J,2525139.980.000.000.0039.98
Miller, Dalton, D,131306797.150.000.002049.104748.05
Gao, Rosa,2603421.490.000.000.0021.49
Liang, Randy, E,2895814.980.000.000.0014.98
Wu, Clarence, L,131156779.420.000.002049.104730.32
Rana, Marco, K,2447313.980.000.000.0013.98
Carlson, Audrey, A,2526360.470.000.000.0060.47
Long, Isabelle, W,231043490.030.000.003490.030.00
Serrano, Randall,27973539.990.000.000.00539.99
Munoz, Felicia, D,2040659.980.000.000.0059.98
She, Keith, L,265631957.470.000.00782.991174.48
Gonzalez, Heidi, Z,1315724.990.000.000.0024.99
Flores, Brianna,27706553.970.000.000.00553.97
Garcia, Martin, l,233324144.340.000.002443.351700.99
Ramos, Stacy, D,1826185.960.000.000.0085.96
Shen, Franklin,2714439.990.000.000.0039.99
Sara, Ebony,249232159.400.000.001000.441158.96
Xu, Wesley, K,29182539.990.000.000.00539.99
Martin, Tabitha,2526923.780.000.000.0023.78
Wang, Alan,136226841.430.000.002071.424770.01
Martinez, Harold, J,2060493.490.000.000.0093.49
Navarro, Lori,2118232.280.000.000.0032.28
Moreno, Monique, R,231183913.820.000.002181.561732.26
Vazquez, Janet, R,2197356.970.000.000.0056.97
Prasad, Francisco,16628187.580.000.000.00187.58
Ye, Damien, M,136206848.070.000.002049.104798.97
Gonzalez, Marco,27598556.260.000.000.00556.26
Alvarez, Tyrone, K,27693539.990.000.000.00539.99
Gutierrez, Erika,1722783.970.000.0024.9958.98
Vazquez, Francis, E,1728183.970.000.000.0083.97
Gao, Candice, M,17493130.960.000.000.00130.96
Zhang, Barbara,16338169.430.000.00169.430.00
Raji, Nicolas, N,1730174.980.000.000.0074.98
Walker, Seth, E,27689539.990.000.000.00539.99
Munoz, Alfredo, C,233142744.520.000.002181.56562.96
Ramos, Rebekah, L,27984561.480.000.000.00561.48
Raman, Virginia,2615969.990.000.000.0069.99
Liu, Krystal, D,135264549.760.000.002071.422478.34
Diaz, Vanessa, J,29100102.960.000.000.00102.96
Raji, Colleen,27707561.480.000.000.00561.48
Ortega, Max,234133617.830.000.003617.830.00
Russell, Alexis, L,13634234.930.000.000.00234.93
Kapoor, Arthur,2448323.970.000.000.0023.97
Wood, Sydney,233103333.320.000.003333.320.00
Alonso, Lance, I,1405764.970.000.000.0064.97
Vance, Henry,27986553.970.000.000.00553.97
Alonso, Alfredo, T,233232745.330.000.002181.56563.77
Raman, Rachael,2521679.470.000.000.0079.47
Xie, Lindsey, M,251324.990.000.000.004.99
Gray, Jeremiah,233314144.340.000.002443.351700.99
Ruiz, Kristine, J,246074.990.000.000.004.99
She, Mindy, J,13009168.670.000.000.00168.67
Jimenez, Kathleen,266541346.760.000.001346.760.00
Lal, Sheena,2331213.980.000.000.0013.98
Campbell, Haley, L,1730462.270.000.000.0062.27
Guo, Margaret,234314158.320.000.002443.351714.97
Clark, Joshua, A,2613769.990.000.000.0069.99
Liu, Brittney, M,1580498.960.000.000.0098.96
Patel, Jillian,266671390.950.000.001390.950.00
Xu, Tasha, E,1194882.260.000.000.0082.26
Lu, Alan,1976167.930.000.000.0067.93
Ray, Bobby,235753302.050.000.002181.561120.49
Rubio, Tanya, I,15598167.930.000.000.00167.93
Malhotra, Marco, L,29459805.330.000.000.00805.33
Martinez, Brett,235323337.040.000.003337.040.00
Yuan, Derek, L,275891183.470.000.000.001183.47
Martin, Pedro, B,281031214.850.000.000.001214.85
Zhou, Krystal,235933990.010.000.002181.561808.45
Green, Kyle,283284.990.000.000.004.99
Deng, Kenneth,2023534.980.000.000.0034.98
Jiménez, Bruce, L,236403936.540.000.002181.561754.98
Ms., Robinson, Rebecca, A.,1191341.260.000.000.0041.26
Martin, Beth, K,2331739.980.000.000.0039.98
Sanz, Cheryl, G,140465645.240.000.003340.262304.98
Chander, Andres, E,29460751.340.000.000.00751.34
Andersen, Jaime,2526860.470.000.000.0060.47
Navarro, Javier,141313807.400.000.003807.400.00
Moreno, Randall, F,2120939.990.000.000.0039.99
Ma, Jeffery,1826469.970.000.000.0069.97
Munoz, Tanya,234363950.520.000.002181.561768.96
Carlson, Mathew, A,230124.990.000.000.004.99
Martin, Lance,2523639.980.000.000.0039.98
Ramos, Kristine,17479163.400.000.0062.94100.46
Raman, Dominique, D,1302358.980.000.000.0058.98
Rai, Shaun,2643123.780.000.000.0023.78
Malhotra, Kristina,2503125.480.000.0025.480.00
Arun, Denise,2821818.970.000.000.0018.97
Xie, Chad, A,26155128.970.000.000.00128.97
Wu, Lisa,2615894.480.000.0094.480.00
Alexander, Alyssa, M,1728237.270.000.000.0037.27
Gill, Lee, L,276941184.460.000.000.001184.46
Yang, Stacey,142155665.890.000.002049.103616.79
Prasad, Cory,197484.990.000.000.004.99
Alvarez, Arthur,248927.280.000.000.007.28
Muñoz, Pedro, A,234333882.550.000.002181.561700.99
Vazquez, Jonathon,1790621.490.000.000.0021.49
Ruiz, Sabrina, A,2221442.280.000.000.0042.28
Mr., Sands, Patrick,140635676.250.000.003321.262354.99
Romero, Ebony, A,2771712.940.000.000.0012.94
King, Hailey, A,2821459.980.000.000.0059.98
Kumar, Karl, J,142185651.880.000.002049.103602.78
Romero, Clinton, F,28132548.980.000.000.00548.98
Hu, Edwin,242404.990.000.000.004.99
Nath, Katie, A,234343882.550.000.002181.561700.99
Suri, Rachael, J,18279162.020.000.000.00162.02
Sullivan, Ruth,277231155.480.000.000.001155.48
Munoz, Kendra, S,235293617.830.000.003617.830.00
Romero, Raquel, Z,2291658.980.000.000.0058.98
Arthur, Joel,277011155.480.000.000.001155.48
Hernandez, Ebony, S,235743337.040.000.003337.040.00
Gill, Dwayne, A,19675198.990.000.000.00198.99
Hernandez, Clinton,29462854.820.000.000.00854.82
Serrano, Joanna, J,266631976.940.000.00782.991193.95
Subram, Cory, B,27599603.490.000.000.00603.49
Barnes, Alexia, D,1523159.480.000.000.0059.48
Gonzalez, Shane, Y,141253772.410.000.003772.410.00
Kapoor, Cynthia,29457756.330.000.000.00756.33
Alonso, Joanna, M,27862548.980.000.000.00548.98
Jimenez, Melody, S,140663612.190.000.002853.57758.62
Lu, Darryl,277021155.480.000.000.001155.48
Washington, Sydney,289244.990.000.000.004.99
Rubio, Derrick, P,235253302.050.000.003302.050.00
Rana, Ruben,276961183.470.000.000.001183.47
Madan, Brandy, A,276871183.470.000.000.001183.47
Gao, Jorge,235733337.040.000.002181.561155.48
Becker, Grant,2139032.280.000.000.0032.28
Pal, Terry, H,2582439.980.000.000.0039.98
Chander, Karla,236484144.340.000.002443.351700.99
Chen, Bianca,248914.990.000.000.004.99
Ashe, Katie, Z,2677069.990.000.000.0069.99
Lal, Franklin, A,141013679.900.000.002888.58791.32
Zhao, Lacey, M,277131158.960.000.000.001158.96
Jiménez, Briana, T,28118588.960.000.000.00588.96
Raman, Brandy,1224777.270.000.0077.270.00
Ferrier, Jaime, P,2352875.970.000.000.0075.97
Lopez, Dominic, B,275901189.460.000.000.001189.46
Diaz, Devin, D,15829187.980.000.0024.99162.99
Gutierrez, Victor, J,2735769.990.000.000.0069.99
Cook, Faith,278712384.070.000.000.002384.07
Cai, Suzanne,250512174.920.000.001000.441174.48
Suri, Kristopher, M,2284950.230.000.000.0050.23
Coleman, Paige, L,1526369.970.000.000.0069.97
Andersen, Colin,250532183.910.000.001000.441183.47
Lin, Heather, L,1571863.970.000.000.0063.97
Carlson, Joanna,1559434.990.000.000.0034.99
Alvarez, Marvin,236513917.540.000.002181.561735.98
Garcia, Stefanie, E,277431155.480.000.000.001155.48
King, Nathan,27719599.470.000.000.00599.47
Deng, Peter, A,240062721.550.000.002181.56539.99
Lal, Alisha, C,2187234.980.000.000.0034.98
She, Jeffery, M,2714942.280.000.000.0042.28
She, Tamara, M,142245621.220.000.002049.103572.12
Diaz, Emma, L,1871110.240.000.000.0010.24
Jai, Calvin, S,229184.990.000.000.004.99
Shen, Grant, B,267631957.470.000.00782.991174.48
Serrano, Mathew, A,29186603.490.000.000.00603.49
Suri, Molly,1750398.960.000.000.0098.96
Lee, Richard, I,239962744.520.000.002181.56562.96
Luo, Nina,2749535.000.000.000.0035.00
Gutierrez, Jaime, A,2522739.980.000.000.0039.98
Butler, Katherine, F,267601322.980.000.001322.980.00
Lewis, Nicole,21881128.970.000.000.00128.97
Gao, Lisa, A,197534.990.000.000.004.99
Munoz, Monique,240082730.540.000.002181.56548.98
Ma, Todd,1958121.490.000.000.0021.49
Ferrier, Mathew,2342639.980.000.000.0039.98
Rai, Terrence, R,250372174.920.000.001000.441174.48
Smith, Andre,2117442.280.000.000.0042.28
Ma, Louis,2187935.000.000.000.0035.00
Guo, Sandra,236643941.530.000.002181.561759.97
Gao, Laura,2202930.970.000.000.0030.97
Gao, Eugene,29464756.330.000.000.00756.33
Fernandez, Lydia, M,145233807.400.000.002071.421735.98
Navarro, Erik, E,250557.280.000.000.007.28
Subram, Ross, L,230857.280.000.000.007.28
Chande, Bonnie, L,239923167.820.000.002443.35724.47
Ramos, Larry,1844621.490.000.000.0021.49
Alvarez, Beth, M,2930514.980.000.000.0014.98
Yuan, Carl, P,241603046.840.000.002443.35603.49
Sanz, Paula,2643069.990.000.000.0069.99
Rodriguez, Heidi, L,251202155.920.000.001000.441155.48
Sanz, Sabrina, A,1965042.280.000.000.0042.28
Diaz, Josue,152074446.400.000.002071.422374.98
Srini, Jay, M,1832662.980.000.000.0062.98
Lu, Crystal, A,151454368.700.000.002071.422297.28
Sullivan, Toni, M,290833.990.000.000.003.99
Lopez, Deanna, L,251192148.210.000.001000.441147.77
Martinez, Ivan,278722393.060.000.000.002393.06
Ye, Alejandro, W,150293826.400.000.002071.421754.98

Generated 2024-09-20 03:01:57.427 UTC