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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Chande, Ashlee, N,230967.280.000.007.280.00
Ruiz, Marie, J,274981350.750.000.00782.99567.76
Henderson, Alexia, M,157174411.370.000.002049.102362.27
Ramos, Naomi, M,236564144.340.000.002443.351700.99
Wu, Mandy,183096090.590.003578.272512.320.00
Ms., Rousey, Linda, R.,212794.990.000.000.004.99
Sanchez, Manuel,1512686.260.000.0058.9827.28
Serrano, Jésus, B,129915641.900.002049.100.003592.80
Raman, Deanna, H,17053123.960.000.000.00123.96
Zhang, Jon,28111865.310.000.00865.310.00
Blanco, Lee, M,166605898.263578.270.000.002319.99
Arun, Gerald,259401277.560.00699.100.00578.46
Yang, Martha, G,2221035.000.000.000.0035.00
Becker, Kara,211674657.510.002181.560.002475.95
Goldstein, Brendan,135182638.360.000.002049.10589.26
Li, Wesley,233223042.820.000.002443.35599.47
Chandra, Ann,182096056.613578.270.002478.340.00
Yuan, Willie,234214208.310.000.002443.351764.96
He, Amy,224112770.520.000.002181.56588.96
Deng, Deborah,233242730.540.000.002181.56548.98
Navarro, Daisy,27514539.990.000.000.00539.99
Wang, Trisha, V,172594404.733578.270.000.00826.46
Lee, Richard, I,239962744.520.000.002181.56562.96
Yang, Connor,177354752.753578.270.000.001174.48
Xu, Kelsey, W,2822013.980.000.000.0013.98
Perez, Patricia,250221564.920.000.001000.44564.48
Romero, Raquel, Z,2291658.980.000.000.0058.98
Prasad, Preston, C,208124127.250.003578.27548.980.00
Lopez, Deanna, L,251192148.210.000.001000.441147.77
Li, Dawn, B,1396240.220.000.0040.220.00
Chen, Steve, R,189024186.230.003578.27607.960.00
Sai, Summer, S,2285570.960.000.000.0070.96
Ms., Simon, Britta,259461873.580.00699.100.001174.48
Madan, Patricia, L,229884194.330.000.002443.351750.98
Gomez, Mallory, R,248987.280.000.007.280.00
Carlson, Philip, P,119158143.000.003374.992369.962398.05
Thompson, Justin,229544179.330.000.004179.330.00
Raji, Carl,195956095.080.003578.272516.810.00
Lal, Clarence, L,2447039.980.000.0039.980.00
Blanco, Robyn, R,241793052.310.000.002443.35608.96
Xie, Brendan,130182642.380.002071.420.00570.96
Liang, Lacey, A,157194429.570.000.002049.102380.47
Beck, Alisha, E,1146347.920.000.007.9539.97
Nath, Alvin, R,29301134.980.000.00134.980.00
She, Roger, L,157244359.070.000.002049.102309.97
Suarez, Brandi,218744638.890.002181.560.002457.33
Wu, Amy,197906089.590.003578.270.002511.32
Serrano, Randall,27973539.990.000.000.00539.99
Gutierrez, Jaime, C,114578211.480.003374.992359.962476.53
Ramos, Jaime,1572070.220.000.0035.2334.99
Jai, Brad, C,1826764.980.000.0034.9929.99
Vazquez, Rebekah, A,157844379.090.000.002049.102329.99
Butler, Jose,29064815.810.000.000.00815.81
Carlson, Joanna,1559434.990.000.000.0034.99
Ramos, Victor, D,242469.990.000.009.990.00
Gonzalez, Tina,196535314.250.003578.270.001735.98
Johnston, Tamara, H,18492218.260.000.000.00218.26
Garcia, Andre, H,127056854.110.002049.100.004805.01
Weber, Chelsea,291912393.060.000.002393.060.00
Xu, Lacey, S,179134733.753578.270.000.001155.48
Travers, Alexa, A,244663337.040.000.002181.561155.48
Zheng, Omar, C,14522126.950.000.000.00126.95
Carlson, Alfredo,16178108.850.000.0038.8869.97
Pal, Donna, S,235723617.830.000.003617.830.00
Liu, Karen, F,1400863.970.000.0034.9928.98
Shen, Jodi, A,2202869.990.000.0069.990.00
Rodriguez, Wyatt, D,212184661.500.002181.560.002479.94
Munoz, Kendra, S,235293617.830.000.003617.830.00
Xie, Nina,12997118.180.000.000.00118.18
Wood, Jacqueline,1670597.960.000.000.0097.96
Sanz, Tabitha,17496110.960.000.000.00110.96
Rubio, Jay,151794444.890.000.002071.422373.47
Barnes, Alexia, D,1523159.480.000.000.0059.48
Adams, Devin,2187129.990.000.000.0029.99
Xu, Cedric, M,24278184.480.000.000.00184.48
Zheng, Edwin, J,142165653.920.000.002049.103604.82
Diaz, Briana,131316737.150.000.002049.104688.05
Rana, Evelyn, D,18262142.450.000.000.00142.45
Chande, Franklin, L,2023291.950.000.000.0091.95
Shen, Bridget,1723762.980.000.0062.980.00
Shan, Jaime,2202056.970.000.000.0056.97
Sun, Leah,177344698.763578.270.000.001120.49
Sanz, Theodore, M,1649238.980.000.000.0038.98
Chander, Andres, E,29460751.340.000.000.00751.34
Gutierrez, Dana,2025460.470.000.000.0060.47
Raje, Lindsey,246142120.930.001000.441120.490.00
Liu, Susan,187186035.600.003578.272457.330.00
Zhu, Omar,250332120.930.000.001000.441120.49
Diaz, Megan, A,243034207.320.000.002443.351763.97
Allen, Alexandra, B,172934417.753578.270.000.00839.48
Griffin, Caroline,177264721.733578.270.000.001143.46
Zimmerman, Krystal,1722877.270.000.000.0077.27
Sanchez, Michele,2354312.940.000.000.0012.94
Zhu, Gilbert,1192163.240.000.000.0063.24
Ye, Ramon,113574943.800.003374.990.001568.81
Zhang, Edwin,157854454.350.000.002071.422382.93
Lee, David, J,221994693.880.002181.560.002512.32
Gill, Melinda, G,111518087.310.003374.992319.262393.06
Suri, Stanley, J,2749642.280.000.0042.280.00
Andersen, Gilbert, T,273531371.950.000.00782.99588.96
Raje, April, R,1874432.220.000.000.0032.22
Ramos, Rebekah, L,27984561.480.000.000.00561.48
Diaz, Aaron, C,186956029.570.003578.272451.300.00
Zhu, Jamie, J,1314069.990.000.000.0069.99
Raje, Darrell,2025269.970.000.000.0069.97
Gomez, Erik, T,291802452.040.000.002452.040.00
Martinez, Kari,196096093.200.003578.270.002514.93
Malhotra, Arthur, E,2526725.480.000.0025.480.00
Beck, Barbara,265471407.960.000.00782.99624.97
Shen, Carly,2291513.980.000.000.0013.98
James, Brooke,1874578.260.000.000.0078.26
Suarez, Danny,209954127.250.003578.27548.980.00
Carlson, Audrey, A,2526360.470.000.000.0060.47
Martinez, Edgar, B,1874160.470.000.000.0060.47
Nara, Tommy,1672938.920.000.000.0038.92
Martinez, Terrance,257181274.080.00699.100.00574.98
Gao, Jorge,235733337.040.000.002181.561155.48
Romero, Marie,204244132.240.003578.27553.970.00
Xu, Kate, R,289572419.060.000.002419.060.00
West, Nathan,2437067.930.000.000.0067.93
Romero, Wendy, H,113724965.810.003374.990.001590.82
Anand, Ricardo,2138369.990.000.000.0069.99
Lin, Jake,242482770.520.000.002181.56588.96
Cooper, Katherine, R,14314122.950.000.000.00122.95
Wilson, Zachary,255581307.06699.100.000.00607.96
Gill, Dwayne, A,19675198.990.000.000.00198.99
Lewis, Justin, L,2830374.980.000.000.0074.98
Xu, Rafael, N,211954144.340.002443.350.001700.99
Rai, Clayton, K,204466029.570.003578.270.002451.30
Sanz, Cheryl, G,140465645.240.000.003340.262304.98
Lin, Suzanne,292874.990.000.004.990.00
Martin, Felicia, L,15018112.460.000.00112.460.00
Martinez, Frederick,119918128.020.003374.990.004753.03
Smith, Andre,2117442.280.000.000.0042.28
Alvarez, Reginald, A,187466135.090.003578.272556.820.00
Anderson, Victoria,157994423.380.000.002071.422351.96
Raman, Patricia, T,167026021.623578.270.002443.350.00
Wu, Laura,206156060.500.003578.270.002482.23
Romero, Latasha,142205696.190.000.002071.423624.77
Chen, Kristen, L,2200278.980.000.000.0078.98
Zheng, Barbara,274931353.460.000.00782.99570.47
Green, Sydney,23522120.470.000.00120.470.00
Rodriguez, Carla, V,212304171.620.002443.350.001728.27
Perez, Geoffrey, P,210002721.550.002181.560.00539.99
Vazquez, Randall, Z,2118635.000.000.0035.000.00
Becker, Grant,2139032.280.000.000.0032.28
Liu, Dennis,29062742.350.000.000.00742.35
Alvarez, Adrienne, L,17067113.960.000.000.00113.96
Zhou, Rafael, A,244949.990.000.009.990.00
Zhu, Candice, S,212194696.490.002181.560.002514.93
Rodriguez, Bobby,157524408.690.000.002071.422337.27
Black, Mindy, W,186966149.570.003578.272571.300.00
Malhotra, Janelle,2642569.990.000.000.0069.99
Jai, Jodi, M,2797158.980.000.000.0058.98
Sanz, Reginald, K,1752274.950.000.000.0074.95
Mehta, Evelyn, S,204204132.240.003578.27553.970.00
Xu, Cedric,181984143.250.003578.270.00564.98
Suarez, Ruben,140316964.420.000.002049.104915.32
Munoz, Audrey, V,120038256.500.003374.992399.472482.04
Suarez, Tabitha,2511039.980.000.000.0039.98
Chande, Michele, C,130786850.460.002071.420.004779.04
Fernandez, Lydia, M,145233807.400.000.002071.421735.98
Shan, Kristin,234163598.830.000.003598.830.00
Ruiz, Carolyn, M,27863565.470.000.000.00565.47
King, Maria, E,282022419.060.000.002419.060.00
Gutierrez, Ricky,197736056.610.003578.270.002478.34
Ye, Brent,2892229.480.000.000.0029.48
Yuan, Julie,229593917.540.000.002181.561735.98
Subram, Francisco, A,218974909.670.002443.350.002466.32
Munoz, Natasha, M,246013882.550.000.002181.561700.99
Lal, Terry,182776070.590.003578.270.002492.32
Johnson, Daniel,1105158.980.000.000.0058.98
Lin, Heather, L,1571863.970.000.000.0063.97
Subram, Ivan, A,2614778.980.000.000.0078.98
Alvarez, Kristy,155884486.070.000.002049.102436.97
Coleman, Ethan, G,166936060.503578.270.002482.230.00
Liu, Jaclyn,129966808.150.002049.100.004759.05
Shen, Cedric,2220974.980.000.0074.980.00
Perez, Evelyn,143463583.260.000.002071.421511.84
Zhu, Ernest,201594167.230.003578.27588.960.00
Zheng, Colleen,13026155.940.000.000.00155.94
Pal, Clayton,27721166.280.000.000.00166.28
Dominguez, Jerome, F,229873942.030.000.002181.561760.47
Zeng, Dennis, S,130505651.250.002071.420.003579.83
Hernandez, Raquel, W,139974586.350.000.002071.422514.93
Alonso, Diane, M,2063074.980.000.000.0074.98
King, Jesse, J,1466581.260.000.000.0081.26
Garcia, Tina,1723183.980.000.000.0083.98
Li, Marshall,126876805.470.002071.422349.982384.07
Washington, Sydney,289244.990.000.000.004.99
Guo, Leah, R,195625314.250.003578.270.001735.98
Stone, Mitchell,2501369.970.000.000.0069.97
Serrano, Audrey,183376021.620.003578.270.002443.35
Nelson, Mary, L,131075650.900.000.002049.103601.80
Cox, Angel, M,1879330.480.000.000.0030.48
Gill, Carolyn,2309467.930.000.0067.930.00
Jiménez, Briana, T,28118588.960.000.000.00588.96
Ma, Cara,18885110.460.000.00110.460.00
Dominguez, Diana, L,292922393.060.000.002393.060.00
Beck, Cedric, L,2240369.990.000.0069.990.00
Rana, Joe, D,119168178.510.003374.992405.472398.05
Shan, Damien, M,1136277.270.000.0027.2849.99
Malhotra, Stanley, H,114538176.980.003374.992382.932419.06
Blanco, Hector, J,229384173.320.000.002443.351729.97
Patel, Abby,160293807.400.000.002071.421735.98
Rodriguez, Sergio, D,15239123.450.000.000.00123.45
Jimenez, Melody, S,140663612.190.000.002853.57758.62
Lin, Jaclyn,2872139.980.000.000.0039.98
Chen, Aimee,265911957.470.000.00782.991174.48
Ramos, Kristine,17479163.400.000.0062.94100.46
Deng, April,111178184.993399.990.002365.942419.06
Xu, Barbara,1407459.880.000.000.0059.88
Sanders, Arianna, E,228594.990.000.000.004.99
Sanchez, Patrick, W,24382143.780.000.000.00143.78
Gill, Leslie,146702919.890.000.002071.42848.47
Chander, Karla,236484144.340.000.002443.351700.99
He, Dennis, J,278781283.820.000.000.001283.82
Shen, Katrina,158014381.380.000.002049.102332.28
Srini, Beth, A,259136.280.000.000.006.28
Gill, Lee, L,276941184.460.000.000.001184.46
Gomez, Hector, A,2933749.990.000.000.0049.99
Rana, Molly,2155474.980.000.000.0074.98
Allen, Hailey, C,26759123.980.000.000.00123.98
Kapoor, Rachael, D,1191162.460.000.000.0062.46
Lu, Warren, H,289257.280.000.000.007.28
Alonso, Sheila,25054103.480.000.000.00103.48
Madan, Summer, D,123476839.120.002049.102370.962419.06
Griffin, Brianna, K,1648773.240.000.000.0073.24
She, Bridget, M,195575358.240.003578.271779.970.00
Allen, Devin,15806102.850.000.00102.850.00
Morgan, Nathaniel, E,1662671.570.000.0036.5934.98
Becker, Julie,13614114.210.000.0086.9327.28
Lu, Rosa, A,166634471.743578.270.00893.470.00
Sai, Regina,211924229.320.002443.350.001785.97
Chen, Rosa,234353917.540.000.002181.561735.98
Huang, Jake,1958995.260.000.0062.9832.28
Hernandez, Tabitha, L,1960325.480.000.0025.480.00
Ye, Vincent,13013256.240.000.000.00256.24
Patel, Kaitlin, L,1661595.840.000.0038.8856.96
Ward, Brooke,130075671.240.002071.420.003599.82
Yang, Roger, A,28108751.340.000.00751.340.00
Raman, Frederick, F,289429.990.000.009.990.00
Prasad, Cesar,234113577.820.000.003577.820.00
Subram, Ross, L,230857.280.000.000.007.28
Srini, Cindy, E,260264.990.000.004.990.00
Pal, Sheena, D,211973917.540.002181.560.001735.98
Nara, Edwin, R,110978099.033374.990.002304.982419.06
Dominguez, Gerald, E,2063171.960.000.000.0071.96
Lopez, Virginia, J,273381339.920.000.001339.920.00
Li, Luis, K,2025159.470.000.0059.470.00

Generated 2024-09-19 22:08:54.126 UTC