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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Sanchez, Ross,283104.990.000.000.004.99
Moreno, Melody, R,11760274.920.000.00146.97127.95
Sanz, Jésus,29313539.990.000.000.00539.99
Deng, Colin, B,1829932.220.000.000.0032.22
Ruiz, Melody,13621167.400.000.000.00167.40
Gomez, Marvin, C,28479831.330.000.00831.330.00
Zhou, Arturo, F,27910574.980.000.00574.980.00
Zhao, Lacey, M,277131158.960.000.000.001158.96
Raji, Shawna, P,1396149.990.000.000.0049.99
Dominguez, Stacy, S,191056056.610.003578.272478.340.00
Rai, Melvin, J,246043681.800.000.003681.800.00
Carson, Shaun,111264972.370.003399.99793.76778.62
Sanz, Julio, H,214044684.390.002181.560.002502.83
Huang, Alejandro,114648128.510.003374.992334.462419.06
Campbell, Jason, J,136256962.140.000.002049.104913.04
Alonso, Darren,27501578.460.000.000.00578.46
Luo, Dustin,172404385.033578.270.000.00806.76
Navarro, Jonathon,187225333.250.003578.271754.980.00
Zhao, Shannon,1980735.470.000.000.0035.47
Martin, Alyssa,1958721.490.000.0021.490.00
Xu, Kathryn,2521023.780.000.000.0023.78
Serrano, Reginald, J,130252690.400.002071.420.00618.98
Huang, Dawn, E,119434734.290.003374.99539.99819.31
Nara, Yolanda,29080777.340.000.000.00777.34
Mehta, Ebony, J,228544659.900.000.002181.562478.34
Patel, Jillian,266671390.950.000.001390.950.00
Garcia, Brandy,260281938.470.00782.990.001155.48
Nath, Tommy, B,289377.280.000.000.007.28
Zhu, Suzanne, E,251122155.920.000.001000.441155.48
Pal, Arturo, P,293032419.060.000.000.002419.06
Jiménez, Brandi,243784173.320.000.002443.351729.97
She, Valerie, C,202266067.200.003578.270.002488.93
Hall, Haley,274891383.450.000.00782.99600.46
Goldberg, Mindy,161594411.650.000.002071.422340.23
Ortega, Briana, L,29346567.760.000.000.00567.76
Raji, Terry,155974391.410.000.002071.422319.99
Raman, Virginia,2615969.990.000.000.0069.99
Kapoor, Kristina,119977029.780.003399.991249.842379.95
Gao, Arturo,287142433.040.000.002433.040.00
Serrano, Stacy,246132148.210.001000.441147.770.00
Ma, Amy, E,173096030.613578.270.000.002452.34
Adams, Savannah,2353639.980.000.000.0039.98
Guo, Alisha, P,235713563.840.000.003563.840.00
Jai, Tara, E,27363132.970.000.000.00132.97
Liu, Christy,197846021.620.003578.270.002443.35
Sharma, Sharon, T,252941882.57699.100.000.001183.47
Zhang, Cara,12351117.970.000.000.00117.97
Yuan, Lacey, W,123496772.140.002049.102329.982393.06
Shen, Misty, S,2501923.970.000.000.0023.97
Ye, Willie,2296358.980.000.0058.980.00
Jimenez, Jimmy,273651371.950.000.00782.99588.96
Raman, Geoffrey, P,154353801.390.000.002071.421729.97
Nara, Dale, L,212264659.800.002181.560.002478.24
Price, Trevor, M,157254416.380.000.002071.422344.96
Tang, Leonard, L,28109778.620.000.00778.620.00
Sara, Ann, A,2357639.980.000.000.0039.98
Xu, Kristen,157514446.400.000.002071.422374.98
Liu, Karen, F,1400863.970.000.0034.9928.98
Tang, Shawn,258321850.860.00699.100.001151.76
Martin, Felicia, L,15018112.460.000.00112.460.00
Guo, Autumn, A,1421386.260.000.0058.9827.28
Suarez, Billy, M,1728795.260.000.000.0095.26
Shen, Devon, G,2735878.980.000.0078.980.00
Zeng, Ramon,279794.990.000.000.004.99
Wang, Arturo, A,2772039.980.000.0039.980.00
Raje, Carly, J,155764344.090.000.002049.102294.99
Moreno, Meghan, J,151524464.570.000.002049.102415.47
Rodriguez, Rachael, M,119444776.270.003374.99609.96791.32
Sanz, Meghan, L,28352562.960.000.000.00562.96
Carlson, Kristy,282172408.290.000.002408.290.00
Luo, Darrell, J,2118732.280.000.000.0032.28
Yuan, Darrell,18271119.950.000.008.99110.96
Vance, Toni, L,23438123.480.000.000.00123.48
Patel, Janelle, T,2911617.270.000.0017.270.00
Lopez, Clifford, E,27709628.970.000.000.00628.97
Gray, Jeremiah,233314144.340.000.002443.351700.99
Zheng, Vincent,184966121.710.003578.272543.440.00
Gomez, Victor, I,282032384.070.000.002384.070.00
Serrano, Natasha,255631239.09699.100.000.00539.99
Yuan, Warren, P,190912.290.000.000.002.29
Raji, Grant, R,1618528.980.000.003.9924.99
Perry, Madison, R,233084.990.000.000.004.99
She, Derek,150363785.080.000.002049.101735.98
Murphy, Grace, J,236554144.340.000.002443.351700.99
Prasad, George, C,157674379.090.000.002049.102329.99
Rana, Evelyn, D,18262142.450.000.000.00142.45
Suarez, Melody, H,142765259.360.000.002864.912394.45
Black, Shaun, M,1735546.470.000.000.0046.47
Cai, Amy,249202155.920.000.002155.920.00
Mehta, Patricia, K,291792393.060.000.002393.060.00
Yang, Jamie, S,184654752.750.003578.270.001174.48
Ortega, Danny, K,197946098.580.003578.270.002520.31
Saunders, Brandy,119464697.310.003399.99554.97742.35
Arun, Brenda,136306824.730.000.002071.424753.31
Rai, Karl, M,252731898.07699.100.000.001198.97
Luo, Jerry, M,245864144.340.000.002443.351700.99
Martin, Lance,2523639.980.000.000.0039.98
Griffin, Blake, S,186995308.240.003578.271729.970.00
Serrano, Darren,291962438.060.000.002438.060.00
Kumar, Jaime, O,290613.990.000.000.003.99
Li, Gilbert,239992730.540.000.002181.56548.98
Jiménez, Orlando, M,21283124.940.000.00124.940.00
Rana, Molly,2155474.980.000.000.0074.98
Smith, Adriana,187025333.250.003578.271754.980.00
Xie, Dawn,2139129.990.000.0029.990.00
Jai, Carly,229862756.540.000.002181.56574.98
Martin, Gerald, K,1728490.250.000.0031.2758.98
Ma, Lacey, K,187235279.260.003578.271700.990.00
Vazquez, Arthur,28480742.350.000.000.00742.35
Morgan, Sara,131345648.920.000.002049.103599.82
Zeng, Suzanne,179184733.753578.270.000.001155.48
Romero, Francis,221964632.860.002181.560.002451.30
Alvarez, Tabitha,150283826.400.000.002071.421754.98
Liang, Lacey, A,157194429.570.000.002049.102380.47
Bailey, Sean, L,27710563.770.000.000.00563.77
Li, Lacey,175154143.263578.270.00564.990.00
Jimenez, Marie, C,241763042.820.000.002443.35599.47
Reed, Steven,2437327.770.000.000.0027.77
Sullivan, Summer, E,2118132.280.000.000.0032.28
Mr., Smith, Leonard, J.,2797267.930.000.000.0067.93
Patel, Rachael, G,1364071.250.000.0032.2738.98
Stone, Keith,1733140.960.000.000.0040.96
Allen, Hailey, C,26759123.980.000.000.00123.98
Holt, Alisha,2835013.980.000.000.0013.98
Cook, Sydney, D,131185669.900.000.002049.103620.80
Torres, Marc,117658143.030.003374.992294.992473.05
Sara, George,242472721.550.000.002181.56539.99
Guo, Don,1874221.980.000.000.0021.98
Zhao, Kristen,169307.950.000.007.950.00
Nara, Dustin, M,179104698.763578.270.000.001120.49
Chavez, Colin,1603290.950.000.0090.950.00
Huang, Vincent, A,187035314.250.003578.271735.980.00
Ye, Amy,11073191.900.000.00103.9687.94
Romero, Gary,221814673.880.002181.560.002492.32
Rai, Brad, S,184906029.570.003578.272451.300.00
Anand, Andrés,110968063.043374.990.002294.992393.06
Vazquez, Kristine, M,177364742.743578.270.000.001164.47
Bradley, Emma,142115662.900.000.002049.103613.80
Gutierrez, Tabitha, A,2188474.980.000.000.0074.98
Gao, Jamie,260221938.470.00782.990.001155.48
Andersen, Shawna, C,195566035.600.003578.272457.330.00
Jimenez, Krista,18257115.950.000.00106.968.99
Goel, Karl,1870559.260.000.000.0059.26
Ye, Damien, M,136206848.070.000.002049.104798.97
Walker, Seth, E,27689539.990.000.000.00539.99
Sharma, Christian,1580962.590.000.0032.6029.99
Goel, Alisha, C,267671331.970.000.001331.970.00
Patel, Virginia, R,1136677.270.000.000.0077.27
Washington, Julian, C,2333031.970.000.000.0031.97
Liu, Jenny,1616581.810.000.000.0081.81
Chander, Shawn, S,202165338.740.003578.270.001760.47
Lin, Wesley,2140742.280.000.0042.280.00
Rana, Ruben,276961183.470.000.000.001183.47
Yang, Valerie, L,2736169.990.000.000.0069.99
Ruiz, Natasha,219944659.900.002181.560.002478.34
Liu, Brittney, M,1580498.960.000.000.0098.96
Browning, Javier,231204144.340.000.002443.351700.99
Anand, Katrina, L,187265314.250.003578.271735.980.00
Johnsen, Mario, W,265871920.420.000.00782.991137.43
Kovar, Mayra, J,173124471.743578.270.000.00893.47
Mehta, Abby, C,2217921.980.000.000.0021.98
Huang, Jake,1958995.260.000.0062.9832.28
Black, Shawna, C,152054433.690.000.002071.422362.27
Chande, Katrina, L,199686021.620.003578.270.002443.35
Hu, Susan,252422120.930.000.001000.441120.49
Suri, Jillian, L,151804466.390.000.002071.422394.97
Russell, Jonathan,1889674.980.000.0074.980.00
Vazquez, Janet, R,2197356.970.000.000.0056.97
Mr., Spencer, Phil,199606120.110.003578.270.002541.84
Xu, Roger,2796839.980.000.0039.980.00
Munoz, Alfredo, C,233142744.520.000.002181.56562.96
Rodriguez, Pamela,29065777.340.000.000.00777.34
Ramos, Craig,14209193.970.000.004.99188.98
Harris, Ian, W,141283836.380.000.003836.380.00
Xu, Mindy,202466035.600.003578.270.002457.33
Nath, Louis, C,258301833.570.00699.100.001134.47
Sara, Barry, R,139656872.390.000.002071.424800.97
Diaz, Devin, D,15829187.980.000.0024.99162.99
Navarro, Francis, J,2752078.980.000.000.0078.98
Nara, Melvin, E,27147123.980.000.000.00123.98
Hernandez, Wendy, A,15124122.440.000.000.00122.44
Perez, Kevin, M,255651239.090.00699.100.00539.99
Moreno, Danny, M,29458811.320.000.000.00811.32
Lin, Heather, L,1571863.970.000.000.0063.97
Gonzalez, Eric, C,1909278.260.000.000.0078.26
Parker, Gabriella,213944657.510.002181.560.002475.95
Chander, Devon,246122152.200.001000.441151.760.00
Patel, Meredith,1833327.770.000.000.0027.77
Chavez, Clayton,219494659.900.002181.560.002478.34
Raji, Sheena, J,182136070.593578.270.002492.320.00
Sai, Troy,165154733.753578.270.001155.480.00
Gutierrez, Pedro, S,1522471.920.000.0036.9334.99
Henderson, Alexia, M,157174411.370.000.002049.102362.27
Martinez, Clifford,2308739.980.000.000.0039.98
Carlson, Jill,218864696.490.002181.560.002514.93
Sun, Louis, E,1618283.970.000.000.0083.97
Gomez, Jerome, J,250572120.930.000.001000.441120.49
Ramos, Jaime,1572070.220.000.0035.2334.99
Fernandez, Ronald,2893914.980.000.0014.980.00
Madan, Carla, D,28135548.980.000.000.00548.98
Jai, Drew, M,215624632.860.002181.560.002451.30
Foster, Aidan,264451938.470.000.00782.991155.48
White, Kayla,2642479.470.000.0079.470.00
Ruiz, Alfredo,2197585.480.000.000.0085.48
Xu, Clayton, W,2500149.970.000.000.0049.97
Ms., Ryan, Justine, J.,230797.280.000.000.007.28
Serrano, Deanna, W,151444344.090.000.002049.102294.99
Zhang, Willie, T,16023166.890.000.0096.9269.97
Shan, Jenny, W,1670692.970.000.000.0092.97
Jenkins, Anna, M,1723491.260.000.000.0091.26
Shan, Carl, D,249192212.890.000.002212.890.00
Raman, Ruth, L,211994144.340.002443.350.001700.99
Sai, Molly,1468398.950.000.0073.9624.99
Suarez, Gina,2024869.970.000.000.0069.97
Cook, Kaylee,119048214.500.003399.992395.452419.06
Yang, Curtis,111108093.033399.990.002294.992398.05
Zhu, Vincent, E,24899105.450.000.00105.450.00
Moreno, Janet, L,1559259.980.000.0024.9934.99
Moreno, Kristine, K,28481778.620.000.000.00778.62
Carlson, Jose,1995474.450.000.0060.4713.98
Barnes, Alexia, D,1523159.480.000.000.0059.48
Zimmerman, Jenny,1819730.970.000.008.9921.98
Xu, Randy, S,119698173.020.003399.992319.992453.04
Munoz, Cheryl, C,136326838.460.000.002071.424767.04
Chander, Marshall,1909059.260.000.002.2956.97
Martin, Reginald,14054210.770.000.000.00210.77
Hu, Alejandro,13125138.540.000.000.00138.54
Nath, Jaime,110336495.293374.990.000.003120.30
Suarez, Dana, M,235413337.040.000.003337.040.00
Jiménez, Daisy,219444713.890.002181.560.002532.33
Moreno, Marc,130242665.060.002049.100.00615.96
Yang, Rosa,18713237.260.000.000.00237.26
Jackson, Joshua,1723583.980.000.000.0083.98
Liu, Jaclyn,129966808.150.002049.100.004759.05
Alonso, Gary, C,187675314.250.003578.271735.980.00
Martin, Ruben,224002737.820.002181.560.00556.26
Hernandez, Raquel, W,139974586.350.000.002071.422514.93
Ward, Brooke,130075671.240.002071.420.003599.82
Stone, Christine, D,259481819.590.00699.100.001120.49
Xu, Dawn,278731249.840.000.001249.840.00
Lal, Rafael, W,2894568.970.000.0068.970.00
Zhu, Omar,250332120.930.000.001000.441120.49
Vazquez, Joanna, J,119908164.010.003374.992369.962419.06
She, Eugene, L,209982806.510.002181.56624.950.00
Chande, Cassie,111038182.503374.990.002388.452419.06
Gutierrez, Ricky,197736056.610.003578.270.002478.34
Sanchez, Cynthia, S,236623917.540.000.002181.561735.98
Hayes, Alexis,13048190.230.000.000.00190.23
Green, Sydney,23522120.470.000.00120.470.00
Vazquez, Jonathon,1790621.490.000.000.0021.49

Generated 2024-09-20 01:09:39.235 UTC