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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Rai, Calvin,152292833.570.000.002049.10784.47
Suri, Shane, L,251262174.920.000.001000.441174.48
Raman, Geoffrey, P,154353801.390.000.002071.421729.97
Deng, Kate, L,157234444.070.000.002049.102394.97
Rodriguez, Arthur,154383788.680.000.002071.421717.26
Arun, Troy, P,152214447.870.000.002071.422376.45
Gill, Diane,155784509.900.000.002071.422438.48
Gao, Jon, C,114568224.460.003399.992391.432433.04
Xu, Cedric, M,24278184.480.000.000.00184.48
Sai, Ruth, D,244613302.050.000.002181.561120.49
Scott, Timothy,196315279.260.003578.270.001700.99
Gutierrez, Cheryl, O,252132184.900.000.001000.441184.46
Sun, Christy,252182184.900.000.001000.441184.46
Gonzalez, Savannah, F,156443803.680.000.002071.421732.26
Alan, Bob, A,273661322.980.000.00782.99539.99
Navarro, Mallory,243653331.030.000.002181.561149.47
Kelly, Emma, A,156463804.080.000.002049.101754.98
Wood, Richard, W,243773945.530.000.002181.561763.97
Davis, Morgan, J,273591344.470.000.00782.99561.48
Liang, Lacey, A,157194429.570.000.002049.102380.47
Wu, Marshall, J,155904440.050.000.002049.102390.95
Sara, Ross,243674179.330.000.002443.351735.98
Lopez, Mayra, E,273561336.960.000.00782.99553.97
Sara, Tina,243074158.320.000.002443.351714.97
Anand, Chad,244843563.840.000.002443.351120.49
Rubio, Randall, M,172866029.570.003578.270.002451.30
Bailey, Allison,2137769.990.000.000.0069.99
Lal, Devon, L,1523766.260.000.000.0066.26
Rubio, Larry,14223155.940.000.000.00155.94
Navarro, Carolyn,110698104.050.003399.992319.992384.07
Carson, Terrence,113565069.290.003374.990.001694.30
Mr., Schmidt, Steve,157894486.070.000.002049.102436.97
Zhou, Ernest, P,157922645.400.000.002071.42573.98
Jenkins, Joan,161554489.570.000.002049.102440.47
Dominguez, Lee, R,245974009.500.000.002181.561827.94
Navarro, Eddie, C,245043563.840.000.002443.351120.49
Hu, Susan,252422120.930.000.001000.441120.49
Sharma, Lindsay, E,244783337.040.000.002181.561155.48
Deng, Jodi,161612700.050.000.002049.10650.95
Zhou, Autumn, L,252292155.920.000.001000.441155.48
Hernandez, Danny,2714674.980.000.000.0074.98
Gonzalez, Tina,196535314.250.003578.270.001735.98
She, Valerie, C,202266067.200.003578.270.002488.93
Wang, Alejandro,173106029.573578.270.000.002451.30
Muñoz, Ruben, L,114518249.490.003399.992366.942482.56
Flores, Miranda,1724383.980.000.0053.9929.99
Sharma, Terrence, N,173516117.693578.270.000.002539.42
Alonso, Brandi,1706186.270.000.000.0086.27
Navarro, Monique, R,1524073.960.000.000.0073.96
Raje, Lindsay, L,206136056.610.003578.270.002478.34
Lal, Shawna,179244733.750.003578.270.001155.48
Yang, Todd, J,190946021.620.003578.270.002443.35
Watson, Alexandra, H,252491868.56699.100.000.001169.46
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
Sanchez, Terrance,19584116.740.000.0088.9727.77
Liang, Kelvin, L,166165915.543578.270.000.002337.27
Arthur, Tabitha, E,164824783.743578.270.001205.470.00
Sai, Troy,165154733.753578.270.001155.480.00
Ms., Schultz, Barbara, R.,1581171.160.000.000.0071.16
Moreno, Jimmy, L,110296565.293399.990.000.003165.30
Ramos, Craig,14209193.970.000.004.99188.98
Gomez, Danny, V,166365932.743578.270.000.002354.47
Ramos, Joe,123536765.460.002071.420.004694.04
Xu, Colleen,2895614.980.000.000.0014.98
Goel, Brad, M,29085777.340.000.000.00777.34
Raman, Shane,166615908.253578.270.000.002329.98
Romero, Sabrina, L,28534603.490.000.000.00603.49
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
Romero, Lawrence, C,166876070.593578.270.002492.320.00
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
Dominguez, Wendy,110356451.313374.990.000.003076.32
Martin, Marc, J,110396636.583399.990.000.003236.59
Perez, Joel,166844158.243578.270.000.00579.97
Foster, Maria, E,28715588.960.000.000.00588.96
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
Jackson, Joshua,1723583.980.000.000.0083.98
She, Cedric, R,125802589.090.002049.100.00539.99
Lu, Rosa, A,166634471.743578.270.00893.470.00
Sanz, Kellie,167084406.743578.270.000.00828.47
Raje, Colleen, M,190846093.200.003578.270.002514.93
Malhotra, Geoffrey, W,1829824.270.000.000.0024.27
Prasad, Dominic, D,1996246.750.000.000.0046.75
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
King, Evan,166375900.553578.270.000.002322.28
Alexander, Gabriel, C,14073156.840.000.0038.88117.96
Suri, Troy, M,122513924.970.003374.990.00549.98
Romero, Paula, B,166914471.743578.270.00893.470.00
Vazquez, Kristi,2834939.980.000.000.0039.98
Saunders, Bobby, D,22205120.480.000.000.00120.48
Sharma, Christian,1580962.590.000.0032.6029.99
Arun, Ruth, S,172944355.713578.270.000.00777.44
Morgan, Mackenzie, E,16162185.040.000.000.00185.04
Torres, Meghan, I,212563917.540.002181.560.001735.98
Deng, Clayton, G,172856093.203578.270.000.002514.93
Kumar, Robert,252262158.900.000.001000.441158.46
Chander, Omar, W,172414382.750.003578.270.00804.48
Perez, Whitney,1661997.580.000.0067.5929.99
Jimenez, Walter,172324347.760.003578.270.00769.49
Alvarez, Roy, A,16709143.940.000.000.00143.94
Rai, Colleen,2893329.480.000.000.0029.48
Perry, Maria, N,177284730.030.003578.270.001151.76
He, Aimee, A,110938180.000.003399.992360.952419.06
Ross, Adam,110998215.990.003399.992363.962452.04
Vazquez, Kristine, M,177364742.740.003578.270.001164.47
Miller, Edward,113685106.240.003374.990.001731.25
Chander, Damien,110808204.020.003374.992359.982469.05
Navarro, Daisy,27514539.990.000.000.00539.99
Li, Aimee,179154792.730.003578.270.001214.46
Tang, Bridget,177304752.230.003578.270.001173.96
Rowe, Jacquelyn, I,13615146.910.000.007.95138.96
Ruiz, Melody,13621167.400.000.000.00167.40
Alexander, David,1578398.960.000.000.0098.96
Ye, Leah,110778169.030.003374.992374.982419.06
Zeng, Cara,204446085.590.003578.270.002507.32
Goel, Drew,173526021.620.003578.270.002443.35
Suri, Cesar,175124170.540.003578.27592.270.00
Williams, Anna, R,175044362.740.003578.270.00784.47
Deng, Barbara,204456078.710.003578.270.002500.44
Ortega, Joanna,179094761.740.003578.270.001183.47
Zhou, Jessie,206106021.620.003578.270.002443.35
Ramos, Carolyn,179264715.700.003578.270.001137.43
Ramos, Jerome, L,29187588.960.000.000.00588.96
Alvarez, Kari, C,111088124.040.003374.992329.992419.06
Sara, Edgar, A,111048173.030.003399.992334.982438.06
Hall, Jeremiah, M,182506058.210.003578.272479.940.00
Jordan, Ross, F,111248129.020.003399.992309.972419.06
Harris, Eduardo, S,182386030.610.003578.272452.340.00
Jai, Katrina,1304459.980.000.000.0059.98
James, Mariah, M,1910430.970.000.000.0030.97
Deng, April,111178184.990.003399.992365.942419.06
Alonso, Danny, S,182176056.610.003578.272478.340.00
Lin, Autumn, E,182726056.610.003578.272478.340.00
Kumar, Tasha, M,202495333.250.003578.270.001754.98
Sharma, Cedric, A,1406099.470.000.0049.9949.48
Powell, Thomas, R,182186021.620.003578.272443.350.00
Liu, Karen, F,1400863.970.000.0034.9928.98
Suarez, Carolyn, B,182226044.590.003578.272466.320.00
Nelson, Fernando, G,255641253.070.00699.100.00553.97
Liu, Jessie,111068079.050.003399.992294.992384.07
Chande, Lindsay,182446021.620.003578.272443.350.00
Torres, Wendy, A,182696113.200.003578.270.002534.93
Wang, Crystal, C,111128295.020.003374.990.004920.03
Carson, Shaun,111264972.370.003399.990.001572.38
Gill, Erika, A,182024143.260.003578.270.00564.99
Suarez, Tabitha,2511039.980.000.000.0039.98
Gomez, Derrick,186946035.600.003578.272457.330.00
Wu, Mandy,183096090.590.003578.272512.320.00
Kapoor, Veronica, G,202536035.600.003578.270.002457.33
Lopez, Sergio, L,1512381.260.000.000.0081.26
Chandra, Harold, K,1723686.270.000.000.0086.27
Henderson, Paige, C,1732554.940.000.000.0054.94
Carlson, Marc, W,17501141.980.000.000.00141.98
Lopez, Chelsea,243694.990.000.000.004.99
Dominguez, Philip,15730122.960.000.000.00122.96
Bradley, Diane, A,1514062.270.000.0027.2834.99
Torres, Carolyn,1526170.740.000.000.0070.74
Kapoor, Summer,28353548.980.000.000.00548.98
Fernandez, Nancy,1485472.960.000.000.0072.96
Mehta, Edgar,117618149.490.003399.992356.442393.06
Sanz, Diane, M,2015313.980.000.000.0013.98
Lu, Susan, C,1235793.450.000.000.0093.45
Martin, Max, A,1603037.270.000.000.0037.27
Chander, Cassie, M,1825845.950.000.000.0045.95
Ye, Edwin,183344698.760.003578.270.001120.49
Andersen, Nina,183386124.580.003578.270.002546.31
Sharma, Dustin, M,184846093.200.003578.272514.930.00
Phillips, Jeremy, E,184956021.620.003578.272443.350.00
Subram, Ann, M,186936021.620.003578.272443.350.00
Zhao, Ernest, C,187005328.230.003578.271749.960.00
Li, Trisha, A,182966117.690.003578.272539.420.00
Martinez, Tina, J,184614748.240.003578.270.001169.97
Madan, Francisco, S,257061239.090.00699.100.00539.99
Murphy, Alexa,182766106.600.003578.270.002528.33
Gill, Diana,257101239.090.00699.100.00539.99
Rubio, Robyn, A,184696021.620.003578.272443.350.00
Griffin, Blake, S,186995308.240.003578.271729.970.00
Gonzalez, Devin,184856063.210.003578.272484.940.00
Gutierrez, Desiree,15216101.740.000.0027.2874.46
Schmidt, Pamela, I,2437531.730.000.000.0031.73
Jones, Nathan,1502478.960.000.000.0078.96
Munoz, Shannon, S,2912249.970.000.000.0049.97
Rivera, Mariah,202615314.250.003578.270.001735.98
Ma, Laura, L,245033617.830.000.002443.351174.48
Raje, Bonnie,206296060.500.003578.270.002482.23
Malhotra, Joel, E,1634358.250.000.000.0058.25
Oliver, Lee,2911969.970.000.000.0069.97
Arun, Nancy, C,211694647.880.002181.560.002466.32
She, Nichole, M,119098105.310.003374.990.004730.32
Carlson, Theresa, L,19629109.440.000.000.00109.44
Gutierrez, Orlando,259201819.590.00699.100.001120.49
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
Gutierrez, Adrienne,189064217.220.003578.27638.950.00
Gill, Latasha, M,257131288.060.00699.100.00588.96
Navarro, Jonathon,187225333.250.003578.271754.980.00
Campbell, Seth,187166021.620.003578.272443.350.00
Gutierrez, Darren, A,257141308.060.00699.100.00608.96
Luo, Mario, L,257111274.080.00699.100.00574.98
Nara, Priscilla,189074167.230.003578.27588.960.00
Chande, Melvin, R,114608137.520.003399.992294.992442.54
Fernandez, Denise, A,187246056.510.003578.272478.240.00
Subram, Stefanie,12371214.040.000.000.00214.04
Perez, Cesar, L,27982603.490.000.000.00603.49
Srini, Veronica,119967058.700.003374.991291.772391.94
Johnston, Tamara, H,18492218.260.000.000.00218.26
Jai, Clayton,123396865.460.002071.420.004794.04
Lin, Claudia, A,14312191.270.000.00166.2824.99
Suri, Barry,1525378.960.000.000.0078.96
Vance, Denise, L,212054886.700.002443.350.002443.35
Patterson, Ashley, R,187366035.600.003578.270.002457.33
Hernandez, Darren, A,187096098.540.003578.270.002520.27
Shen, Shawn,192704127.250.003578.27548.980.00
Liu, Suzanne,195946021.620.003578.270.002443.35
Xie, Jaime,258231887.560.00699.100.001188.46
Shan, Brad, H,196055314.250.003578.270.001735.98
Raji, Carl,195956095.080.003578.270.002516.81
Moreno, Robin,195635333.250.003578.270.001754.98
Sun, Franklin,196155279.260.003578.270.001700.99
Green, Sydney,23522120.470.000.000.00120.47
Gao, Rafael, R,1873324.270.000.002.2921.98
Lu, Tiffany,2284348.980.000.000.0048.98
Griffin, Noah, E,2911873.960.000.000.0073.96
Moore, Sarah,289389.990.000.000.009.99
Chande, Tracy, J,125882639.080.002049.100.00589.98
Sanz, Orlando,1430999.470.000.0074.4824.99
Serrano, Marvin, E,1731697.450.000.000.0097.45
Carson, Kelvin, A,119958249.010.003399.990.004849.02
Alonso, Meredith, M,206216117.690.003578.270.002539.42
Subram, Kristi, N,15025128.940.000.000.00128.94
Stewart, Margaret, C,29096574.980.000.000.00574.98
Moreno, Roy, J,199516021.620.003578.270.002443.35
Shan, Derek, R,197826089.590.003578.270.002511.32
Kumar, Rafael, L,1908824.270.000.002.2921.98
Zhou, Warren,197916058.210.003578.270.002479.94

Generated 2024-11-10 05:32:15.892 UTC