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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
She, Jessie, A,136506768.140.000.002049.104719.04
Yang, Alejandro, M,22176100.460.000.000.00100.46
Suri, Kari,2526657.980.000.000.0057.98
Madan, Bruce, G,1820665.960.000.0056.978.99
Miller, Dalton, D,131306797.150.000.002049.104748.05
Ramos, Tanya, R,140456804.130.000.002049.104755.03
Zheng, Cara, L,27513563.770.000.000.00563.77
Kapoor, Kristina,119977029.780.003399.991249.842379.95
Nath, Dale, B,27343132.970.000.000.00132.97
Hu, Lacey,199486021.620.003578.272443.350.00
Yang, Colin, J,206126060.500.003578.270.002482.23
Smith, Tina, K,197936056.610.003578.272478.340.00
Johnson, Emma, M,1513662.270.000.0034.9927.28
Hill, Kaylee, L,119188204.990.003399.992411.942393.06
Griffin, Blake, S,186995308.240.003578.271729.970.00
Mehta, Denise,130806844.410.002049.102362.272433.04
Shen, Lindsey,265601396.440.000.00782.99613.45
Nara, Cassie,1364279.970.000.0029.9849.99
Pal, Roger, D,2770539.980.000.000.0039.98
Huang, Micah,251307.280.000.007.280.00
Edwards, Kaylee, M,228514632.860.002181.560.002451.30
Carlson, Shannon, C,110098091.333374.990.004716.340.00
Suri, Adriana,184634726.040.003578.270.001147.77
Zeng, Brittney, K,13670178.450.000.0054.47123.98
Davis, Isabella, A,229294673.880.000.002181.562492.32
Gomez, Jill,29315103.960.000.00103.960.00
Fernandez, Marie,289297.280.000.000.007.28
Patel, Virginia, R,1136677.270.000.000.0077.27
Liang, Eugene,1397277.270.000.000.0077.27
Gutierrez, Francis,2524558.980.000.000.0058.98
Ruiz, Kari, L,12695192.970.000.00159.0033.97
Sara, Jarrod,206266038.560.003578.270.002460.29
Lal, Deborah, T,219823882.550.002181.560.001700.99
Andersen, Deborah,19610118.940.000.0068.9749.97
Tang, Drew, W,151784445.060.000.002049.102395.96
Liu, Lacey, L,235453882.550.000.002181.561700.99
Perez, Joe, A,143265207.700.000.002071.423136.28
Sara, Donald, M,251142155.920.000.001000.441155.48
Romero, Ruben,1663268.870.000.000.0068.87
Dominguez, Darren, M,139666842.120.000.002049.104793.02
Ramirez, Isaiah,119058155.980.003374.992367.932413.06
Lu, Jeffery, B,199716056.610.003578.270.002478.34
Sharma, Jerry, C,136516812.120.000.002049.104763.02
Goel, Dale, M,204164118.260.003578.27539.990.00
Ramos, Jessie, R,117648129.020.003399.992344.962384.07
Gutierrez, Larry,259261308.060.00699.100.00608.96
Munoz, Tanya,234363950.520.000.002181.561768.96
Shen, Katie, A,202835314.250.003578.270.001735.98
Vazquez, Casey, S,131326880.620.000.002049.104831.52
Tang, April, A,259351256.030.00699.100.00556.93
Rai, Rafael, H,18715123.960.000.000.00123.96
Gao, Curtis, D,204295377.750.003578.270.001799.48
Thompson, Cameron, M,166205895.243578.270.000.002316.97
Shan, Gregory,206146035.600.003578.270.002457.33
Martin, Diane,139586838.640.000.002049.104789.54
Vazquez, Joanna, J,119908164.010.003374.992369.962419.06
Adams, Devin,2187129.990.000.000.0029.99
Goel, Alicia, H,204234177.740.003578.27599.470.00
Sai, Jay, A,234274.990.000.000.004.99
Anand, Kelli, A,204516054.220.003578.270.002475.95
Dominguez, Larry,221974740.980.002181.560.002559.42
Tang, Edwin,204506021.620.003578.270.002443.35
Zheng, Alisha,222034624.910.000.002181.562443.35
Muñoz, Alberto, J,13008125.510.000.000.00125.51
Allen, Ian, A,160313750.090.000.002049.101700.99
Nath, Keith,1961761.750.000.000.0061.75
Raman, Brandy,1224777.270.000.0077.270.00
Raji, Kathryn, C,2199537.290.000.000.0037.29
Alonso, Teresa,1313883.970.000.0058.9824.99
Nara, Ricardo,2893464.470.000.000.0064.47
Cox, Nicole, V,229503917.540.000.003917.540.00
Suri, Cassandra, B,1871787.210.000.000.0087.21
Serrano, Stacy,246132148.210.001000.441147.770.00
Yang, Randy, E,240002983.340.000.002443.35539.99
Srini, Veronica,119967058.700.003374.991291.772391.94
Huang, Omar, C,1423277.270.000.0049.9927.28
Chen, Erica, P,183086037.890.003578.272459.620.00
Vance, Monica, G,123388265.000.003374.992436.972453.04
Yang, Heather,182756021.620.003578.272443.350.00
Mr., Solanki, Ajay,18295144.270.000.00141.982.29
Bradley, Diane, A,1514062.270.000.0027.2834.99
Liu, Darryl,199476056.510.003578.270.002478.24
Serrano, Mallory, E,267511903.480.000.00782.991120.49
Johnson, Chloe, L,206176058.210.003578.270.002479.94
Jai, Drew, M,215624632.860.002181.560.002451.30
She, Jaime, D,28482777.340.000.000.00777.34
Hernandez, Walter,13141240.240.000.000.00240.24
Suri, Marie,242813302.050.000.002181.561120.49
Alvarez, Philip, A,1112345.880.000.0037.937.95
Holt, Alisha,2835013.980.000.000.0013.98
Raji, Jaclyn,182898.990.000.000.008.99
Romero, Roberto, A,18285141.550.000.0069.9771.58
Gonzalez, Deanna, S,152044444.070.000.002049.102394.97
Carter, Sophia, D,2523080.960.000.000.0080.96
Wilson, Edward, L,265621925.410.000.00782.991142.42
Tang, Terrence, R,17303123.450.000.000.00123.45
Collins, Jennifer,113644921.820.003374.990.001546.83
Sanz, Rodney,1692644.950.000.000.0044.95
Rubio, Beth,2024056.960.000.000.0056.96
Jai, Jodi, M,2797158.980.000.000.0058.98
Sharma, Tracy,1773123.780.000.000.0023.78
Suarez, Linda,1666581.810.000.000.0081.81
Zeng, Alisha, A,15727134.460.000.0099.4734.99
Zhang, Edwin,157854454.350.000.002071.422382.93
Dominguez, Jerome, F,229873942.030.000.002181.561760.47
Rubio, Monique, M,291017.280.000.000.007.28
Mehta, Levi, M,131105583.940.000.002049.103534.84
Anand, Ricardo,2138369.990.000.000.0069.99
Lal, Terrence,1236994.230.000.000.0094.23
Garcia, Toni,221934886.700.002443.350.002443.35
Raman, Ronald, M,17077138.450.000.0088.4649.99
Huang, Barbara,264421919.750.00782.990.001136.76
Zeng, Alvin, M,11118115.850.000.000.00115.85
Ward, Katelyn,202586029.570.003578.270.002451.30
Raman, Jay, M,136186763.150.000.002049.104714.05
Bryant, Fernando, M,206096117.690.003578.270.002539.42
Raman, Candace, M,117668280.480.003399.992419.462461.03
Gutierrez, Marvin,259381308.060.00699.100.00608.96
Zheng, Jenny, R,119474747.300.003374.99629.96742.35
Suarez, Danny,209954127.250.003578.27548.980.00
Sharma, Dustin, M,184846093.200.003578.272514.930.00
Madan, Raymond, W,208194181.760.003578.27603.490.00
Xu, Casey, J,13158221.910.000.0064.97156.94
Raman, Summer, C,259491882.570.00699.100.001183.47
Goldstein, Dustin,123378137.010.003399.992343.962393.06
Luo, Shawn,122463947.250.003374.990.00572.26
Collins, Andrea,122503964.980.003399.990.00564.99
Prasad, Preston, C,208124127.250.003578.27548.980.00
Gutierrez, Rodney, J,206286056.610.003578.270.002478.34
Shan, Deborah,206246021.620.003578.270.002443.35
Lu, Margaret, D,208144186.230.003578.27607.960.00
Ross, Connor, J,208164228.720.003578.27650.450.00
Arun, Gerald,259401277.560.00699.100.00578.46
Ruiz, Shannon,208224134.530.003578.27556.260.00
Kumar, Tony, P,197836021.620.003578.270.002443.35
Tang, Sharon, M,1582367.960.000.000.0067.96
Chander, Julie, E,18763123.960.000.000.00123.96
Black, Shaun, M,1735546.470.000.000.0046.47
Gomez, Hector, A,2933749.990.000.000.0049.99
Gomez, Nelson, L,2905338.980.000.000.0038.98
Sanz, Kari, V,273411322.980.000.00782.99539.99
Garcia, Andre, H,127056854.110.002049.100.004805.01
Arthur, Jay, R,126946785.130.002049.100.004736.03
Hu, Crystal,2798029.480.000.000.0029.48
Nara, Cristina, R,197926056.610.003578.270.002478.34
Yuan, Melvin,2933147.970.000.000.0047.97
Sharma, Andres, C,2423013.980.000.000.0013.98
Sun, Lacey, L,1513181.260.000.000.0081.26
Ruiz, Melody,13621167.400.000.000.00167.40
Li, Stacey,140645694.210.000.003375.252318.96
Garcia, Darren,2871629.480.000.000.0029.48
Beck, Bonnie, A,29097548.980.000.000.00548.98
Romero, Latasha,142205696.190.000.002071.423624.77
Subram, Raymond,239942790.520.000.002181.56608.96
Suarez, Lance, C,1723083.980.000.0053.9929.99
Ye, Brent,2892229.480.000.000.0029.48
Subram, Cassandra, M,1661876.150.000.000.0076.15
Raje, Raul, L,2678574.980.000.000.0074.98
Perez, Allen, B,1422974.980.000.000.0074.98
Lopez, Edgar, O,1734681.460.000.000.0081.46
Sara, Ruben, A,19566164.910.000.000.00164.91
Browning, Javier,231204144.340.000.002443.351700.99
Zhang, Ramon, D,12352274.240.000.000.00274.24
Alonso, Diane, M,2063074.980.000.000.0074.98
Gill, Javier,156453785.080.000.002049.101735.98
Martin, Deanna,130916864.950.000.002071.424793.53
Raji, Devon, D,2189874.980.000.000.0074.98
Perez, Cesar, L,27982603.490.000.000.00603.49
Malhotra, Tina, C,27584599.470.000.000.00599.47
Romero, Jessie,250302180.410.000.001000.441179.97
West, Nathan,2437067.930.000.000.0067.93
Zhu, Suzanne, E,251122155.920.000.001000.441155.48
Rana, Ivan, K,181964133.243578.270.000.00554.97
Wu, Micah,172464380.043578.270.000.00801.77
Rubio, Kristy,122433914.980.003374.990.00539.99
Liu, Omar, L,122523938.950.003374.990.00563.96
Ms., Simon, Britta,259461873.580.00699.100.001174.48
Martinez, Troy, L,208234216.750.003578.27638.480.00
Yuan, Chad, C,211734659.900.002181.560.002478.34
Moreno, Roberto, R,212063882.550.002181.560.001700.99
Kumar, Alison,212003932.540.002181.560.001750.98
Ortega, Lance, C,123546797.130.002049.102309.972438.06
Allen, Luis, C,260191957.470.00782.990.001174.48
Gao, Wesley,123466864.460.002071.422354.982438.06
Yang, Tiffany, K,212154624.910.002181.560.002443.35
Wood, Julia, L,123566810.130.002049.102341.972419.06
Xu, Rafael, N,211954144.340.002443.350.001700.99
Shen, Jaclyn, A,125752668.080.002049.100.00618.98
Flores, Katherine,211803882.550.002181.560.001700.99
Raji, Grant, R,1618528.980.000.003.9924.99
Xu, Colleen, C,18325108.850.000.0038.8869.97
Gutierrez, Diana,1967667.970.000.000.0067.97
She, Willie,170554347.763578.270.000.00769.49
Perez, Brett, M,28313647.940.000.000.00647.94
Gutierrez, Ricky,197736056.610.003578.270.002478.34
Moreno, Kristine, K,28481778.620.000.000.00778.62
Sanz, Hector,2734469.990.000.000.0069.99
Navarro, Mathew, A,1967337.290.000.000.0037.29
Rana, Molly,2155474.980.000.000.0074.98
Torres, Monique,252352155.920.000.001000.441155.48
Lal, Shaun, H,170564417.753578.270.000.00839.48
Zhou, Laura, D,126836801.450.002071.420.004730.03
Raje, Tara, F,28483765.320.000.000.00765.32
Raje, Gregory, C,2291139.980.000.000.0039.98
Suarez, Leslie, C,2295513.980.000.000.0013.98
Ruiz, Naomi,236493945.530.000.002181.561763.97
Vazquez, Kristine, M,177364742.743578.270.000.001164.47
Rodriguez, Harold, M,2118474.980.000.000.0074.98
Serrano, Joy, L,14069173.940.000.000.00173.94
Goel, Lacey, N,1870433.260.000.0030.972.29
Ye, Christy,142195744.220.000.002071.423672.80
Diaz, Stacy, L,123406752.130.002049.102318.962384.07
Kapoor, Pedro, H,242297.280.000.000.007.28
Rubio, Desiree, D,211894208.310.002443.350.001764.96
Ruiz, Adrienne,1352367.260.000.000.0067.26
She, Eugene, L,209982806.510.002181.56624.950.00
Hu, Barbara,19567104.960.000.0075.9728.99
Gao, Jamie,260221938.470.00782.990.001155.48
Vazquez, Jimmy, D,123486906.090.002049.102423.952433.04
Navarro, Albert, L,215614947.780.002443.350.002504.43
Pal, Arturo, P,293032419.060.000.000.002419.06
Sanz, Marvin,196126029.570.003578.270.002451.30
Diaz, Nelson, C,213872745.330.002181.560.00563.77
Arun, Candace, J,213934925.170.002443.350.002481.82
Hernandez, Kellie, A,125862636.410.002071.420.00564.99
Serrano, Alfredo,212583936.540.002181.560.001754.98
Liu, Cedric,126776785.470.002071.422294.992419.06
Vazquez, Danny, J,260331903.480.00782.990.001120.49
Suarez, Lawrence, C,261311952.450.00782.990.001169.46
Liu, Clarence,197976021.620.003578.270.002443.35
Hall, Jesse,261331938.470.00782.990.001155.48
Huang, Alan, A,126716802.130.002049.102319.992433.04
Henderson, Cassidy,212283936.540.002181.560.001754.98
Patterson, Melissa, E,126686839.460.002071.422329.982438.06
Fernandez, Holly, M,126756812.770.002071.422357.282384.07
Sara, Candace,213802735.530.002181.56553.970.00
Rodriguez, Wyatt, D,212184661.500.002181.560.002479.94
She, Cedric, R,125802589.090.002049.100.00539.99
Torres, Meghan, I,212563917.540.002181.560.001735.98
Butler, Hannah, R,131115707.200.000.002071.423635.78
Travers, Danny,1258777.270.000.000.0077.27
Kelly, Zoe,2312339.980.000.000.0039.98
Ye, Vincent,13013256.240.000.000.00256.24
Cox, Isaac,157974415.680.000.002071.422344.26
Sanz, Orlando,1430999.470.000.0074.4824.99
Lewis, Jasmine,139646806.450.000.002071.424735.03
Gao, Rosa,2603421.490.000.000.0021.49
Shan, Mario,252711854.58699.100.000.001155.48
Tang, Jenny, E,142105621.240.000.003286.272334.97
Serrano, Tyrone,113605025.800.003399.990.001625.81

Generated 2024-09-19 21:33:11.534 UTC