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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Ortega, Dwayne, C,246152155.920.000.002155.920.00
Suarez, Renee, L,127036891.120.000.002049.104842.02
Nara, Tommy,1672938.920.000.000.0038.92
Liu, Lacey, L,235453882.550.000.002181.561700.99
Sara, Donald, M,251142155.920.000.001000.441155.48
Sanz, Cheryl, G,140465645.240.000.003340.262304.98
Pais, Wilson, C,130385581.260.000.002071.423509.84
Liang, Louis, M,127066851.410.000.002071.424779.99
Moreno, Felicia, A,129876759.470.000.002071.424688.05
Gutierrez, Gary, C,127016868.440.000.002071.424797.02
Hernandez, Leslie, D,129906829.470.000.002071.424758.05
Hu, Krystal, D,130127017.440.000.002071.424946.02
Liu, Jaclyn,129966808.150.000.002049.104759.05
Zhang, Clarence, M,130016799.430.000.002049.104750.33
Rana, Whitney, A,130066762.150.000.002049.104713.05
Sara, Geoffrey,261881938.470.000.00782.991155.48
Martinez, Anna, J,129946855.440.000.002071.424784.02
Ye, Erica, E,130105716.520.000.002071.423645.10
Blanco, Orlando,225753018.330.000.002443.35574.98
Yuan, Grant, C,249092149.910.000.001000.441149.47
Nath, Alvin, R,29301134.980.000.000.00134.98
Vazquez, Jerome,231163936.540.000.002181.561754.98
Dominguez, Roy, C,2918923.970.000.000.0023.97
Rubio, Juan,1617032.280.000.000.0032.28
Holt, Alisha,2835013.980.000.000.0013.98
Shen, Rafael, J,16689290.460.000.000.00290.46
Long, Alexis,225803051.310.000.002443.35607.96
Madan, Evelyn, D,225822756.540.000.002181.56574.98
Shan, Clarence,224082770.520.000.002181.56588.96
Lal, Kara,225792730.540.000.002181.56548.98
Fernandez, Arthur, J,223992785.050.000.002181.56603.49
He, Amy,224112770.520.000.002181.56588.96
Xu, Margaret, T,224042983.340.000.002443.35539.99
Gill, Carolyn,2309467.930.000.000.0067.93
Gomez, Erik, T,291802452.040.000.000.002452.04
Munoz, Monique,240082730.540.000.002181.56548.98
Ma, Omar, I,1523239.970.000.000.0039.97
Sharma, Andres, C,2423013.980.000.000.0013.98
McDonald, Brent,1406877.270.000.000.0077.27
Andersen, Karl, M,231053361.530.000.003361.530.00
Gomez, Arthur,249172179.910.000.001000.441179.47
Cai, Amy,249202155.920.000.001000.441155.48
Johnson, Logan, K,229313882.550.000.003882.550.00
Shan, Carl, D,249192212.890.000.001000.441212.45
Raje, Wayne, A,2137274.960.000.000.0074.96
Luo, Roger, J,1872856.710.000.000.0056.71
Suri, Stanley, J,2749642.280.000.000.0042.28
Gutierrez, Micheal, S,272991322.980.000.00782.99539.99
Zhou, Brent,1543432.280.000.000.0032.28
Pal, Kara,249162169.900.000.001000.441169.46
Foster, Lucas,135194492.450.000.004492.450.00
Ramos, Danny,231214144.340.000.002443.351700.99
Moreno, Monique, R,231183913.820.000.002181.561732.26
Gonzalez, Veronica, C,233113337.040.000.003337.040.00
Malhotra, Tina, C,27584599.470.000.000.00599.47
Hughes, Lucas, E,266571357.970.000.001357.970.00
Deng, Deborah,233242730.540.000.002181.56548.98
Liang, Darryl,266581390.950.000.001390.950.00
Ortega, Max,234133617.830.000.003617.830.00
Rana, Molly,2155474.980.000.000.0074.98
Torres, Monique,252352155.920.000.001000.441155.48
Guo, Margaret,234314158.320.000.002443.351714.97
Lin, Mandy, C,250352183.910.000.001000.441183.47
Cook, Isaac, M,139944528.750.000.002071.422457.33
She, Stacey,267481357.970.000.001357.970.00
Raman, Cassandra,2871867.970.000.000.0067.97
Ruiz, Naomi,236493945.530.000.002181.561763.97
Diaz, Devin, D,15829187.980.000.000.00187.98
Raje, Jenny,2023369.970.000.000.0069.97
Xu, Kara, E,2221239.990.000.000.0039.99
Vance, George, R,1203866.760.000.000.0066.76
Dominguez, Leslie,273461390.950.000.00782.99607.96
Cai, Candice,267471938.470.000.00782.991155.48
Kumar, Jenny, C,234293936.540.000.002181.561754.98
Alexander, Austin,266731505.760.000.001505.760.00
Huang, Valerie, J,267451932.460.000.00782.991149.47
Perez, Henry,267521917.460.000.00782.991134.47
Huang, Wesley,2932023.970.000.000.0023.97
Ramirez, Mason, K,251072143.900.000.001000.441143.46
Andersen, Colin,250532183.910.000.001000.441183.47
Barnes, Taylor,142795137.710.000.002049.103088.61
Weber, Deanna, L,148553759.080.000.002049.101709.98
Gao, Louis,146665199.920.000.002049.103150.82
Tang, Colin,143235222.020.000.002071.423150.60
Flores, Antonio, D,142593630.930.000.002888.58742.35
Allen, Devin,15806102.850.000.0038.8863.97
Perez, Stefanie,27518123.980.000.000.00123.98
Xu, Wesley, K,29182539.990.000.000.00539.99
Gill, Gina, F,241772721.550.000.002181.56539.99
Martinez, Harold, J,2060493.490.000.000.0093.49
Washington, Abigail,236613961.030.000.002181.561779.47
Li, Crystal, L,143255152.700.000.002049.103103.60
Evans, Jonathan, D,151854393.700.000.002071.422322.28
Miller, Zachary, M,151692919.890.000.002071.42848.47
Chander, Melvin, L,242662749.320.000.002181.56567.76
Raje, Kurt,152102926.390.000.002071.42854.97
Lopez, Deanna, L,251192148.210.000.001000.441147.77
Liu, Randy,150153804.080.000.002049.101754.98
Moreno, Meghan, J,151524464.570.000.002049.102415.47
Zhu, Lacey,241672983.340.000.002443.35539.99
Luo, Colleen, E,152082951.560.000.002049.10902.46
Lin, Jake,242482770.520.000.002181.56588.96
Rubio, Jay,151794444.890.000.002071.422373.47
Hernandez, Jaime,241703018.330.000.002443.35574.98
Sanz, Monique, R,242732721.550.000.002181.56539.99
Ortega, Latasha,242702844.510.000.002181.56662.95
Alonso, Renee,241662789.520.000.002181.56607.96
Hernandez, Jessie, A,241722735.530.000.002181.56553.97
Hernandez, Mathew, A,151844441.380.000.002071.422369.96
Kumar, Derek, M,151354381.390.000.002071.422309.97
Gutierrez, Carrie, C,28139127.280.000.000.00127.28
Gonzalez, Marco,27598556.260.000.000.00556.26
Lopez, Isaac,27692603.490.000.000.00603.49
Carlson, Tanya,1618331.270.000.000.0031.27
Alonso, Lance, I,1405764.970.000.000.0064.97
Mr., Shen, Alan,242572770.520.000.002181.56588.96
Suri, Patricia, E,154363772.410.000.002071.421700.99
Srini, Carolyn, S,273711350.750.000.00782.99567.76
Gonzalez, Natalie,252152155.920.000.001000.441155.48
Deng, Priscilla, M,251272174.920.000.001000.441174.48
Chen, Clayton, A,152194399.080.000.002049.102349.98
Suarez, Nelson,273551383.450.000.00782.99600.46
Bell, Stephanie, A,273701322.980.000.00782.99539.99
Goel, Marshall, M,27691603.490.000.000.00603.49
Clark, Joshua, A,2613769.990.000.000.0069.99
Perez, Edgar, B,293182384.070.000.000.002384.07
Gomez, Jill,29315103.960.000.000.00103.96
Ruiz, Kari, L,12695192.970.000.000.00192.97
Beck, Derek,1732285.480.000.000.0085.48
Ramos, Meredith, A,2330767.930.000.000.0067.93
Arun, Barry,2770039.980.000.000.0039.98
Romero, Dwayne,28314553.970.000.000.00553.97
Sai, Tina, L,154253772.410.000.002071.421700.99
Fernandez, Donald, C,244623617.830.000.002443.351174.48
Raji, Terry,155974391.410.000.002071.422319.99
Jimenez, Jimmy,273651371.950.000.00782.99588.96
Jimenez, Teresa, L,243723356.040.000.002181.561174.48
Moreno, Naomi, C,156014429.570.000.002049.102380.47
Raje, Carly, J,155764344.090.000.002049.102294.99
Serrano, Beth,243043946.520.000.002181.561764.96
Suri, Marie,242813302.050.000.002181.561120.49
Zheng, Aimee, H,242833946.520.000.002181.561764.96
Andersen, Tara, L,244653356.040.000.002181.561174.48
Chander, Andres, E,29460751.340.000.000.00751.34
Kumar, Barbara, N,274991331.970.000.00782.99548.98
Blanco, Lori, A,15735116.250.000.000.00116.25
Moore, Olivia, A,252312189.900.000.001000.441189.46
Xu, Colin,157902668.380.000.002668.380.00
Arun, Denise,2821818.970.000.000.0018.97
Sai, Terrance,1910664.950.000.0021.9842.97
Zheng, Omar, C,14522126.950.000.000.00126.95
She, Lindsay,29456765.320.000.000.00765.32
Yuan, Kelsey, D,1303494.710.000.000.0094.71
Davis, Seth, A,163393169.590.000.003169.590.00
Rai, Melvin, J,246043681.800.000.003681.800.00
Raje, Kelli, A,281362384.070.000.002384.070.00
Kapoor, Cynthia,29457756.330.000.000.00756.33
Zeng, Curtis, E,26669123.980.000.000.00123.98
Romero, Desiree, J,1723932.280.000.000.0032.28
Liu, Dawn, C,2196039.990.000.000.0039.99
Black, Shaun, M,1735546.470.000.000.0046.47
Gomez, Nelson, L,2905338.980.000.000.0038.98
Sullivan, Summer, E,2118132.280.000.000.0032.28
Anand, Rafael,293062384.070.000.000.002384.07
Sanz, Gerald, J,17060123.960.000.000.00123.96
Morgan, Nathaniel, E,1662671.570.000.0036.5934.98
Moreno, Kristine, K,28481778.620.000.000.00778.62
Sanz, Hector,2734469.990.000.000.0069.99
She, Marshall, D,18707122.760.000.00120.472.29
Sanchez, Henry,2696878.980.000.000.0078.98
Vance, Toni, L,23438123.480.000.000.00123.48
Raji, Lacey, E,1634188.250.000.000.0088.25
Diaz, Emma, L,1871110.240.000.000.0010.24
Serrano, Mathew, A,29186603.490.000.000.00603.49
Malhotra, Douglas, L,229604.990.000.000.004.99
Raje, Jodi, E,1963074.450.000.000.0074.45
Ruiz, Adrienne,1352367.260.000.000.0067.26
Pal, Arturo, P,293032419.060.000.000.002419.06
Alvarez, Mathew, L,17494111.960.000.000.00111.96
Li, Vincent, D,21207123.960.000.000.00123.96
Xu, Grant, M,1926642.280.000.000.0042.28
Pal, Tasha,2285339.990.000.000.0039.99
Rodriguez, Tammy,1523359.980.000.000.0059.98
Becker, Latoya, W,1733030.970.000.000.0030.97
Zimmerman, Jenny,1819730.970.000.008.9921.98
Gill, Meredith, E,2426849.970.000.000.0049.97
Madan, Joe,293002419.060.000.000.002419.06
She, Mandy, K,2197240.230.000.000.0040.23
Luo, Warren,235624.990.000.000.004.99
Martin, Beth, K,2331739.980.000.000.0039.98
Xie, Michele, M,1503978.960.000.000.0078.96
Andersen, Jaime,2526860.470.000.000.0060.47
Sanchez, Clifford,21188123.960.000.000.00123.96
Ma, Jessie,290926.280.000.000.006.28
Luo, Alison, A,2352756.970.000.000.0056.97
Sai, Monica, L,29055765.320.000.000.00765.32
Gutierrez, Frank, G,2284674.980.000.0074.980.00
Guo, Jake, P,1996998.450.000.0067.9730.48
Ward, Shelby,2613239.980.000.0039.980.00
Yang, Hunter, E,2023721.490.000.0021.490.00
Jai, Nichole, R,2834868.490.000.000.0068.49
Gray, Brooke, P,2675678.980.000.000.0078.98
Sanz, Paula,2643069.990.000.000.0069.99
Martin, Lance,2523639.980.000.000.0039.98
Suarez, Melinda,29181553.970.000.000.00553.97
Xu, Lindsey,1558366.260.000.000.0066.26
Liang, Ronnie,2458430.480.000.000.0030.48
Subram, Roy,2189674.980.000.000.0074.98
White, Ashley, D,2188739.990.000.0039.990.00
Luo, Barbara,2797829.480.000.0029.480.00
Mehta, Brandy,2283939.250.000.0039.250.00
Ferrier, Leslie, M,285352433.040.000.002433.040.00
Butler, Destiny,278652419.060.000.000.002419.06
Liang, Alan, L,29063801.830.000.000.00801.83
Xu, Brad,2615769.990.000.000.0069.99
Zhu, Colleen,1725292.970.000.000.0092.97
Jai, Carl,27597564.210.000.000.00564.21
Huang, Tamara, E,1405386.260.000.0086.260.00
Carlson, Jose,1995474.450.000.0060.4713.98
Zhu, Jorge,2614178.980.000.0078.980.00
Ma, Cara,18885110.460.000.00110.460.00
Rubio, Jessie, J,278682419.060.000.000.002419.06
King, Hailey, A,2821459.980.000.000.0059.98
Li, Colin, J,1844521.490.000.000.0021.49
Martin, Jay,1959733.980.000.000.0033.98
Sun, Todd,2201876.970.000.000.0076.97
Sanz, Jimmy,25810114.460.000.000.00114.46
Chander, Brad, K,2138269.990.000.0069.990.00
Nelson, Natalie, C,2292858.980.000.000.0058.98
Rodriguez, Pamela,29065777.340.000.000.00777.34
Subram, Rebekah,2603021.490.000.000.0021.49
Lin, Karen,2424348.970.000.000.0048.97
Alonso, Raquel,1731351.920.000.000.0051.92
Jiménez, Darren, W,28931166.280.000.000.00166.28
Gill, Billy, L,1670092.970.000.000.0092.97
Guo, Susan, A,2654314.230.000.0014.230.00
Powell, Aaron,252414.990.000.000.004.99
Hill, Jennifer,1829130.970.000.000.0030.97
Blanco, Brandi, L,209867.280.000.000.007.28
She, Ashlee,28319556.930.000.000.00556.93
Navarro, Meredith,277034.990.000.000.004.99
Zhu, Damien, M,1582243.210.000.000.0043.21
Carlson, Lawrence, L,2206469.990.000.0069.990.00
Lee, Austin,2615169.990.000.000.0069.99
Lopez, Patricia,2830529.480.000.000.0029.48
Chavez, Karla, K,1670491.260.000.000.0091.26
Wu, Arturo, A,28321599.470.000.000.00599.47
Gill, Gerald, A,28487805.330.000.000.00805.33
Ramos, Albert, E,277167.280.000.000.007.28
Martinez, Fernando,2045423.780.000.000.0023.78

Generated 2024-11-10 08:55:06.362 UTC