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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Pais, Wilson, C,130385581.260.002071.420.003509.84
Shan, Colin,259211253.070.00699.100.00553.97
Zhou, Clayton,273481382.460.000.00782.99599.47
Vance, Henry,27986553.970.000.000.00553.97
Butler, Hannah, R,131115707.200.000.002071.423635.78
Alvarez, Erik, M,14311138.450.000.0074.4863.97
Sanchez, Andre,155954369.090.000.002049.102319.99
He, Jorge,2026821.490.000.000.0021.49
Wang, Shannon,110176434.313374.990.002316.97742.35
Lee, Destiny,1705883.980.000.000.0083.98
Goel, Alisha, C,267671331.970.000.001331.970.00
Jimenez, Latasha, E,13121121.250.000.0054.9966.26
Raji, Misty,165204727.743578.270.001149.470.00
Shen, Priscilla, A,28215589.960.000.00589.960.00
Sanchez, Lydia, S,125792589.090.002049.100.00539.99
Wang, Lacey,241732771.520.000.002181.56589.96
Yuan, Colin,1175858.050.000.0024.4933.56
Wang, Martha, D,242722735.530.000.002181.56553.97
Zhu, Erica,252212143.900.000.001000.441143.46
Flores, Miranda,1724383.980.000.0053.9929.99
Huang, Rosa, P,151814448.380.000.002071.422376.96
Jenkins, Wyatt,27987553.970.000.000.00553.97
Mehta, Mayra,129985694.900.002049.100.003645.80
Shan, Derek, R,197826089.590.003578.272511.320.00
She, Nina,229613891.540.000.003891.540.00
Hill, Luis,275001371.950.000.00782.99588.96
Peterson, Lucas,17298174.450.000.000.00174.45
She, Cedric, R,125802589.090.002049.100.00539.99
Lewis, Kayla,120133949.970.003399.99549.980.00
Raman, Geoffrey, P,154353801.390.000.002071.421729.97
Lal, Mario, T,233454.990.000.000.004.99
Wu, Aimee,16690165.070.000.000.00165.07
Moyer, Meghan,2122074.980.000.0074.980.00
Zhou, Rafael, A,244949.990.000.009.990.00
Ramos, Diane, L,1830064.880.000.0034.8929.99
Serrano, Leslie, T,1401462.270.000.000.0062.27
Kapoor, Phillip,27581539.990.000.000.00539.99
Garcia, Monica, D,2026749.970.000.000.0049.97
Rubio, Kathleen, A,208204143.740.003578.27565.470.00
Alexander, Gabriel, C,14073156.840.000.0038.88117.96
Perez, Preston,1237061.530.000.0034.5626.97
Cai, Candice,267471938.470.000.00782.991155.48
Sharma, Terrence, N,173516117.693578.270.000.002539.42
Munoz, Diane, R,15795132.440.000.00132.440.00
Carlson, Marc, W,17501141.980.000.000.00141.98
Lin, Autumn, E,182726056.613578.270.002478.340.00
Hernandez, Monique, J,15138123.450.000.0034.9988.46
Vance, Denise, L,212054886.700.002443.350.002443.35
Sun, Jamie,213892770.520.002181.56588.960.00
Romero, Francis,221964632.860.002181.560.002451.30
Cai, Cedric,195596056.610.003578.272478.340.00
Raje, Devon,292892433.040.000.002433.040.00
Clark, Joshua, A,2613769.990.000.000.0069.99
Romero, Jessie,250302180.410.000.001000.441179.97
Alonso, Ricky, S,140705618.930.000.003298.942319.99
Dominguez, Diana, L,292922393.060.000.002393.060.00
Sun, Aimee, R,1831960.470.000.0060.470.00
Zheng, Shannon, M,1467849.990.000.0049.990.00
Liu, Dennis,29062742.350.000.000.00742.35
Dominguez, Walter,125762653.070.002049.100.00603.97
Tang, Colin,143235222.020.000.002071.423150.60
Sai, Molly,1468398.950.000.0073.9624.99
Cox, Jared, E,28114570.470.000.00570.470.00
Arun, Ruth, S,172944355.713578.270.000.00777.44
Chandra, Ann,182096056.613578.270.002478.340.00
Hu, Alvin, E,114498130.320.003374.992362.272393.06
Torres, Dwayne, R,172884426.243578.270.000.00847.97
Torres, Neil,17305196.970.000.00196.970.00
Chavez, Karla, K,1670491.260.000.000.0091.26
She, Sheena, R,2300859.980.000.000.0059.98
Wang, Rosa, I,119938131.320.003374.990.004756.33
Hernandez, Joe,1515484.980.000.0084.980.00
Vazquez, Joanna, J,119908164.010.003374.992369.962419.06
Zhou, Alan,1648075.970.000.000.0075.97
Moreno, Felicia, A,129876759.470.002071.420.004688.05
Gonzalez, Clifford,245053302.050.000.002181.561120.49
Ma, Lacey, K,187235279.260.003578.271700.990.00
She, Stacey,267481357.970.000.001357.970.00
Wang, Nathan,140396808.130.000.002049.104759.03
Gonzalez, Phillip, N,182076089.590.003578.272511.320.00
Kapoor, Brett, L,2214769.990.000.000.0069.99
Huang, Mandy,1826672.260.000.000.0072.26
He, Jessie,29094796.340.000.000.00796.34
Suarez, Brandi,218744638.890.002181.560.002457.33
Rubio, Kristy,122433914.980.003374.990.00539.99
She, Mandy, K,2197240.230.000.000.0040.23
Navarro, Carolyn,110698104.053399.990.002319.992384.07
Subram, Ross, L,230857.280.000.000.007.28
Shan, Deborah,206246021.620.003578.270.002443.35
Hernandez, Roberto,289232393.060.000.002393.060.00
Rai, Melvin, J,246043681.800.000.003681.800.00
Li, Vincent, D,21207123.960.000.000.00123.96
Gao, Krystal,258211879.070.00699.100.001179.97
Ramos, Gloria, A,213657.280.000.007.280.00
Hernandez, Wendy, A,15124122.440.000.000.00122.44
Black, Michele,1399564.970.000.000.0064.97
Sanchez, Carla,1827430.970.000.000.0030.97
Jiménez, Alberto, C,152154468.560.000.002049.102419.46
Chen, Aimee,265911957.470.000.00782.991174.48
Ye, Damien, M,136206848.070.000.002049.104798.97
Gomez, Gary,1564034.570.000.0034.570.00
Liang, Omar,2424517.270.000.000.0017.27
Alonso, Kristine,166864157.733578.270.000.00579.46
Serrano, Mallory, E,267511903.480.000.00782.991120.49
Sun, Micah,248872218.900.001000.441218.460.00
Serrano, Derrick,167074377.753578.270.00799.480.00
Gomez, Erik, T,291802452.040.000.002452.040.00
Vance, Marco,1312487.930.000.000.0087.93
Travers, Reginald,28488742.350.000.000.00742.35
Hernandez, Kellie, A,125862636.410.002071.420.00564.99
Chen, Jaclyn, C,2284737.290.000.000.0037.29
Lin, Clayton, M,274921344.910.000.00782.99561.92
Morris, Isaac, G,264391938.470.00782.990.001155.48
Shan, Sheena, J,2156548.980.000.0048.980.00
Malhotra, Meredith,29314564.480.000.000.00564.48
Zhou, Gilbert,244753945.530.000.002181.561763.97
Suri, Gerald,13617116.920.000.0062.9453.98
Powell, Grace, B,291942419.060.000.002419.060.00
Zheng, Dennis, E,255671239.090.00699.100.00539.99
Gill, Hector, M,261871932.460.00782.990.001149.47
Henderson, Angela, T,118988179.030.003399.992394.972384.07
Prasad, Brett, A,2026227.770.000.000.0027.77
Vazquez, Erika, S,229747.280.000.007.280.00
Hu, Omar, S,289542393.060.000.002393.060.00
King, Evan,166375900.553578.270.000.002322.28
Li, Karen, K,179214698.763578.270.000.001120.49
Gutierrez, Orlando,259201819.590.00699.100.001120.49
Li, Lacey,175154143.263578.270.00564.990.00
Sanz, Lawrence, M,140306905.470.000.002071.424834.05
Patterson, Melissa, E,126686839.460.002071.422329.982438.06
Lal, Tara, S,186975279.260.003578.271700.990.00
Rodriguez, Jonathan, J,1304664.970.000.0029.9834.99
Patterson, Jennifer, M,151295177.730.000.002071.423106.31
Andersen, Brendan,151215202.730.000.002071.423131.31
Lal, Carl, C,2895044.980.000.0044.980.00
Beck, Ashlee, L,266661336.960.000.001336.960.00
Navarro, Stacy, C,126886867.440.002071.422376.962419.06
Gill, Jay,2797583.470.000.000.0083.47
King, Jesse, J,1466581.260.000.000.0081.26
Fernandez, Ross, R,1176376.650.000.0024.4952.16
Zhou, Kelvin,2023160.470.000.000.0060.47
Lin, Damien, L,234143391.030.000.003391.030.00
Rodriguez, Evelyn,131176831.420.000.002049.104782.32
Yang, Valerie, L,2736169.990.000.000.0069.99
Blanco, Kristi,1546437.270.000.000.0037.27
Chandra, Jarrod,241713006.310.000.002443.35562.96
Yuan, Cassie, J,2445360.470.000.000.0060.47
Nara, Dawn, M,218914921.690.002443.350.002478.34
Yang, Randy, E,240002983.340.000.002443.35539.99
Zeng, Krystal, A,2581461.960.000.000.0061.96
Sanz, Monique, R,242732721.550.000.002181.56539.99
Alvarez, Reginald, A,187466135.090.003578.272556.820.00
Mehta, Ebony, J,228544659.900.000.002181.562478.34
Blanco, Larry, E,212164935.670.002443.350.002492.32
Alvarez, Marc, B,1822145.950.000.000.0045.95
Prasad, Francisco,16628187.580.000.000.00187.58
Gao, Bianca, C,131125717.890.000.002049.103668.79
Torres, Melinda, J,140336809.960.000.002071.424738.54
Deng, Casey, C,1967442.280.000.000.0042.28
King, Nathan,27719599.470.000.000.00599.47
Nelson, Natalie, C,2292858.980.000.000.0058.98
Shan, Shawna, K,278692462.550.000.000.002462.55
Griffin, Blake, S,186995308.240.003578.271729.970.00
Raman, Candace, M,117668280.480.003399.992419.462461.03
Diaz, Felicia, J,1502629.980.000.0024.994.99
Browning, Janet,199796090.590.003578.270.002512.32
Gill, Kristy,13669102.430.000.0094.487.95
Deng, Johnny,2140935.000.000.0035.000.00
Gray, Faith,2291459.980.000.0059.980.00
Stone, Denise,110326525.563374.990.000.003150.57
Blanco, Krista, L,2758039.980.000.000.0039.98
Chandra, Dominique, H,2676578.980.000.0078.980.00
Nara, Katrina, Z,246082120.930.001000.441120.490.00
Moreno, Danny, M,29458811.320.000.000.00811.32
Zhu, Vincent, E,24899105.450.000.00105.450.00
Sun, Karen, C,282082398.050.000.002398.050.00
Carlson, Francis,273401350.750.000.001350.750.00
Zheng, Darryl,187066060.500.003578.272482.230.00
Kumar, Tony, P,197836021.620.003578.270.002443.35
Raje, Terry, A,283112393.060.000.002393.060.00
Ramos, Alfredo,204566029.570.003578.270.002451.30
Sanchez, Denise,167036090.593578.270.002512.320.00
Moore, Nathan, N,283232384.070.000.002384.070.00
She, Kristin, L,1996197.970.000.008.9988.98
Ramos, Theresa, G,110316478.603399.990.000.003078.61
Lal, Darrell,1995325.480.000.000.0025.48
Ortega, Lawrence,14685146.740.000.000.00146.74
Becker, Julie,13614114.210.000.0086.9327.28
Sara, Edgar, A,111048173.033399.990.002334.982438.06
Gill, Joanna,2618638.980.000.000.0038.98
Kumar, Rafael, L,1908824.270.000.002.2921.98
Ms., Sanchez, Madalena, J.,130202589.090.002049.100.00539.99
Romero, Deanna, K,2357021.980.000.0021.980.00
Raje, Dale, H,27746628.970.000.00628.970.00
Rivera, Steven, T,190836021.620.003578.272443.350.00
Cox, Angel, M,1879330.480.000.000.0030.48
Sanz, Reginald, K,1752274.950.000.000.0074.95
Xie, Ricardo,187106098.580.003578.272520.310.00
Jai, Alison,236574.990.000.000.004.99
Rodriguez, Ebony,1451782.970.000.000.0082.97
Lal, Julie, A,283092419.060.000.002419.060.00
Zheng, Rosa, G,166295933.263578.270.000.002354.99
Zhang, Brittney, W,199756056.610.003578.270.002478.34
Tang, Cristina, D,19623153.930.000.000.00153.93
Tang, Leonard, L,28109778.620.000.00778.620.00
Zheng, Randy, B,2257469.990.000.000.0069.99
Beck, Barbara,265471407.960.000.00782.99624.97
Ms., Robinson, Dorothy, B.,119528169.000.003374.992395.962398.05
Zhu, Amy, W,26664123.980.000.00123.980.00
Kumar, Cedric, B,228604663.790.000.002181.562482.23
Carlson, Shannon, C,110098091.333374.990.004716.340.00
Madan, Toni,26668119.980.000.00119.980.00
Chande, Melvin, R,114608137.520.003399.992294.992442.54
Prasad, Harold,1960868.450.000.000.0068.45
Suarez, Alfredo,196015314.250.003578.270.001735.98
Vazquez, Mallory, M,18283119.950.000.000.00119.95
Sharma, Clayton, D,122403964.980.003399.990.00564.99
Rodriguez, Allen, L,177324752.753578.270.000.001174.48
Rai, Tracy, K,170794417.753578.270.000.00839.48
Lu, Todd, D,2426914.980.000.000.0014.98
King, Maria, E,282022419.060.000.002419.060.00
Nath, Rafael,235333917.540.000.002181.561735.98
Jimenez, Marie, C,241763042.820.000.002443.35599.47
Rodriguez, Kristi,143453639.920.000.002049.101590.82
Serrano, Rebekah,141303814.060.000.003814.060.00
Goel, Brad, M,29085777.340.000.000.00777.34
Lal, Devon, L,1523766.260.000.000.0066.26
Hernandez, Danny,2714674.980.000.000.0074.98
Subram, Francisco, A,218974909.670.002443.350.002466.32
Kumar, Luke,241612983.340.000.002443.35539.99
Fernandez, Allen,195966056.610.003578.272478.340.00
Serrano, Deanna, W,151444344.090.000.002049.102294.99
Chapman, Pamela, L,2714535.000.000.000.0035.00
Ashe, Tara, J,190936035.600.003578.272457.330.00
Munoz, Jacquelyn,291152407.040.000.002407.040.00
Luo, Dustin,172404385.033578.270.000.00806.76
Ramos, Jessie, R,117648129.020.003399.992344.962384.07
Butler, Jason,175104369.743578.270.000.00791.47
Goel, Alejandro, K,130776766.630.002049.100.004717.53
Arthur, Johnathan,1873036.960.000.000.0036.96
Rana, Molly,2155474.980.000.000.0074.98
Yuan, Karla, W,136296889.110.000.002049.104840.01
Nath, Bethany,16177133.340.000.000.00133.34
Lopez, Luis, P,173344347.763578.270.000.00769.49
Xu, Peter, K,282042419.060.000.002419.060.00
Liu, Omar, L,122523938.950.003374.990.00563.96
Lopez, Adriana, A,120028145.330.003374.992357.282413.06
Srini, Cindy, E,260264.990.000.004.990.00
Goel, Bradley,1580366.260.000.000.0066.26
Raje, Rafael, M,130006799.450.002071.422294.992433.04

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