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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Kumar, Lacey,139606871.740.000.002071.424800.32
Ramos, Tanya, R,140456804.130.000.002049.104755.03
Zheng, Sandra, P,1514163.970.000.000.0063.97
Romero, Latasha,142205696.190.000.002071.423624.77
Lal, Mitchell, C,204037.280.000.000.007.28
Garcia, Rebekah, M,140073772.410.000.003772.410.00
Shen, Kelsey, R,229214647.880.000.002181.562466.32
Tang, Jenny, E,142105621.240.000.003286.272334.97
Liang, Eugene,1397277.270.000.000.0077.27
Li, Jack, J,140715617.920.000.003297.932319.99
Luo, Julie, M,2912169.970.000.000.0069.97
Chande, Derek,267431371.950.000.001371.950.00
Washington, Marcus,283296.280.000.000.006.28
Ruiz, Naomi,236493945.530.000.002181.561763.97
Navarro, Kristy, J,1957074.940.000.0045.9528.99
Cai, Candice,267471938.470.000.00782.991155.48
Goel, Ricardo, T,259611938.470.00782.990.001155.48
Ye, Christy,142195744.220.000.002071.423672.80
Hernandez, Jaime,241703018.330.000.002443.35574.98
Kumar, Jenny, C,234293936.540.000.002181.561754.98
Cook, Isaac, M,139944528.750.000.002071.422457.33
Serrano, Francis, R,235473598.830.000.003598.830.00
Dominguez, Wendy,110356451.313374.990.000.003076.32
Chen, Rosa,234353917.540.000.002181.561735.98
Simpson, Sharon, L,2512339.980.000.000.0039.98
Romero, Jessie,250302180.410.000.001000.441179.97
Ms., Seidel, Birgit,1662173.860.000.000.0073.86
Pal, Donna, S,235723617.830.000.003617.830.00
Wu, Aimee,16690165.070.000.000.00165.07
Evans, Carlos, J,235384198.330.000.002443.351754.98
Suarez, Erika,151205217.700.000.002049.103168.60
Lopez, Donald, A,267401938.470.000.00782.991155.48
Liu, Dawn, C,2196039.990.000.000.0039.99
Vazquez, Eddie, T,140125249.920.000.002049.103200.82
Lu, Todd, D,2426914.980.000.000.0014.98
Li, Stacey,140645694.210.000.003375.252318.96
Vazquez, Rodney, M,13047241.930.000.000.00241.93
Ye, Jenny,250362120.930.000.001000.441120.49
Gonzalez, Jan, A,152623772.410.000.002071.421700.99
Anand, Leonard,143163797.370.000.002049.101748.27
Suri, Phillip,179144698.763578.270.000.001120.49
Li, Alvin,267641938.470.000.00782.991155.48
Sullivan, Summer, E,2118132.280.000.000.0032.28
Raji, Andres, E,139556888.440.000.002071.424817.02
Collins, Logan, H,13983180.410.000.00145.4234.99
Goel, Bradley,1580366.260.000.000.0066.26
Guo, Lacey,167446070.593578.270.002492.320.00
Moreno, Kathleen, C,1523459.980.000.0034.9924.99
Perez, Whitney,1661997.580.000.0067.5929.99
Romero, Kathleen,1401924.990.000.000.0024.99
Lewis, Kayla,120133949.970.003399.99549.980.00
Chander, Misty,1733380.940.000.000.0080.94
Lu, Christy,1706291.260.000.0091.260.00
Blue, Richard,12006144.740.000.0092.9751.77
Rubio, Deanna, T,1957333.980.000.000.0033.98
Mehta, Edgar,117618149.490.003399.992356.442393.06
Moreno, Mallory, P,229124659.900.000.002181.562478.34
Blanco, Billy,233162835.020.000.002181.56653.46
Powell, Jeremy,110486498.243374.990.000.003123.25
Reed, Steven,2437327.770.000.000.0027.77
Serrano, Neil, L,17076103.460.000.000.00103.46
Diaz, Felicia, J,1502629.980.000.0024.994.99
Gutierrez, Jay, C,13155226.950.000.00217.968.99
Huang, Jorge,1729186.270.000.0086.270.00
Chandra, Rebekah,28486776.330.000.000.00776.33
Russell, Jonathan,1889674.980.000.0074.980.00
He, Aimee, A,110938180.003399.990.002360.952419.06
Shan, Dylan,1967758.980.000.0058.980.00
Shen, Russell, M,11150192.420.000.00143.4548.97
Carlson, Alfredo,16178108.850.000.0038.8869.97
Gutierrez, Erika,1722783.970.000.0024.9958.98
Raji, Carly, L,233464.990.000.004.990.00
Alan, Bob, A,273661322.980.000.00782.99539.99
Raman, Edgar, A,2759664.470.000.0064.470.00
Alonso, Stacy,28315556.930.000.000.00556.93
Lal, Rafael, W,2894568.970.000.0068.970.00
Sanz, Lance,225732721.550.000.002181.56539.99
Alonso, Gary, C,187675314.250.003578.271735.980.00
Munoz, Anne,1579898.960.000.0034.9963.97
Lopez, Stanley, M,289622477.530.000.002477.530.00
Yuan, Sharon,1200855.760.000.000.0055.76
Vazquez, Ruben, B,143015142.750.000.002071.423071.33
Rodriguez, Douglas, W,196525314.250.003578.270.001735.98
Fernandez, Ross, R,1176376.650.000.0024.4952.16
Ye, Alejandro, W,150293826.400.000.002071.421754.98
Ramirez, Mason, K,251072143.900.000.001000.441143.46
Patel, Pamela, G,278751268.840.000.001268.840.00
Hernandez, Victor, T,2353759.980.000.000.0059.98
Andersen, Ashlee, J,11059116.930.000.00116.930.00
Raman, Arthur,240012983.340.000.002443.35539.99
He, Kelli, A,2887259.980.000.0059.980.00
Murphy, Grace, J,236554144.340.000.002443.351700.99
Hernandez, Jill, L,13003230.250.000.0071.25159.00
Alvarez, Jessie,143245121.430.000.002049.103072.33
Hill, Adam,187406056.610.003578.272478.340.00
Martin, Joe,146685216.690.000.002071.423145.27
Ms., Robinson, Dorothy, B.,119528169.000.003374.992395.962398.05
Kovar, Mayra, J,173124471.743578.270.000.00893.47
Martinez, Brett,235323337.040.000.003337.040.00
Yuan, Christine,110466616.813374.990.000.003241.82
Moreno, Tanya,1113983.970.000.000.0083.97
Suarez, Melody, H,142765259.360.000.002864.912394.45
Lin, Rafael,14099200.260.000.0041.26159.00
Chandra, Jermaine, A,142995108.760.000.002071.423037.34
Flores, Antonio, D,142593630.930.000.002888.58742.35
Davis, Ryan, C,278702419.060.000.000.002419.06
Moreno, Danny, M,29458811.320.000.000.00811.32
Tang, Christy, R,236603917.540.000.002181.561735.98
Watson, Nathaniel, H,258261854.580.00699.100.001155.48
Andersen, Jodi,2676678.980.000.000.0078.98
Munoz, Teresa, R,277121174.480.000.000.001174.48
Rai, Willie,146735117.750.000.002071.423046.33
Collins, Jennifer,113644921.820.003374.990.001546.83
Ruiz, Francis, D,2138169.990.000.000.0069.99
Chander, Tonya,15794113.970.000.0088.9824.99
Schmidt, Danny, M,289267.280.000.000.007.28
Zheng, Jenny, R,119474747.300.003374.99629.96742.35
Yang, Randy, E,240002983.340.000.002443.35539.99
Deng, Arturo, A,281021299.830.000.000.001299.83
Ramos, Robyn, O,15828172.250.000.0049.96122.29
Kumar, Gilbert, L,2814039.980.000.000.0039.98
He, Colin, B,143005322.730.000.002071.423251.31
Zhang, Glenn, A,139675721.910.000.002049.103672.81
Ramos, Marie, A,143085140.400.000.002049.103091.30
She, Jessie, A,136506768.140.000.002049.104719.04
Prasad, Tabitha, D,267611938.470.000.00782.991155.48
Ramos, Mary, B,1501972.960.000.008.9963.97
Ramos, Theresa, G,110316478.603399.990.000.003078.61
Washington, Abigail,236613961.030.000.002181.561779.47
Alexander, Olivia, L,146675295.410.000.002049.103246.31
Subram, Raymond,239942790.520.000.002181.56608.96
Hernandez, Kristine,142865234.400.000.002859.422374.98
Perez, Evelyn,143463583.260.000.002071.421511.84
Goel, Roger, A,236523907.540.000.002181.561725.98
Evans, Jonathan, D,151854393.700.000.002071.422322.28
Raje, Kurt,152102926.390.000.002071.42854.97
Martin, Briana, L,152132818.590.000.002049.10769.49
Zhu, Suzanne, E,251122155.920.000.001000.441155.48
Sara, Donald, M,251142155.920.000.001000.441155.48
Weber, Cynthia,269211336.960.000.00782.99553.97
Wang, Lacey,241732771.520.000.002181.56589.96
Hernandez, Orlando, C,219514923.290.002443.350.002479.94
Tang, Sharon, M,1582367.960.000.000.0067.96
Ferrier, Jaclyn, D,172994382.753578.270.000.00804.48
Malhotra, Cynthia,113585034.780.003374.990.001659.79
Morgan, Mackenzie, E,16162185.040.000.000.00185.04
Rubio, Jay,151794444.890.000.002071.422373.47
Wang, Martha, D,242722735.530.000.002181.56553.97
Ortega, Latasha,242702844.510.000.002181.56662.95
Raje, Grant, S,241623004.830.000.002443.35561.48
Zeng, Erica,269241350.750.000.00782.99567.76
Zeng, Amy,242422756.540.000.002181.56574.98
Hu, Marshall, H,267971957.470.000.00782.991174.48
Hernandez, Mathew, A,151844441.380.000.002071.422369.96
Gutierrez, Micheal, S,272991322.980.000.001322.980.00
Dominguez, Roberto, A,269171339.250.000.00782.99556.26
Raman, Meagan, J,151345151.710.000.002071.423080.29
Rai, Raul, R,151335237.730.000.002071.423166.31
Ashe, Brad,252282120.930.000.001000.441120.49
Hernandez, Alberto, D,250292272.200.000.001000.441271.76
Ramirez, Cole, E,136166872.060.000.002049.104822.96
Ortega, Janet, L,117548163.530.003399.992319.992443.55
Natsuhara, Tony,230972770.520.000.002181.56588.96
Griffin, Rachel,182556067.200.003578.270.002488.93
Fernandez, Holly, M,126756812.770.002071.422357.282384.07
Mr., Solanki, Ajay,18295144.270.000.00141.982.29
Blanco, Micheal, A,11113109.880.000.00109.880.00
Sanz, Walter, J,1819594.470.000.008.9985.48
She, Yolanda, M,183042.290.000.002.290.00
Chander, Carl,14315109.710.000.0074.4835.23
Prasad, Dominic, D,1996246.750.000.0016.2730.48
Richardson, Katelyn,189306035.600.003578.272457.330.00
Gonzalez, Eric, C,1909278.260.000.000.0078.26
Lu, Warren, H,289257.280.000.000.007.28
Carson, Kristin, C,244593961.030.000.002181.561779.47
Deng, Michele,219464659.800.002181.560.002478.24
Gill, Erika, A,182024143.260.003578.270.00564.99
Shen, Dustin,27974553.970.000.000.00553.97
Sara, George,242472721.550.000.002181.56539.99
Srini, Manuel,241682790.520.000.002181.56608.96
Shan, Elijah, L,267951992.460.000.00782.991209.47
Powell, Trevor, C,269221322.980.000.00782.99539.99
Ye, Alvin, B,155752910.900.000.002071.42839.48
Raji, Omar,156433807.400.000.002071.421735.98
Andersen, Gilbert, T,273531371.950.000.00782.99588.96
Alvarez, Kristy,155884486.070.000.002049.102436.97
Gill, Javier,156453785.080.000.002049.101735.98
Gonzalez, Natalie,252152155.920.000.001000.441155.48
He, Dawn,156473764.070.000.002049.101714.97
Rodriguez, Arthur,154383788.680.000.002071.421717.26
Subram, Douglas,273521357.970.000.00782.99574.98
Suarez, Nelson,273551383.450.000.00782.99600.46
Zhou, Clayton,273481382.460.000.00782.99599.47
Russell, Seth,251382120.930.000.001000.441120.49
Hill, Aaron,2581835.960.000.0035.960.00
Ashe, Jimmy, S,2895914.980.000.0014.980.00
Suarez, Danny,209954127.250.003578.27548.980.00
Xie, Drew, A,20218104.690.000.00104.690.00
She, Eugene, L,209982806.510.002181.56624.950.00
Mehta, Ann, M,14518126.950.000.0063.9762.98
Butler, Elijah, D,2155129.990.000.000.0029.99
Perez, Janelle,16172186.040.000.000.00186.04
Bailey, Savannah, J,2342839.980.000.000.0039.98
Zeng, Ramon,279794.990.000.000.004.99
Carlson, Theresa, L,19629109.440.000.0060.4748.97
Sun, Christy,252182184.900.000.001000.441184.46
Vazquez, Marc, H,243623600.770.000.003600.770.00
Sanz, Kari, V,273411322.980.000.00782.99539.99
Raji, Terry,155974391.410.000.002071.422319.99
Jimenez, Teresa, L,243723356.040.000.002181.561174.48
Moreno, Naomi, C,156014429.570.000.002049.102380.47
Gill, Anne,274691331.970.000.00782.99548.98
Serrano, Beth,243043946.520.000.002181.561764.96
Suri, Marie,242813302.050.000.002181.561120.49
Lopez, Mayra, E,273561336.960.000.00782.99553.97
Prasad, Carmen, L,189286095.080.003578.272516.810.00
Zhang, Edwin,157854454.350.000.002071.422382.93
Cox, Isaac,157974415.680.000.002071.422344.26
Serrano, Alberto, L,158004399.080.000.002049.102349.98
Liu, Cedric,126776785.470.002071.422294.992419.06
Yuan, Grant, C,249092149.910.000.002149.910.00
Travers, Alexa, A,244663337.040.000.002181.561155.48
Shan, Thomas, N,274831382.460.000.00782.99599.47
Zheng, Barbara,274931353.460.000.00782.99570.47
Martin, Byron, E,2521739.980.000.0039.980.00
Sun, Jorge,160253831.890.000.002071.421760.47
Kumar, Barbara, N,274991331.970.000.00782.99548.98
Ms., Sherwood, Irma, J.,245984228.310.000.002443.351784.96
Fernandez, Allen,195966056.610.003578.272478.340.00
Suri, Douglas,190966090.590.003578.272512.320.00
Vance, Monica, G,123388265.000.003374.992436.972453.04
Ramos, Leslie,157334443.550.000.002049.102394.45
Rodriguez, Bobby,157524408.690.000.002071.422337.27
Liu, Kelli, A,244804175.610.000.002443.351732.26
Vazquez, Randall, Z,2118635.000.000.0035.000.00
Torres, Monique,252352155.920.000.001000.441155.48
Becker, Julie,13614114.210.000.0086.9327.28
Muñoz, Jaime, C,245063563.840.000.002443.351120.49
Luo, Jerry, M,245864144.340.000.002443.351700.99
Lin, Clayton, M,274921344.910.000.00782.99561.92
Martinez, Jay,245923896.530.000.002181.561714.97
Wang, Roger, P,246053627.810.000.003627.810.00
Lin, Dennis,161694404.080.000.002049.102354.98
Zhou, Autumn, L,252292155.920.000.001000.441155.48
Gutierrez, Larry,259261308.060.00699.100.00608.96
Ruiz, Krista, C,130816772.150.000.002049.104723.05
Moreno, Melody, R,11760274.920.000.00146.97127.95
Zhang, Ramon, D,12352274.240.000.000.00274.24
Rai, Christy,1668369.870.000.000.0069.87
Zheng, Edwin, J,142165653.920.000.002049.103604.82

Generated 2024-09-20 00:16:53.629 UTC