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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Tang, Julie,265891966.460.000.00782.991183.47
Parker, Timothy, C,229434144.340.000.002443.351700.99
Yuan, Carl, P,241603046.840.000.002443.35603.49
Hu, Krystal, D,130127017.440.000.002071.424946.02
Gill, Kellie,1729294.220.000.000.0094.22
Pal, Dale,1845175.470.000.000.0075.47
Vazquez, Francis, E,1728183.970.000.000.0083.97
Jenkins, Anna, M,1723491.260.000.000.0091.26
Kelly, Emma, A,156463804.080.000.002049.101754.98
Lu, Susan, C,1235793.450.000.000.0093.45
Green, Kyle,283284.990.000.000.004.99
Martinez, Brett,235323337.040.000.003337.040.00
Ma, Curtis,28119574.980.000.000.00574.98
Pal, Nina,29297613.450.000.000.00613.45
Hill, Kaylee, L,119188204.990.003399.990.004805.00
Blanco, Hector, J,229384173.320.000.002443.351729.97
Pal, Alison,1304284.470.000.000.0084.47
Vazquez, Craig,28117565.470.000.000.00565.47
Moore, Nathan, N,283232384.070.000.002384.070.00
Kovar, Tabitha,158332611.410.000.002071.42539.99
Lin, Jeffery, J,2734778.980.000.000.0078.98
Lal, Warren, B,2524627.770.000.000.0027.77
Sharma, Tracy,1773123.780.000.000.0023.78
Perry, Madison, R,233084.990.000.000.004.99
Gomez, Carrie,229657.280.000.000.007.28
Sullivan, Toni, M,290833.990.000.000.003.99
Chander, Cassie, M,1825845.950.000.000.0045.95
Collins, Andrea,122503964.980.003399.990.00564.99
Smith, Allen,1407274.980.000.000.0074.98
Munoz, Teresa, R,277121174.480.000.000.001174.48
Carlson, Byron,119008257.010.003399.992374.982482.04
Subram, Kristi, N,15025128.940.000.000.00128.94
Guo, Clarence,2026532.280.000.0032.280.00
Blanco, Rodney, A,201584153.250.003578.27574.980.00
Serrano, Linda,11071110.230.000.0042.2667.97
Smith, Thomas,1706853.990.000.000.0053.99
Chander, Brad, K,2138269.990.000.0069.990.00
Vazquez, Theresa, F,225812749.320.000.002181.56567.76
Jai, Warren, S,164834118.263578.270.000.00539.99
Madan, Jarrod, C,215554715.490.002181.560.002533.93
Ortega, Reginald, K,264291938.470.000.00782.991155.48
Long, Julian,1203472.250.000.000.0072.25
Lewis, Nicole,21881128.970.000.000.00128.97
Deng, Gilbert, C,157654369.090.000.002049.102319.99
Cai, Autumn, O,26163123.980.000.000.00123.98
Hernandez, Danny,2714674.980.000.000.0074.98
Gutierrez, Frank, G,2284674.980.000.0074.980.00
Nara, Priscilla,189074167.230.003578.27588.960.00
Xu, Kelvin, K,212223936.540.002181.560.001754.98
Jai, Karla,18263126.940.000.0034.9991.95
Raje, Darrell,2025269.970.000.000.0069.97
Carlson, Billy, C,19667150.950.000.000.00150.95
Blanco, Leslie, L,276951120.490.000.000.001120.49
Lopez, Clifford, E,27709628.970.000.000.00628.97
Arun, Troy, P,152214447.870.000.002071.422376.45
Stewart, Bryan, M,169284698.763578.270.000.001120.49
Li, Marshall,126876805.470.002071.420.004734.05
She, Lindsay,29456765.320.000.000.00765.32
Fernandez, Holly, M,126756812.770.002071.420.004741.35
Richardson, Abigail, S,142365710.230.000.002071.423638.81
Weber, Ivan,28317539.990.000.000.00539.99
Tang, Sharon, M,1582367.960.000.000.0067.96
Hernandez, Brandi, C,218934663.790.002181.560.002482.23
Rai, Alejandro, R,2199099.470.000.000.0099.47
Lin, Claudia, A,14312191.270.000.00166.2824.99
Nara, Karla, C,258271873.580.00699.100.001174.48
Hernandez, Diana, F,110386437.333374.990.000.003062.34
Yang, Randy, E,240002983.340.000.002443.35539.99
Ramos, Mathew, E,289612478.040.000.000.002478.04
Blanco, Sheila, I,1772436.960.000.000.0036.96
Sara, Ann, A,2357639.980.000.000.0039.98
Alvarez, Max, M,119868245.230.003399.990.004845.24
Lopez, Kristina, L,202476056.610.003578.270.002478.34
She, Alvin, E,166575900.553578.270.000.002322.28
Howard, Jesse, D,242492756.540.000.002181.56574.98
Ye, Martha,222004659.900.000.002181.562478.34
Gutierrez, Armando,293102419.060.000.000.002419.06
Torres, Theresa,212024632.860.002181.560.002451.30
Alonso, Lance, I,1405764.970.000.000.0064.97
Guo, Lisa, S,1731478.960.000.000.0078.96
Blanco, Jésus, E,204486044.590.003578.270.002466.32
Liu, Glenn,188994118.260.003578.27539.990.00
Alonso, Joanna, M,27862548.980.000.000.00548.98
Martinez, Lydia,241692735.530.000.002181.56553.97
Zhu, Erica,252212143.900.000.001000.441143.46
Lopez, Virginia, J,273381339.920.000.00782.99556.93
Andersen, Colin,250532183.910.000.001000.441183.47
Munoz, Jacquelyn,291152407.040.000.000.002407.04
Wang, Crystal, C,111128295.020.003374.990.004920.03
Sharma, Dustin, M,184846093.200.003578.272514.930.00
Lopez, Carmen, S,135284531.040.000.002071.422459.62
Lal, Carl, C,2895044.980.000.000.0044.98
Cai, Suzanne,250512174.920.000.001000.441174.48
Zeng, Amy,242422756.540.000.002181.56574.98
Kapoor, Jay, F,219564632.860.002181.560.002451.30
Chande, Melvin, R,114608137.520.003399.992294.992442.54
Tang, Cristina, D,19623153.930.000.000.00153.93
Yang, Valerie, L,2736169.990.000.000.0069.99
Sai, Emmanuel,234173337.040.000.002181.561155.48
Liang, Tiffany,11068113.360.000.000.00113.36
Chande, Lindsay,182446021.620.003578.272443.350.00
Garcia, Troy, M,292904.990.000.004.990.00
Weber, Jarrod, M,1485931.270.000.0031.270.00
Moreno, Naomi, C,156014429.570.000.002049.102380.47
Sharma, Tony,182416058.210.003578.272479.940.00
Zhang, Willie, T,16023166.890.000.000.00166.89
Shan, Peter,2428027.770.000.000.0027.77
Hu, Kristen, C,197886056.610.003578.270.002478.34
Chen, Louis, J,17059123.960.000.000.00123.96
Andersen, Ashlee, J,11059116.930.000.00116.930.00
Raman, Dominique, D,1302358.980.000.000.0058.98
Zhu, Clarence, A,184624752.750.003578.270.001174.48
Ortega, Linda, C,117568078.020.003374.990.004703.03
Evans, Jackson,1432127.280.000.000.0027.28
Butler, Hannah, R,131115707.200.000.002071.423635.78
Fernandez, Tammy, A,258254.990.000.000.004.99
Xu, Jaclyn,242522744.520.000.002181.56562.96
Navarro, Jaime, T,27690574.980.000.000.00574.98
Jai, Tasha, A,197714167.230.003578.27588.960.00
Ramos, Victor, D,242469.990.000.000.009.99
Navarro, Albert, L,215614947.780.002443.350.002504.43
Huang, Colleen, S,213792992.330.002443.350.00548.98
Raji, Colleen,27707561.480.000.000.00561.48
Dominguez, Robin,166854183.233578.270.000.00604.96
Mehta, Edgar,117618149.490.003399.992356.442393.06
Zheng, Claudia,186916070.590.003578.270.002492.32
Serrano, Mathew, A,29186603.490.000.000.00603.49
Dominguez, Philip,15730122.960.000.000.00122.96
Martin, Briana, L,152132818.590.000.002049.10769.49
Gonzalez, Marco,27598556.260.000.000.00556.26
Nelson, Natalie, C,2292858.980.000.000.0058.98
Moreno, Randall, F,2120939.990.000.000.0039.99
Chavez, Colin,1603290.950.000.0021.9868.97
Yuan, Terry, R,136466843.600.000.002049.104794.50
Zheng, Alisha,222034624.910.000.002181.562443.35
Prasad, Ebony,243683946.520.000.002181.561764.96
Torres, Walter,2678488.970.000.0088.970.00
Li, Cara,275871145.480.000.000.001145.48
Gutierrez, Latasha, C,150222999.910.000.002071.42928.49
Mehta, Brandy,2283939.250.000.0039.250.00
Xu, Kate, R,289572419.060.000.000.002419.06
Rai, Raul, R,151335237.730.000.002071.423166.31
Hughes, Lucas, E,266571357.970.000.001357.970.00
Zhang, Claudia,131146807.450.000.002071.424736.03
Serrano, Dana, S,12678341.430.000.000.00341.43
Martinez, Harold, J,2060493.490.000.000.0093.49
Kapoor, Cynthia,29457756.330.000.000.00756.33
Muñoz, Pedro, A,234333882.550.000.002181.561700.99
Sara, Clifford, M,241782810.530.000.002181.56628.97
Zhao, Bianca,139716772.130.000.002049.104723.03
Jiménez, Brandi,243784173.320.000.002443.351729.97
Gill, Melinda, G,111518087.310.003374.990.004712.32
Serrano, Alberto, L,158004399.080.000.002049.102349.98
Jai, Dylan, J,2312839.980.000.000.0039.98
Diaz, Gerald, M,251187.280.000.000.007.28
Dominguez, Lee, R,245974009.500.000.002181.561827.94
Xu, Shawna,2341939.980.000.000.0039.98
Rai, Melvin, J,246043681.800.000.003681.800.00
Sanchez, Bryant, C,131136832.410.000.002071.424760.99
Ms., Robinson, Dorothy, B.,119528169.000.003374.992395.962398.05
Vazquez, Andy,196205279.260.003578.270.001700.99
Martin, Deanna,130916864.950.000.002071.424793.53
Hernandez, Monique, J,15138123.450.000.0034.9988.46
Lin, Karen,2424348.970.000.000.0048.97
Henderson, Angela, T,118988179.030.003399.990.004779.04
Xie, Michele, M,1503978.960.000.000.0078.96
Rodriguez, Rachael, M,119444776.270.003374.99609.96791.32
Martin, Beth, K,2331739.980.000.000.0039.98
Yang, Colleen,22167123.980.000.00123.980.00
Goel, Alejandro, K,130776766.630.000.002049.104717.53
Chen, Steve, R,189024186.230.003578.27607.960.00
Sai, Evelyn,2041513.980.000.000.0013.98
Carson, Kristin, C,244593961.030.000.002181.561779.47
Perez, Preston,1237061.530.000.002.2959.24
Gao, Jon, C,114568224.460.003399.992391.432433.04
Luo, Darrell, J,2118732.280.000.000.0032.28
Raman, Virginia,2615969.990.000.000.0069.99
Hernandez, Roberto,289232393.060.000.002393.060.00
Shan, Mario,252711854.58699.100.000.001155.48
Dominguez, Darren, M,139666842.120.000.002049.104793.02
Zhou, Jessie,206106021.620.003578.270.002443.35
Andersen, Carl, J,110578088.043374.990.002319.992393.06
Ramos, Briana, J,143033636.910.000.002049.101587.81
Gill, Gary, B,251082199.410.000.001000.441198.97
Sanchez, Lydia, S,125792589.090.002049.100.00539.99
Subram, Cory, B,27599603.490.000.000.00603.49
Deng, Kate, L,157234444.070.000.002049.102394.97
Lin, Jake,242482770.520.000.002181.56588.96
Liu, Suzanne,195946021.620.003578.270.002443.35
Romero, Meredith, J,29452742.350.000.000.00742.35
Gutierrez, Marvin,259381308.060.00699.100.00608.96
Anand, Cassie, M,29342801.830.000.000.00801.83
Raje, Mario, S,204275314.250.003578.270.001735.98
Suarez, Randall, M,28211539.990.000.000.00539.99
Alvarez, Stacy,119018248.010.003399.990.004848.02
Gonzalez, Heidi, Z,1315724.990.000.000.0024.99
Simmons, Jordyn,164945961.203578.270.000.002382.93
Ramos, Lance, S,289492473.050.000.002473.050.00
Simmons, Isabel, H,26432123.980.000.000.00123.98
Collins, James, E,2674269.990.000.000.0069.99
Long, Mariah, C,1673068.970.000.000.0068.97
She, Mindy, J,13009168.670.000.000.00168.67
Yuan, Christine,110466616.813374.990.000.003241.82
Garcia, Donald,189296029.570.003578.270.002451.30
Black, Michele,1399564.970.000.000.0064.97
Kumar, Wayne,175026070.590.003578.270.002492.32
Gonzalez, Francisco, L,122453967.260.003399.990.00567.27
Mehta, Cesar, J,202415347.230.003578.270.001768.96
Xu, Jaclyn, L,126856904.110.002049.100.004855.01
Zhou, Brent,1543432.280.000.000.0032.28
Jimenez, Kathleen,266541346.760.000.001346.760.00
Cooper, Cody, A,160283807.400.000.002071.421735.98
Prasad, Brandy, P,1400963.970.000.000.0063.97
Xie, Chad, A,26155128.970.000.000.00128.97
Malhotra, Ross, R,2930714.980.000.0014.980.00
Liu, Clarence,197976021.620.003578.270.002443.35
Yang, Hunter, E,2023721.490.000.0021.490.00
Luo, Lindsey, R,222015012.270.000.002443.352568.92
Gutierrez, Lawrence, M,195645293.240.003578.270.001714.97
Gonzalez, Tina,196535314.250.003578.270.001735.98
She, Clarence, L,249012174.920.000.002174.920.00
Vazquez, Joanna, J,119908164.010.003374.990.004789.02
Sanchez, Cynthia, S,236623917.540.000.002181.561735.98
Yang, Clarence, D,251212155.920.000.001000.441155.48
Huang, Wesley,2932023.970.000.000.0023.97
Dominguez, Joy,221753018.330.000.002443.35574.98
Nath, Alvin, R,29301134.980.000.000.00134.98
Yuan, Darrell,18271119.950.000.000.00119.95
Lin, Clarence,29069756.330.000.000.00756.33
Vance, Kristopher, C,204074.990.000.000.004.99
Zhang, Warren, L,252521893.05699.100.000.001193.95
Sanchez, Patrick, W,24382143.780.000.000.00143.78
She, Cedric, R,125802589.090.002049.100.00539.99
Hernandez, Bruce,179194733.750.003578.270.001155.48
Li, Luis, K,2025159.470.000.000.0059.47
Deng, Colin, B,1829932.220.000.000.0032.22
Alexander, Austin,266731505.760.000.001505.760.00
Yuan, Grant, C,249092149.910.000.001000.441149.47
Alan, Jamie, S,2122442.280.000.000.0042.28
Rubio, Randall, M,172866029.570.003578.270.002451.30
Raman, Johnathan,1910363.910.000.0041.9321.98
Garcia, Edgar, A,17729110.460.000.000.00110.46
Zhao, Colin, D,242412997.320.000.002443.35553.97
Harris, Thomas,240022744.520.000.002181.56562.96
Serrano, Mallory, E,267511903.480.000.00782.991120.49
Munoz, Cheryl, C,136326838.460.000.002071.424767.04
Chen, Willie, C,2832229.480.000.000.0029.48
Luo, Colin, L,2121039.990.000.000.0039.99
Luo, Roger, J,1872856.710.000.000.0056.71
Vazquez, Jésus,2666578.980.000.000.0078.98

Generated 2024-11-10 06:10:06.065 UTC