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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Chandra, Virginia, M,2758815.230.000.000.0015.23
Butler, Hannah, R,131115707.200.000.002071.423635.78
Yang, Alan, L,1560539.970.000.000.0039.97
Martinez, Tina, J,184614748.240.003578.270.001169.97
James, Evan, V,1111985.220.000.0035.2349.99
Nath, Melvin, D,276971120.490.000.000.001120.49
Sai, Barry,229074169.330.000.002443.351725.98
Ye, Leah,110778169.030.003374.992374.982419.06
Gonzalez, Edgar, A,156483807.400.000.002071.421735.98
Mehta, Brett,114508173.260.003374.992370.222428.05
She, Lindsay,29456765.320.000.000.00765.32
Navarro, Carolyn,110698104.050.003399.992319.992384.07
Miller, Zachary, M,151692919.890.000.002071.42848.47
Muñoz, Ruben, L,114518249.490.003399.992366.942482.56
Lal, Nina, L,142635647.930.000.002049.103598.83
Lin, Wesley,2140742.280.000.0042.280.00
Zeng, Curtis, E,26669123.980.000.000.00123.98
Sanz, Arthur,27688166.280.000.00166.280.00
Gomez, Nelson, L,2905338.980.000.000.0038.98
Butler, Austin, W,1829374.240.000.0074.240.00
Anand, Rafael,293062384.070.000.000.002384.07
Wright, Miguel,2581186.450.000.0086.450.00
Jiménez, Brandi,243784173.320.000.002443.351729.97
Malhotra, Ross, R,2930714.980.000.0014.980.00
Xu, Kristen,157514446.400.000.002071.422374.98
Black, Priscilla,1576662.270.000.0034.9927.28
Rodriguez, Bobby,157524408.690.000.002071.422337.27
Rowe, Jacquelyn, I,13615146.910.000.007.95138.96
Raji, Dale,1926542.280.000.000.0042.28
Sun, Rafael,267491322.980.000.001322.980.00
Jai, Gregory,1634246.470.000.000.0046.47
Wu, Mandy,183096090.590.003578.272512.320.00
Alexander, Gail, C,14682138.450.000.000.00138.45
Hall, Jeremiah, M,182506058.210.003578.272479.940.00
Andersen, Karl, M,231053361.530.000.003361.530.00
Lin, Suzanne,292874.990.000.004.990.00
She, Brittney, M,229423971.530.000.002181.561789.97
Zhou, Rafael, A,244949.990.000.009.990.00
Hernandez, Jaime,241703018.330.000.002443.35574.98
Kumar, Rafael, L,1908824.270.000.002.2921.98
Cook, Isaac, M,139944528.750.000.002071.422457.33
Griffin, Blake, S,186995308.240.003578.271729.970.00
Johnson, Logan, K,229313882.550.000.003882.550.00
Jai, Drew, M,215624632.860.000.002181.562451.30
Washington, Abigail,236613961.030.000.002181.561779.47
Suri, Arthur,261901932.460.000.00782.991149.47
Morgan, Sara,131345648.920.000.002049.103599.82
Becker, Julie,13614114.210.000.000.00114.21
Kapoor, Cynthia,29457756.330.000.000.00756.33
She, Kristin, L,1996197.970.000.000.0097.97
Romero, Desiree, J,1723932.280.000.000.0032.28
Martin, Adrienne,1995239.460.000.0025.4813.98
Liu, Dawn, C,2196039.990.000.000.0039.99
Raman, Shane,166615908.253578.270.000.002329.98
Luo, Colleen, E,152082951.560.000.002049.10902.46
King, Evan,166375900.553578.270.000.002322.28
Sullivan, Summer, E,2118132.280.000.000.0032.28
Rana, Pedro, F,139706843.140.000.002049.104794.04
Beck, Barbara,265471407.960.000.00782.99624.97
Kumar, Jaime, O,290613.990.000.000.003.99
Blanco, Hector, J,229384173.320.000.002443.351729.97
Lin, Autumn, E,182726056.610.003578.272478.340.00
Chande, Kelli, C,229333917.540.000.002181.561735.98
Kapoor, Patricia, R,2188342.280.000.0042.280.00
Foster, Lucas,135194492.450.000.004492.450.00
Cox, Nicole, V,229503917.540.000.003917.540.00
Ramos, Danny,231214144.340.000.002443.351700.99
Serrano, Stacy,246132148.210.001000.441147.770.00
Moreno, Monique, R,231183913.820.000.002181.561732.26
Srini, Veronica,119967058.700.003374.991291.772391.94
Gonzalez, Veronica, C,233113337.040.000.003337.040.00
Zhao, Ernest, C,187005328.230.003578.271749.960.00
Pal, Dustin,265881938.470.000.00782.991155.48
Nath, Michele, L,110568207.503374.990.002413.452419.06
Hughes, Lucas, E,266571357.970.000.001357.970.00
Bradley, Diane, A,1514062.270.000.0027.2834.99
Liang, Darryl,266581390.950.000.001390.950.00
Navarro, Kristine, B,255661253.070.00699.100.00553.97
Sai, Tina, L,154253772.410.000.002071.421700.99
Subram, Ross, L,230857.280.000.000.007.28
Sanchez, Henry,2696878.980.000.000.0078.98
Guo, Jorge, L,2659069.990.000.000.0069.99
Cai, Candice,267471938.470.000.00782.991155.48
Gomez, Danny, V,166365932.743578.270.000.002354.47
Huang, Valerie, J,267451932.460.000.00782.991149.47
Carson, Kelvin, A,119958249.010.003399.990.004849.02
Perez, Henry,267521917.460.000.00782.991134.47
Carlson, Ebony,139596858.420.000.002049.104809.32
Vance, Toni, L,23438123.480.000.000.00123.48
Navarro, Monique, R,1524073.960.000.000.0073.96
Raji, Lacey, E,1634188.250.000.000.0088.25
Lu, Alan,1976167.930.000.000.0067.93
Diaz, Emma, L,1871110.240.000.000.0010.24
Sharma, Dustin, M,184846093.200.003578.272514.930.00
Serrano, Mathew, A,29186603.490.000.000.00603.49
Rivera, Nathaniel, M,140515606.910.000.003286.922319.99
Malhotra, Douglas, L,229604.990.000.000.004.99
Liang, Steve,1431781.260.000.0049.9931.27
Ramirez, Mason, K,251072143.900.000.001000.441143.46
Sanchez, Terrance,19584116.740.000.0088.9727.77
Andersen, Colin,250532183.910.000.001000.441183.47
Nara, Tonya, C,17251123.960.000.0069.9753.99
Barnes, Taylor,142795137.710.000.002049.103088.61
Zhu, Ernest,201594167.230.003578.27588.960.00
Gao, Louis,146665199.920.000.002049.103150.82
Reed, Riley, A,201574118.260.003578.27539.990.00
Mr., Rovira Diez, Pablo,2119042.280.000.0042.280.00
Lal, Franklin, A,141013679.900.000.002888.58791.32
Coleman, Brittany,1557934.980.000.0034.980.00
Patel, Jillian,266671390.950.000.001390.950.00
Gutierrez, Desiree,15216101.740.000.0027.2874.46
Sanchez, Marie,2292490.950.000.0090.950.00
Evans, Adam, H,2582048.970.000.0048.970.00
Martin, Felicia, L,15018112.460.000.00112.460.00
Lin, Darryl, J,1503141.270.000.0032.288.99
Guo, Krystal, S,17381188.930.000.00188.930.00
Sara, Phillip, R,2511639.980.000.000.0039.98
Xu, Cedric, M,24278184.480.000.000.00184.48
Scott, Timothy,196315279.260.003578.270.001700.99
Rubio, Randall, M,172866029.570.003578.270.002451.30
Luo, Ashlee,235344179.330.000.002443.351735.98
Lal, Shawna,179244733.750.003578.270.001155.48
Sharma, Terrence, N,173516117.693578.270.000.002539.42
Watson, Alexandra, H,252491868.56699.100.000.001169.46
Yang, Todd, J,190946021.620.003578.270.002443.35
Raji, Misty,165204727.743578.270.000.001149.47
Jai, Bonnie,119778212.500.003399.990.004812.51
Arun, Cory, O,165274752.753578.270.000.001174.48
Malhotra, Mayra, E,15577143.450.000.000.00143.45
Munoz, Cheryl, C,136326838.460.000.002071.424767.04
Arthur, Tabitha, E,164824783.743578.270.001205.470.00
Garcia, Andre, H,127056854.110.000.002049.104805.01
Alonso, Brandi,1706186.270.000.000.0086.27
Sai, Troy,165154733.753578.270.001155.480.00
Moreno, Jimmy, L,110296565.293399.990.000.003165.30
Ramos, Craig,14209193.970.000.004.99188.98
Thompson, Fernando,163505903.193578.270.000.002324.92
Ramos, Joe,123536765.460.002071.420.004694.04
Roberts, Jordan,234324179.330.000.002443.351735.98
Raje, Lindsay, L,206136056.610.003578.270.002478.34
Zhu, Dawn,266611912.470.000.00782.991129.48
Sai, Levi,163495898.263578.270.000.002319.99
Kumar, Misty, H,250101540.430.000.001000.44539.99
Ms., Rusek, Pearlie, J.,219454886.700.002443.350.002443.35
Diaz, Gloria,252701854.58699.100.000.001155.48
Xu, Alan,167416056.613578.270.000.002478.34
Serrano, Julio,209924139.750.003578.270.00561.48
Sharma, Sharon, T,252941882.57699.100.000.001183.47
Arthur, Kristi, W,166754385.033578.270.00806.760.00
Lal, Devon, L,1523766.260.000.000.0066.26
Zeng, Claudia, M,166964506.763578.270.00928.490.00
Guo, Randy, L,2295664.470.000.000.0064.47
Yuan, Bethany, G,110306471.323399.990.000.003071.33
Raje, Ashlee, E,166585873.263578.270.000.002294.99
Dominguez, Wendy,110356451.313374.990.000.003076.32
Ms., Schultz, Barbara, R.,1581171.160.000.000.0071.16
Powell, Jeremy,110486498.243374.990.000.003123.25
She, Keith, L,265631957.470.000.00782.991174.48
Scott, Savannah, E,169294733.753578.270.000.001155.48
Serrano, Derrick,167074377.753578.270.000.00799.48
Guo, Lacey,167446070.593578.270.002492.320.00
Lee, Dalton, J,169314767.733578.270.000.001189.46
Xu, Barbara,291952419.060.000.000.002419.06
Lu, Rosa, A,166634471.743578.270.00893.470.00
She, Cedric, R,125802589.090.002049.100.00539.99
Sanz, Kellie,167084406.743578.270.000.00828.47
Raje, Colleen, M,190846093.200.003578.270.002514.93
Xu, Colleen,2895614.980.000.000.0014.98
Chow, Amy, E,126996798.130.002049.100.004749.03
Sai, Preston, D,170464467.743578.270.000.00889.47
Ma, Dawn, A,1395682.260.000.000.0082.26
Pal, Mitchell, R,167426044.593578.270.002466.320.00
Xie, Cristina, C,170504496.233578.270.000.00917.96
Li, Stacey,140645694.210.000.002071.423622.79
Goel, Brad, M,29085777.340.000.000.00777.34
Munoz, Alfredo, C,233142744.520.000.002181.56562.96
Alexander, Gabriel, C,14073156.840.000.0038.88117.96
Romero, Paula, B,166914471.743578.270.00893.470.00
Romero, Sabrina, L,28534603.490.000.000.00603.49
Wang, Alejandro,173106029.573578.270.000.002451.30
Vazquez, Kristi,2834939.980.000.000.0039.98
Wang, Crystal, C,111128295.020.003374.990.004920.03
Arun, Ruth, S,172944355.713578.270.000.00777.44
Torres, Carolyn,1526170.740.000.000.0070.74
Torres, Meghan, I,212563917.540.002181.560.001735.98
Schmidt, Pamela, I,2437531.730.000.000.0031.73
Beck, April,143025140.730.000.002071.423069.31
Deng, Clayton, G,172856093.203578.270.000.002514.93
Foster, Maria, E,28715588.960.000.000.00588.96
Chander, Omar, W,172414382.750.003578.270.00804.48
Jimenez, Walter,172324347.760.003578.270.00769.49
Jackson, Joshua,1723583.980.000.000.0083.98
Malhotra, Geoffrey, W,1829824.270.000.000.0024.27
Prasad, Dominic, D,1996246.750.000.000.0046.75
Rai, Colleen,2893329.480.000.000.0029.48
Perry, Maria, N,177284730.030.003578.270.001151.76
Jones, Nathan,1502478.960.000.000.0078.96
Suri, Troy, M,122513924.970.003374.990.00549.98
Ross, Adam,110998215.990.003399.992363.962452.04
Saunders, Bobby, D,22205120.480.000.000.00120.48
Vazquez, Kristine, M,177364742.740.003578.270.001164.47
Sharma, Christian,1580962.590.000.0032.6029.99
Li, Aimee,179154792.730.003578.270.001214.46
Tang, Bridget,177304752.230.003578.270.001173.96
Morgan, Mackenzie, E,16162185.040.000.000.00185.04
Alexander, David,1578398.960.000.000.0098.96
Goel, Drew,173526021.620.003578.270.002443.35
Ortega, Joanna,179094761.740.003578.270.001183.47
Guo, Jaclyn,131196829.450.000.002071.424758.03
Ramos, Carolyn,179264715.700.003578.270.001137.43
Perez, Whitney,1661997.580.000.0067.5929.99
Alvarez, Roy, A,16709143.940.000.000.00143.94
Ramos, Jerome, L,29187588.960.000.000.00588.96
Pal, Drew,1190263.040.000.006.2856.76
Rai, Bradley,1910079.260.000.000.0079.26
Carson, Terrence,113565069.290.003374.990.001694.30
Sharma, Cedric, A,1406099.470.000.0049.9949.48
Evans, Jonathan, D,151854393.700.000.002071.422322.28
Navarro, Daisy,27514539.990.000.000.00539.99
Chander, Melvin, L,242662749.320.000.002181.56567.76
Ruiz, Melody,13621167.400.000.000.00167.40
Raje, Kurt,152102926.390.000.002071.42854.97
Yuan, Mitchell,267441938.470.000.00782.991155.48
Lin, Jake,242482770.520.000.002181.56588.96
Nelson, Fernando, G,255641253.070.00699.100.00553.97
Patterson, Jennifer, M,151295177.730.000.002071.423106.31
Zeng, Cara,204446085.590.003578.270.002507.32
Ortega, Latasha,242702844.510.000.002181.56662.95
Deng, Barbara,204456078.710.003578.270.002500.44
Hernandez, Mathew, A,151844441.380.000.002071.422369.96
Zhou, Jessie,206106021.620.003578.270.002443.35
Kumar, Derek, M,151354381.390.000.002071.422309.97
Carson, Shaun,111264972.370.003399.990.001572.38
Mr., Shen, Alan,242572770.520.000.002181.56588.96
Gill, Erika, A,182024143.260.003578.270.00564.99
Powell, Trevor, C,269221322.980.000.00782.99539.99
Gomez, Derrick,186946035.600.003578.272457.330.00
Suri, Patricia, E,154363772.410.000.002071.421700.99
Jai, Katrina,1304459.980.000.000.0059.98
Chen, Clayton, A,152194399.080.000.002049.102349.98
James, Mariah, M,1910430.970.000.000.0030.97
Prasad, Henry, M,243643965.520.000.002181.561783.96
Gonzalez, Kaylee, L,218954657.510.002181.560.002475.95
Martin, Beth, K,2331739.980.000.000.0039.98
Kumar, Tasha, M,202495333.250.003578.270.001754.98
Martinez, Roy, J,1396977.270.000.000.0077.27
Liu, Karen, F,1400863.970.000.0034.9928.98
Andersen, Jaime,2526860.470.000.000.0060.47
Henderson, Paige, C,1732554.940.000.000.0054.94
Fernandez, Donald, C,244623617.830.000.002443.351174.48

Generated 2024-11-10 06:09:47.352 UTC