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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Raje, Alison, J,1234564.710.000.0064.710.00
Yang, Leah, J,1518659.480.000.0059.480.00
Moreno, Melody, R,11760274.920.000.00146.97127.95
Munoz, Audrey, V,120038256.500.003374.992399.472482.04
Kumar, Keith, M,252247.280.000.007.280.00
Zhao, Kristen,169307.950.000.007.950.00
Dominguez, Theresa, L,187695304.250.003578.271725.980.00
Hernandez, Melinda,16174140.450.000.0092.4847.97
Jimenez, Gary, E,16609344.040.000.00344.040.00
Lin, Karen,2424348.970.000.000.0048.97
Lin, Margaret, C,1830687.770.000.000.0087.77
Lu, Jeffery, B,199716056.610.003578.270.002478.34
Mehta, Arthur, A,199576035.600.003578.270.002457.33
Luo, Casey,110728194.003399.990.002395.962398.05
Sara, Ruben, A,19566164.910.000.000.00164.91
Rai, Sharon,202256056.610.003578.270.002478.34
Kapoor, Abby, J,29054751.340.000.000.00751.34
Lin, Mandy, C,250352183.910.000.001000.441183.47
Becker, Gregory, M,131046894.440.000.002071.424823.02
Alonso, Gloria, S,199646056.610.003578.270.002478.34
Blanco, Jimmy, V,14013138.450.000.00103.4634.99
Martin, Pedro, B,281031214.850.000.000.001214.85
Goldstein, Brendan,135182638.360.000.002049.10589.26
Zhao, Heather,245964168.830.000.002443.351725.48
Gao, Laura,2202930.970.000.000.0030.97
Chandra, Andre, L,2526235.720.000.000.0035.72
Guo, Lisa, S,1731478.960.000.000.0078.96
Hernandez, Erika,161602644.070.000.002049.10594.97
Fernandez, Shane, A,1312786.260.000.000.0086.26
Yuan, Warren, P,190912.290.000.000.002.29
Rubio, Kristy,122433914.980.003374.990.00539.99
Prasad, Clifford,1560466.750.000.000.0066.75
Martin, Anne, V,250342164.910.000.001000.441164.47
Raman, Ruben,155802910.900.000.002071.42839.48
Sun, Suzanne, P,245873882.550.000.002181.561700.99
Romero, Wendy, H,113724965.810.003374.990.001590.82
Torres, Melinda, J,140336809.960.000.002071.424738.54
Raje, Marshall, J,1926742.280.000.000.0042.28
Moyer, Mario,234204144.340.000.002443.351700.99
Munoz, Carolyn, L,173156030.613578.270.000.002452.34
Martinez, Virginia,1313662.270.000.000.0062.27
Chen, Randy,13004190.270.000.000.00190.27
Perez, Ivan, S,234084218.820.000.002443.351775.47
Martin, Natasha, N,274901331.970.000.00782.99548.98
Johnson, Morgan, E,120114735.810.003374.99618.47742.35
Lewis, Hannah,265611336.960.000.00782.99553.97
Shan, Thomas, N,274831382.460.000.00782.99599.47
Parker, Timothy, C,229434144.340.000.002443.351700.99
Sun, Dennis, K,244814179.330.000.002443.351735.98
Ms., Sanchez, Madalena, J.,130202589.090.002049.100.00539.99
Simmons, Jordyn,164945961.203578.270.000.002382.93
He, Eugene, L,136456817.120.000.002049.104768.02
Lopez, Ross,1844360.470.000.000.0060.47
Lewis, Jasmine,139646806.450.000.002071.424735.03
Cook, Sydney, D,131185669.900.000.002049.103620.80
Townsend, Larry, D,111344911.833399.990.000.001511.84
Watson, Anna,202386021.620.003578.270.002443.35
Zhang, James,1468438.550.000.000.0038.55
He, Amy,224112770.520.000.002181.56588.96
Wu, Jamie, S,2759564.470.000.000.0064.47
Carson, Mitchell,1362399.200.000.000.0099.20
Black, Rafael,1196655.760.000.000.0055.76
Mehta, Ebony, J,228544659.900.000.002181.562478.34
Chande, Arturo, H,1486067.260.000.0039.9827.28
Lopez, Kari,15235190.890.000.000.00190.89
Gill, Lee, L,276941184.460.000.000.001184.46
Suarez, Orlando,1112158.160.000.000.0058.16
Ruiz, Carolyn, M,27863565.470.000.000.00565.47
Kapoor, Ruben, D,111098245.013374.990.002476.962393.06
Yang, Jamie, S,184654752.750.003578.270.001174.48
Lin, Clarence,29069756.330.000.000.00756.33
Jimenez, Felicia, L,110758068.033374.990.002294.992398.05
Xie, Michele, M,1503978.960.000.000.0078.96
Garcia, Levi, G,2123239.980.000.000.0039.98
Munoz, Natasha, M,246013882.550.000.002181.561700.99
Liu, Kelli, A,244804175.610.000.002443.351732.26
Turner, Rebecca, W,276991155.480.000.000.001155.48
Suarez, Casey,265481322.980.000.00782.99539.99
Zhang, Glenn, A,139675721.910.000.002049.103672.81
Sanz, Rodney,1692644.950.000.000.0044.95
Rodriguez, Rachael, M,119444776.270.003374.99609.96791.32
Sharma, Jerry, C,136516812.120.000.002049.104763.02
She, Susan,199566060.500.003578.270.002482.23
Chandra, Jermaine, A,142995108.760.000.002071.423037.34
Ruiz, Adrienne,1352367.260.000.000.0067.26
Lopez, Francisco, L,1871424.270.000.0021.982.29
Alvarez, Tabitha,150283826.400.000.002071.421754.98
Guo, Don,1874221.980.000.000.0021.98
Shen, Carly,2291513.980.000.000.0013.98
Alvarez, Adrienne, L,17067113.960.000.000.00113.96
Bryant, Madison, J,16481194.910.000.000.00194.91
Alonso, Joanna, M,27862548.980.000.000.00548.98
Subram, Joe,136316817.120.000.002049.104768.02
Andersen, Warren,119198171.520.003374.990.004796.53
Washington, Sydney,289244.990.000.000.004.99
Zhou, Gilbert,244753945.530.000.002181.561763.97
Zheng, Christy,170694426.743578.270.000.00848.47
Zhang, Brittney, W,199756056.610.003578.270.002478.34
Lin, Sandra, A,250522155.920.000.001000.441155.48
Serrano, Tyrone,113605025.800.003399.990.001625.81
Sharma, Arturo,136486765.440.000.002049.104716.34
Alonso, Diana, L,245903911.530.000.002181.561729.97
Rana, Evelyn, D,18262142.450.000.000.00142.45
Yang, Rosa,18713237.260.000.000.00237.26
Alvarez, Albert, R,166245938.253578.270.000.002359.98
Dominguez, Kristi, M,136446864.460.000.002071.424793.04
Lal, Mitchell, C,204037.280.000.000.007.28
Hayes, Edward,1579634.990.000.000.0034.99
Liang, Christy, I,212397.280.000.000.007.28
Zhu, Edwin,2714878.980.000.000.0078.98
Chandra, Cesar, R,202365279.260.003578.270.001700.99
Guo, Margaret,234314158.320.000.002443.351714.97
Xu, Mindy,202466035.600.003578.270.002457.33
Hernandez, Beth, L,29084742.350.000.000.00742.35
Vazquez, Byron,1112242.930.000.007.9534.98
Sun, Leah,177344698.763578.270.000.001120.49
Cox, Catherine, K,131226871.430.000.002071.424800.01
Raji, Kelli, G,131236765.440.000.002049.104716.34
Bailey, Destiny, C,2294158.980.000.000.0058.98
Hernandez, Raquel, W,139974586.350.000.002071.422514.93
Kumar, Cedric, B,228604663.790.000.002181.562482.23
Alvarez, Kendra, R,152672853.580.000.002049.10804.48
Serrano, Neil, L,17076103.460.000.000.00103.46
Hernandez, Ross,1467781.260.000.000.0081.26
Russell, Noah, M,264471938.470.000.00782.991155.48
Bryant, Fernando, M,206096117.690.003578.270.002539.42
Gill, Leslie,146702919.890.000.002071.42848.47
Xu, Trisha,2028237.270.000.000.0037.27
Yang, Alejandro, M,22176100.460.000.000.00100.46
Xie, Nina,12997118.180.000.000.00118.18
Suri, Kari,2526657.980.000.000.0057.98
Gonzalez, Natalie,252152155.920.000.001000.441155.48
Zeng, Warren, R,244773302.050.000.002181.561120.49
Rodriguez, Evelyn,131176831.420.000.002049.104782.32
Miller, Dalton, D,131306797.150.000.002049.104748.05
Raman, Sergio,278662398.050.000.000.002398.05
Collins, Jennifer,113644921.820.003374.990.001546.83
Gao, Susan,274711386.480.000.00782.99603.49
Lal, Bradley,131562663.690.000.002071.42592.27
Diaz, Randall, T,29345574.980.000.000.00574.98
Jai, Lacey, C,1137174.980.000.000.0074.98
Lopez, Mason, E,2292321.980.000.000.0021.98
Ruiz, Alfredo,2197585.480.000.000.0085.48
Kumar, Alejandro,140555177.400.000.002049.103128.30
King, Mackenzie, M,269161322.980.000.00782.99539.99
Johnsen, Ross,19618119.450.000.000.00119.45
Shen, Calvin, W,2614578.980.000.000.0078.98
Xu, Clayton, W,2500149.970.000.000.0049.97
Perez, Brenda,118998189.500.003374.992395.452419.06
Sanz, Meghan, L,28352562.960.000.000.00562.96
Ramos, Eddie, T,13954128.460.000.000.00128.46
Liu, Jenny,1616581.810.000.000.0081.81
Raman, Ronald, M,17077138.450.000.0088.4649.99
Navarro, Bruce, D,173536035.603578.270.000.002457.33
Yuan, Karla, W,136296889.110.000.002049.104840.01
Carlson, Byron,119008257.010.003399.992374.982482.04
Dominguez, Rebekah,278771228.830.000.000.001228.83
Luo, Maurice, C,2749138.980.000.000.0038.98
Raje, Christy,231003007.120.000.002443.35563.77
Suarez, Meghan, L,2217724.270.000.000.0024.27
Hernandez, Erik, C,2199856.980.000.000.0056.98
Lal, Gabriel,274731398.460.000.00782.99615.47
Ma, Darryl, R,1559981.240.000.0049.9731.27
Lopez, Cesar,17500156.960.000.000.00156.96
Zhu, Jessie, D,1266634.560.000.000.0034.56
Ruiz, Julio,110058121.333374.990.004746.340.00
Sharma, Terrence, N,173516117.693578.270.000.002539.42
Yang, Todd, J,190946021.620.003578.272443.350.00
Raji, Misty,165204727.743578.270.001149.470.00
Mehta, Deanna, P,172806089.593578.270.002511.320.00
Beck, Alejandro,110256576.803374.990.002405.47796.34
Pal, Casey,165224698.763578.270.001120.490.00
Torres, Ruben,110028114.043399.990.004714.050.00
Fernandez, Manuel, A,165144761.743578.270.001183.470.00
Arthur, Tabitha, E,164824783.743578.270.001205.470.00
Liang, Martha,165254752.753578.270.001174.480.00
Wu, Kelvin,2459561.960.000.0061.960.00
Suarez, Kristi, D,230992983.340.000.002443.35539.99
Andersen, Willie, M,2797064.470.000.0064.470.00
Rai, Clarence, D,110186533.283399.990.002341.97791.32
Chen, Willie, C,2832229.480.000.0029.480.00
Hu, Glenn, R,248974.990.000.000.004.99
Ramos, Briana, J,143033636.910.000.002894.56742.35
Wang, Trisha, V,172594404.733578.270.000.00826.46
Moreno, Jimmy, L,110296565.293399.990.002408.97756.33
Yuan, Cassie, J,2445360.470.000.000.0060.47
Roberts, Jordan,234324179.330.000.002443.351735.98
Raje, Lindsay, L,206136056.610.003578.270.002478.34
Patel, Monica, J,252342174.920.000.001000.441174.48
Wu, Clarence, L,131156779.420.000.002049.104730.32
Zhu, Dawn,266611912.470.000.00782.991129.48
Diaz, Briana,131316737.150.000.002049.104688.05
Zeng, Barbara,231022730.540.000.002181.56548.98
Chapman, Kathryn,119888078.020.003374.992309.972393.06
Schmidt, Monica,1201273.960.000.008.9964.97
Shen, Shaun,126846893.080.002049.100.004843.98
Price, Megan,249072183.910.000.002183.910.00
Romero, Lawrence, C,166876070.593578.270.002492.320.00
Anand, Kelli, A,204516054.220.003578.270.002475.95
Zhou, Autumn, L,252292155.920.000.001000.441155.48
Ruiz, Bruce, W,16171103.860.000.0032.2871.58
Yuan, Christine,110466616.813374.990.000.003241.82
Hernandez, Diana, F,110386437.333374.990.000.003062.34
Lal, Karla,2521939.980.000.0039.980.00
Martin, Marc, J,110396636.583399.990.000.003236.59
Ward, Brooke,130075671.240.002071.420.003599.82
She, Keith, L,265631957.470.000.00782.991174.48
Nelson, Sophia,166644377.753578.270.00799.480.00
Shan, Mario,252711854.58699.100.000.001155.48
Gomez, Anne,1304562.270.000.0034.9927.28
Lu, Trisha,255551277.56699.100.000.00578.46
Rubio, Jay,151794444.890.000.002071.422373.47
She, Cedric, R,125802589.090.002049.100.00539.99
Raje, Colleen, M,190846093.200.003578.272514.930.00
Xu, Colleen,2895614.980.000.000.0014.98
Suarez, Melody, H,142765259.360.000.002864.912394.45
Xu, Edwin, J,252721873.58699.100.000.001174.48
Ma, Dawn, A,1395682.260.000.000.0082.26
Nath, Michele, L,110568207.503374.990.002413.452419.06
Ma, Cedric, W,11094157.930.000.0029.98127.95
Munoz, Alfredo, C,233142744.520.000.002181.56562.96
Flores, Adam, L,110446515.303374.990.000.003140.31
Romero, Billy,204194.990.000.004.990.00
Torres, Diane, M,2521179.470.000.000.0079.47
Romero, Sabrina, L,28534603.490.000.000.00603.49
Vazquez, Kristi,2834939.980.000.000.0039.98
Sullivan, Dominic, M,2284037.290.000.000.0037.29
Chande, Dale, K,172424387.233578.270.000.00808.96
Ferrier, Linda, D,1314964.970.000.0034.9929.98
Dominguez, Diana, L,292922393.060.000.002393.060.00
Hu, Amy,14320261.950.000.000.00261.95
Moreno, Meghan, J,151524464.570.000.002049.102415.47
Cai, Susan,19101104.420.000.000.00104.42
Perez, Kevin, M,255651239.090.00699.100.00539.99
Nath, Carly, J,172554442.243578.270.000.00863.97
Green, Fernando,172584347.763578.270.000.00769.49
Lal, Shaun, H,170564417.753578.270.000.00839.48
Rodriguez, Sergio, D,15239123.450.000.000.00123.45
Chander, Maurice, L,1408631.270.000.000.0031.27
Sanchez, Olivia, J,14278177.460.000.000.00177.46
Zhao, Rosa, A,1967274.980.000.000.0074.98
Sun, Shannon,120077023.780.003399.991283.822339.97
Navarro, Tyrone, K,255571262.87699.100.000.00563.77
Flores, Noah,172564362.743578.270.000.00784.47
Torres, Dwayne, R,172884426.243578.270.000.00847.97
Wang, Jeffery, E,181886093.203578.270.000.002514.93
Mehta, Nancy,181894118.263578.270.000.00539.99
Rodriguez, Pedro, L,179114698.763578.270.000.001120.49
Lopez, Adriana, A,120028145.330.003374.992357.282413.06
Rodriguez, Donald, L,28351574.980.000.000.00574.98

Generated 2024-09-20 04:08:28.695 UTC