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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Xu, Cara,235263563.840.000.002443.351120.49
Alvarez, Lori, C,266621938.470.000.00782.991155.48
Suarez, Dana, M,235413337.040.000.002181.561155.48
Martinez, Brett,235323337.040.000.003337.040.00
Sharma, Edwin, K,250211554.410.000.001000.44553.97
Yang, Ronnie,235243598.830.000.003598.830.00
Zheng, Edwin, J,142165653.920.000.002049.103604.82
Hernandez, Raquel, W,139974586.350.000.002071.422514.93
Sanz, Cheryl, G,140465645.240.000.003340.262304.98
Navarro, Javier,141313807.400.000.002071.421735.98
Foster, Madison,140386819.120.000.002049.104770.02
Cook, Isaac, M,139944528.750.000.002071.422457.33
Nath, Rafael,235333917.540.000.002181.561735.98
Kelly, Emma, A,156463804.080.000.002049.101754.98
Rodriguez, Ruben,125892665.060.002049.100.00615.96
Flores, Adam, L,110446515.303374.990.000.003140.31
Dominguez, Jimmy,219594702.390.002181.560.002520.83
Yuan, Calvin,1790525.480.000.000.0025.48
Mehta, Cassandra,2301413.980.000.000.0013.98
Mrs., Nara, Barbara,12704217.460.000.000.00217.46
Goel, Karla, L,11146112.930.000.0053.9558.98
Xu, Calvin, E,27583553.970.000.000.00553.97
Wang, Jeffery, E,181886093.200.003578.270.002514.93
Jimenez, Jaime, E,29095777.340.000.000.00777.34
Sun, Lacey, L,1513181.260.000.000.0081.26
Zhang, Willie, T,16023166.890.000.000.00166.89
Alvarez, Marc, B,1822145.950.000.000.0045.95
Ramos, Kristine,17479163.400.000.000.00163.40
Wu, Lisa,2615894.480.000.000.0094.48
Dominguez, Joy,221753018.330.000.002443.35574.98
Pal, Alvin, C,293192447.050.000.000.002447.05
Muñoz, Pedro, A,234333882.550.000.002181.561700.99
Perez, Patricia,250221564.920.000.001000.44564.48
Ye, Christy,142195744.220.000.002071.423672.80
Mr., Sands, Patrick,140635676.250.000.003321.262354.99
Ross, Brandon,141323804.080.000.002049.101754.98
Martin, Justin,235423337.040.000.002181.561155.48
Serrano, Joanna, J,266631976.940.000.00782.991193.95
Gonzalez, Shane, Y,141253772.410.000.003772.410.00
Chen, Rosa,234353917.540.000.002181.561735.98
Romero, Jessie,250302180.410.000.001000.441179.97
Luo, Ashlee,235344179.330.000.002443.351735.98
Beck, Ashlee, L,266661336.960.000.001336.960.00
Lopez, Donald, A,267401938.470.000.00782.991155.48
Raje, Misty, A,235443971.010.000.002181.561789.45
Kumar, Warren, A,240032806.530.000.002181.56624.97
Yuan, Tamara, E,211664909.670.002443.350.002466.32
Li, Ramon,2124834.980.000.000.0034.98
Wood, Jacqueline,1670597.960.000.000.0097.96
Suarez, Jerome, L,206226139.590.003578.270.002561.32
Ramirez, Mason, K,251072143.900.000.001000.441143.46
Murphy, Grace, J,236554144.340.000.002443.351700.99
Perez, Joe, A,143265207.700.000.002071.423136.28
Martin, Joe,146685216.690.000.002071.423145.27
Coleman, Luis, L,142305661.900.000.002049.103612.80
Ruiz, Frank, M,142603716.230.000.002964.89751.34
Suarez, Melody, H,142765259.360.000.002049.103210.26
Deng, Peter, A,240062721.550.000.002181.56539.99
Xie, Derek,142875141.430.000.002049.103092.33
Munoz, Monique,240082730.540.000.002181.56548.98
Rai, Terrence, R,250372174.920.000.001000.441174.48
Guo, Sandra,236643941.530.000.002181.561759.97
Prasad, Tabitha, D,267611938.470.000.00782.991155.48
Zeng, Jon, O,143105200.660.000.002071.423129.24
Raman, Brandy,1224777.270.000.0049.9927.28
Foster, Luke,15137161.940.000.0097.9763.97
Hall, Mary, R,202774.990.000.000.004.99
Xu, Kara, E,2221239.990.000.000.0039.99
Xie, Drew, A,20218104.690.000.000.00104.69
Yang, Jon, V,110008248.993399.990.002341.972507.03
Kovar, Tabitha,158332611.410.000.002071.42539.99
Dominguez, Leslie,273461390.950.000.00782.99607.96
Hu, Krystal, D,130127017.440.000.002071.424946.02
Stone, Mitchell,2501369.970.000.000.0069.97
Shan, Elijah, L,267951992.460.000.00782.991209.47
Torres, Eddie, L,219853936.540.000.002181.561754.98
Liang, Glenn,219834144.340.000.002443.351700.99
Martinez, Terrance,257181274.080.00699.100.00574.98
Rivera, Evan, Y,267571344.470.000.00782.99561.48
Li, Crystal, L,143255152.700.000.002049.103103.60
Luo, Christine, J,241592756.540.000.002181.56574.98
Shan, Drew,236594179.330.000.002443.351735.98
Rodriguez, Heidi, L,251202155.920.000.001000.441155.48
Shan, Tasha,151924384.080.000.002049.102334.98
Wang, Kelvin, S,151434366.410.000.002071.422294.99
Miller, Zachary, M,151692919.890.000.002071.42848.47
Howard, Jesse, D,242492756.540.000.002181.56574.98
Luo, Colleen, E,152082951.560.000.002049.10902.46
Andersen, Kate,1423790.250.000.000.0090.25
Anand, Cassie, M,29342801.830.000.000.00801.83
Pal, Nichole, J,2674169.990.000.000.0069.99
Rana, Raymond,251152155.920.000.001000.441155.48
Suri, Jillian, L,151804466.390.000.002071.422394.97
Raji, Warren, J,267961957.470.000.00782.991174.48
Black, Shawna, C,152054433.690.000.002071.422362.27
Sanz, Monique, R,242732721.550.000.002181.56539.99
Gonzalez, Joel, A,150433846.890.000.002071.421775.47
Yang, Wesley, K,151275182.730.000.002071.423111.31
Hu, Valerie, M,150443803.560.000.002049.101754.46
Martinez, Lydia,241692735.530.000.002181.56553.97
Serrano, Anne,242443617.830.000.002443.351174.48
Romero, Frank, M,152092916.560.000.002049.10867.46
Kumar, Derek, M,151354381.390.000.002071.422309.97
Li, Edwin,269671336.960.000.001336.960.00
Rai, Raul, R,151335237.730.000.002071.423166.31
Serrano, Jacquelyn,2196339.990.000.000.0039.99
Gray, Morgan,28307561.480.000.000.00561.48
Li, Marshall,126876805.470.002071.420.004734.05
Blanco, Jimmy, V,14013138.450.000.000.00138.45
Simmons, Jacqueline, W,13137177.940.000.000.00177.94
Huang, Lacey, J,1195163.520.000.000.0063.52
Prasad, Ebony,243683946.520.000.002181.561764.96
Kovar, Mayra, J,173124471.743578.270.000.00893.47
Sara, Ross,243674179.330.000.002443.351735.98
Anderson, Victoria,157994423.380.000.002071.422351.96
Gao, Gilbert,241653046.840.000.002443.35603.49
Martinez, Ann,120098195.500.003399.990.004795.51
Ramos, Diane, L,1830064.880.000.000.0064.88
Rana, Ross,252402120.930.000.001000.441120.49
Moreno, Hector,211834657.510.002181.560.002475.95
Hernandez, Krista, J,269181399.940.000.00782.99616.95
Mr., Shen, Alan,242572770.520.000.002181.56588.96
Raman, Ruben,155802910.900.000.002071.42839.48
Gonzalez, Edgar, A,156483807.400.000.002071.421735.98
Bhat, Yolanda,152254401.410.000.002071.422329.99
Ye, Alvin, B,155752910.900.000.002071.42839.48
Raji, Omar,156433807.400.000.002071.421735.98
Shan, Shaun,242743018.330.000.002443.35574.98
Malhotra, Kristopher, L,152652897.570.000.002049.10848.47
Gao, Cara, B,156423772.410.000.002071.421700.99
Srini, Carolyn, S,273711350.750.000.00782.99567.76
Gill, Javier,156453785.080.000.002049.101735.98
Suri, Shane, L,251262174.920.000.001000.441174.48
Chen, Clayton, A,152194399.080.000.002049.102349.98
Prasad, Henry, M,243643965.520.000.002181.561783.96
Gonzalez, Jan, A,152623772.410.000.002071.421700.99
Gutierrez, Cheryl, O,252132184.900.000.001000.441184.46
Jenkins, Amanda,152144490.880.000.002071.422419.46
Alan, Bob, A,273661322.980.000.00782.99539.99
Sai, Ruth, D,244613302.050.000.002181.561120.49
Davis, Morgan, J,273591344.470.000.00782.99561.48
Chow, Warren, L,243053945.530.000.002181.561763.97
Moreno, Naomi, C,156014429.570.000.002049.102380.47
Raji, Damien, K,242823917.540.000.002181.561735.98
Goel, Gilbert,155964460.040.000.002049.102410.94
Gill, Anne,274691331.970.000.00782.99548.98
Johnsen, Willie,152184399.080.000.002049.102349.98
Lopez, Mayra, E,273561336.960.000.00782.99553.97
Diaz, Megan, A,243034207.320.000.002443.351763.97
Chander, Roger,252142149.910.000.001000.441149.47
Torres, Michele, A,161764404.080.000.002049.102354.98
Xu, Jaclyn, L,126856904.110.002049.100.004855.01
Becker, Leonard, C,22405123.980.000.000.00123.98
Hernandez, Jill, L,13003230.250.000.006.28223.97
Hill, Kaylee, L,119188204.990.003399.990.004805.00
Martinez, Holly, B,196286035.600.003578.270.002457.33
Carlson, Tanya,1618331.270.000.000.0031.27
Evans, Jackson,1432127.280.000.000.0027.28
Zheng, Dawn, F,1957983.980.000.000.0083.98
Patel, Douglas,179274726.040.003578.270.001147.77
Xie, Brendan,130182642.380.000.002071.42570.96
Powell, Jeremy,110486498.243374.990.000.003123.25
Guo, Tiffany,259271272.520.00699.100.00573.42
Yang, Shannon,120018113.010.003374.990.004738.02
Gutierrez, Francis,2524558.980.000.000.0058.98
Jai, Bonnie,119778212.500.003399.990.004812.51
Kumar, Wayne,175026070.590.003578.270.002492.32
Wilson, Sam,259471854.580.00699.100.001155.48
Guo, Cedric, R,274871322.980.000.00782.99539.99
Mr., Schmidt, Steve,157894486.070.000.002049.102436.97
Allen, Ian, A,160313750.090.000.002049.101700.99
Xu, Crystal, E,157544416.380.000.002071.422344.96
Guo, Rosa, M,244743882.550.000.002181.561700.99
Chande, Willie, B,161632641.390.000.002071.42569.97
Price, Deb,245023623.320.000.002443.351179.97
Rodriguez, Bobby,157524408.690.000.002071.422337.27
Hernandez, Erika,161602644.070.000.002049.10594.97
Alonso, Diana, L,245903911.530.000.002181.561729.97
Zhu, Sandra, V,157324376.400.000.002071.422304.98
Wang, Roger, P,246053627.810.000.003627.810.00
Lin, Dennis,161694404.080.000.002049.102354.98
Rai, Tonya,252432155.920.000.001000.441155.48
Perez, Edgar, B,293182384.070.000.000.002384.07
Carlson, Robin,197866021.620.003578.270.002443.35
Zhu, Christy,110038139.293399.990.002318.962420.34
Chen, Jaclyn, C,2284737.290.000.000.0037.29
Arun, Barry,2770039.980.000.000.0039.98
Gray, Stephanie,170644506.763578.270.000.00928.49
Romero, Dwayne,28314553.970.000.000.00553.97
Gill, Erika, A,182024143.260.003578.270.00564.99
Kumar, Louis, A,182034172.250.003578.270.00593.98
Mehta, Regina,1724592.970.000.000.0092.97
Shen, Alison, A,1661471.160.000.000.0071.16
Blanco, Wendy, J,19604171.730.000.000.00171.73
Chande, Mindy, V,274721345.950.000.00782.99562.96
Dominguez, Raquel, A,274701371.950.000.00782.99588.96
Patel, Abby,160293807.400.000.002071.421735.98
Rai, Melvin, J,246043681.800.000.003681.800.00
Zeng, Warren, R,244773302.050.000.002181.561120.49
Muñoz, Alberto, J,13008125.510.000.000.00125.51
Nath, Keith,1961761.750.000.000.0061.75
Dominguez, Roy, C,2918923.970.000.000.0023.97
Rai, Karl, M,252731898.07699.100.000.001198.97
Becker, Kelsey, G,119688079.050.003399.992294.992384.07
Vance, Monica, G,123388265.000.003374.990.004890.01
Holt, Alisha,2835013.980.000.000.0013.98
Alvarez, Kari, C,111088124.040.003374.992329.992419.06
Deng, April,111178184.990.003399.992365.942419.06
Huang, Dawn, E,119434734.290.003374.99539.99819.31
Coleman, Ethan, G,166936060.503578.270.002482.230.00
Sanchez, Joel,184685333.250.003578.271754.980.00
Mr., Solanki, Ajay,18295144.270.000.000.00144.27
Nara, Grant,129956850.580.000.002049.104801.48
Carter, Sophia, D,2523080.960.000.000.0080.96
Zheng, Omar, C,14522126.950.000.000.00126.95
Vance, Jillian, D,15230148.980.000.000.00148.98
Hernandez, Walter,13141240.240.000.000.00240.24
Roberts, Jennifer,114478078.020.003374.992309.972393.06
Raje, Terrence,182466030.610.003578.272452.340.00
Navarro, Melinda,114548089.040.003374.992294.992419.06
Shen, Shawn,192704127.250.003578.27548.980.00
Lu, Roger, F,197634153.250.003578.27574.980.00
Sanchez, Michele,2354312.940.000.000.0012.94
Sai, Regina,211924229.320.002443.350.001785.97
Yang, Curtis,111108093.030.003399.992294.992398.05
Ye, Brent,2892229.480.000.000.0029.48
Raje, Wayne, A,2137274.960.000.000.0074.96
Prasad, Gerald, B,1203581.240.000.0064.9716.27
Garcia, Ruben,196136093.200.003578.270.002514.93
Kumar, Tony, P,197836021.620.003578.270.002443.35
Gomez, Hector, A,2933749.990.000.000.0049.99
Gonzalez, Meredith,221712721.550.000.002181.56539.99
Hu, Crystal,2798029.480.000.000.0029.48
She, Sheena, R,2300859.980.000.000.0059.98
Ortega, Shannon,263751971.450.000.00782.991188.46
Gonzalez, Roy, M,1304059.980.000.000.0059.98
Lopez, Toni, K,2514021.490.000.000.0021.49
Xie, Alicia,26427123.980.000.000.00123.98
Suri, Whitney, J,219744925.170.000.002443.352481.82
Diaz, Ricky, E,183356035.600.003578.270.002457.33
Malhotra, Meredith,29314564.480.000.000.00564.48
Chandra, Ann,182096056.610.003578.272478.340.00
Suri, Ronald,182146093.200.003578.272514.930.00
Saunders, Micheal,175134260.240.003578.27681.970.00
Alonso, Danny, S,182176056.610.003578.272478.340.00
Chande, Lindsay,182446021.620.003578.272443.350.00
Nath, Cassie,246062155.920.001000.441155.480.00
Lin, Bianca,111078171.010.003374.992376.962419.06
Rubio, Erika, A,114528183.040.003374.992414.992393.06
Malhotra, Tina, C,27584599.470.000.000.00599.47

Generated 2024-11-10 02:55:00.032 UTC