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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Parker, Mason, W,259236.280.000.006.280.00
Moreno, Beth,219804334.610.000.002443.351891.26
Lopez, Isaac,27692603.490.000.000.00603.49
Luo, Ashlee,235344179.330.000.002443.351735.98
Nath, Carly, J,172554442.243578.270.000.00863.97
Pal, Wayne,1976412.940.000.0012.940.00
Li, Justin,1412457.590.000.000.0057.59
Perez, Kevin, M,255651239.090.00699.100.00539.99
Wood, Julia, L,123566810.130.002049.100.004761.03
Sharma, Mario, J,259281316.050.00699.100.00616.95
Rodriguez, Joel, C,16488119.950.000.00119.950.00
Vazquez, Shannon,2603588.980.000.000.0088.98
Chen, Jon,269201336.960.000.00782.99553.97
Gomez, Andy,187215333.250.003578.270.001754.98
Yang, Martha, G,2221035.000.000.000.0035.00
Zhang, Cara,12351117.970.000.000.00117.97
Zhao, Jamie,1617972.160.000.000.0072.16
Martinez, Holly, B,196286035.600.003578.270.002457.33
Pal, Nichole, J,2674169.990.000.000.0069.99
Gonzales, Alexis,2352121.980.000.000.0021.98
Nelson, Mary, L,131075650.900.000.002049.103601.80
Deng, Michele,219464659.800.002181.560.002478.24
Johnson, Morgan, E,120114735.810.003374.99618.47742.35
Kapoor, Candace,1828230.970.000.0021.988.99
Blanco, Leslie, L,276951120.490.000.000.001120.49
Raje, Grant, S,241623004.830.000.002443.35561.48
Lin, Jorge,2759313.980.000.000.0013.98
Wang, Nathan,140396808.130.000.002049.104759.03
Suarez, Tabitha,2511039.980.000.000.0039.98
Rubio, Pedro, E,230982745.330.000.002181.56563.77
Moreno, Randall, F,2120939.990.000.000.0039.99
Zhao, Colin, D,242412997.320.000.002443.35553.97
Rana, Evelyn, D,18262142.450.000.000.00142.45
Lal, Nicolas, D,2121274.980.000.0074.980.00
Martin, Deanna,130916864.950.000.002071.424793.53
Wang, Rosa, I,119938131.320.003374.990.004756.33
Allen, Mary,212034633.900.002181.560.002452.34
Xu, Kara, E,2221239.990.000.000.0039.99
Sharma, Tony,182416058.210.003578.272479.940.00
Zhu, Jamie, J,1314069.990.000.000.0069.99
Wu, Ernest, L,111478195.500.003374.990.004820.51
Lopez, Summer,1203669.550.000.002.2967.26
Munoz, Gloria, L,197896058.210.003578.270.002479.94
Zhang, Brittney, W,199756056.610.003578.270.002478.34
Xu, Shawna,2341939.980.000.000.0039.98
Hernandez, Melinda,16174140.450.000.000.00140.45
Raman, Pamela, C,2736978.980.000.000.0078.98
Shen, Katrina,158014381.380.000.002049.102332.28
Smith, Allen,1407274.980.000.000.0074.98
Pal, Mitchell, R,167426044.593578.270.002466.320.00
Huang, Wesley,2932023.970.000.000.0023.97
Sanchez, Levi, A,27745617.470.000.00617.470.00
Xu, Alan,167416056.613578.270.000.002478.34
Chander, Maurice, L,1408631.270.000.000.0031.27
Kapoor, Veronica, G,202536035.600.003578.270.002457.33
Raje, Lindsay, L,206136056.610.003578.270.002478.34
Chandra, Virginia, M,2758815.230.000.000.0015.23
Ramos, Eddie, T,13954128.460.000.000.00128.46
Rodriguez, Carolyn,210022992.330.002443.350.00548.98
Ma, Jeffery,1826469.970.000.000.0069.97
Wu, Bianca, F,28485751.340.000.000.00751.34
Ramos, Jay, D,218824886.700.000.002443.352443.35
Yuan, Calvin,1790525.480.000.000.0025.48
Mehta, Deanna, P,172806089.593578.270.000.002511.32
Martin, Arthur, L,2894349.970.000.000.0049.97
Sanz, Theodore, M,1649238.980.000.000.0038.98
Li, Jake, L,1958397.960.000.000.0097.96
Zeng, Barbara,231022730.540.000.002181.56548.98
Mehta, Carla, L,2156339.990.000.0039.990.00
Navarro, Jill,2200356.970.000.000.0056.97
Garcia, Sarah,119078135.330.003399.992297.282438.06
Sanz, Paula,2643069.990.000.000.0069.99
Sullivan, Summer, E,2118132.280.000.000.0032.28
Suri, Molly,1750398.960.000.000.0098.96
Luo, Jerry, M,245864144.340.000.002443.351700.99
Green, Devin, J,264401957.470.000.00782.991174.48
Goel, Dale, M,204164118.260.003578.27539.990.00
Zheng, Edwin, J,142165653.920.000.002049.103604.82
Lal, Rafael, W,2894568.970.000.000.0068.97
Dominguez, Roy, C,2918923.970.000.000.0023.97
Yuan, Christine,110466616.813374.990.000.003241.82
Lin, Bianca,111078171.010.003374.992376.962419.06
Hernandez, Ross,1467781.260.000.000.0081.26
Zeng, Erica,269241350.750.000.00782.99567.76
Chander, Bethany, K,114468237.010.003399.992354.982482.04
Raji, Maurice, C,2061974.980.000.000.0074.98
Andersen, Ashlee, J,11059116.930.000.00116.930.00
Cai, Tiffany,182044133.240.003578.270.00554.97
Li, David, A,218944624.910.000.002181.562443.35
Cox, Catherine, K,131226871.430.000.002071.424800.01
James, Mariah, M,1910430.970.000.000.0030.97
Hernandez, Erik, C,2199856.980.000.000.0056.98
Perez, Molly,259411255.360.00699.100.00556.26
Gomez, Naomi, E,243004144.340.000.002443.351700.99
Townsend, Darren,184675279.260.003578.271700.990.00
Yang, Colin, J,206126060.500.003578.270.002482.23
Srini, Cindy, E,260264.990.000.004.990.00
Ortega, Briana, L,29346567.760.000.000.00567.76
She, Eugene, L,209982806.510.002181.560.00624.95
Sanz, Jamie,265491361.450.000.00782.99578.46
Guo, Randy, L,2295664.470.000.000.0064.47
Gill, Kellie,1729294.220.000.000.0094.22
Alvarez, Mathew, L,17494111.960.000.000.00111.96
Alvarez, Kendra, R,152672853.580.000.002049.10804.48
Navarro, Dana, J,1112579.690.000.0047.4232.27
Jones, Nathan,1502478.960.000.000.0078.96
Gill, Leslie,146702919.890.000.002071.42848.47
Martinez, Anna, J,129946855.440.000.002071.424784.02
Nara, Lindsay, M,252474.990.000.000.004.99
Xie, Casey,212174659.900.002181.560.002478.34
Griffin, Rachel,182556067.200.003578.270.002488.93
Rivera, Mariah,202615314.250.003578.270.001735.98
Barnes, Alexia, D,1523159.480.000.000.0059.48
Sai, Monica, L,29055765.320.000.000.00765.32
Chen, Cedric, R,170654417.753578.270.000.00839.48
Lal, Deborah, T,219823882.550.000.002181.561700.99
Goel, Lacey, N,1870433.260.000.0030.972.29
Simmons, Isabel, H,26432123.980.000.000.00123.98
Dominguez, Raquel, A,274701371.950.000.00782.99588.96
Munoz, Felicia, D,2040659.980.000.000.0059.98
Zhu, Amy, W,26664123.980.000.000.00123.98
Gill, Latasha, M,257131288.060.00699.100.00588.96
Lopez, Patricia,2830529.480.000.000.0029.48
Mr., Spencer, Phil,199606120.110.003578.270.002541.84
Ramos, Audrey,119768087.310.003374.992319.262393.06
Jiménez, Byron,160263804.080.000.002049.101754.98
Moreno, Tabitha,199596056.610.003578.270.002478.34
Gonzalez, Phillip, N,182076089.590.003578.272511.320.00
Zhang, Barbara,16338169.430.000.0058.47110.96
Suri, Patricia, E,154363772.410.000.002071.421700.99
Verhoff, Rob,110088106.313374.990.004731.320.00
Zhu, Jorge,2614178.980.000.0078.980.00
Kapoor, Jarrod,2893015.230.000.000.0015.23
Navarro, Casey,197956044.590.003578.270.002466.32
Moreno, Felicia, A,129876759.470.000.002071.424688.05
Zhang, Louis, K,202276054.220.003578.270.002475.95
Li, Gilbert,239992730.540.000.002181.56548.98
Martinez, Clifford,2308739.980.000.000.0039.98
Johnson, Emma, M,1513662.270.000.0034.9927.28
Anand, Johnny,140585652.520.000.003355.242297.28
Ramos, Danny,231214144.340.000.002443.351700.99
Ward, Shelby,2613239.980.000.0039.980.00
Gutierrez, Latasha, C,150222999.910.000.002071.42928.49
Long, Megan, J,1579142.260.000.0024.9917.27
Gutierrez, Frank, G,2284674.980.000.0074.980.00
Sanchez, Olivia, J,14278177.460.000.000.00177.46
Navarro, Jonathon,187225333.250.003578.271754.980.00
Liu, Glenn,188994118.260.003578.27539.990.00
Xu, Roger,2796839.980.000.0039.980.00
Xie, Ricardo,187106098.580.003578.272520.310.00
Carson, Shaun,111264972.370.003399.990.001572.38
Shen, Priscilla, A,28215589.960.000.000.00589.96
Zhu, Jenny, J,17078186.940.000.00186.940.00
Andersen, Kate,1423790.250.000.000.0090.25
Subram, Ronald, P,27733157.290.000.000.00157.29
Sun, Jorge,160253831.890.000.002071.421760.47
Evans, Adam, H,2582048.970.000.0048.970.00
Vazquez, Lawrence,1963256.980.000.0056.980.00
Scott, Savannah, E,169294733.753578.270.000.001155.48
Pal, Mohamed, D,126986786.750.002071.420.004715.33
Shen, Lindsey,265601396.440.000.00782.99613.45
Xu, Tonya,1732480.940.000.000.0080.94
Ashe, Marshall,2893293.970.000.000.0093.97
Liu, Ronnie,2613021.490.000.000.0021.49
Arthur, Carla,1671091.260.000.000.0091.26
Liang, Jenny, S,27351123.980.000.000.00123.98
Lopez, Clifford, E,27709628.970.000.000.00628.97
Vance, Kristi, T,2833847.970.000.000.0047.97
Goel, Alisha, C,267671331.970.000.00782.99548.98
Alonso, Meredith, M,206216117.690.003578.270.002539.42
Nara, Jaclyn, M,119305035.810.003399.990.001635.82
Sanz, Ricky,182516035.600.003578.272457.330.00
Lu, Candice, I,2120474.980.000.000.0074.98
Goel, Drew,173526021.620.003578.270.002443.35
Ortega, Jill, A,202396093.200.003578.270.002514.93
Fernandez, Manuel, A,165144761.743578.270.001183.470.00
Lopez, Deanna, L,251192148.210.000.001000.441147.77
Zeng, Ramon,279794.990.000.000.004.99
Pal, Christine, I,182426121.710.003578.272543.440.00
Romero, Erika,199586056.510.003578.270.002478.24
Vance, Denise, L,212054886.700.002443.350.002443.35
Serrano, Tabitha,283272407.040.000.002407.040.00
Hernandez, Joan, J,218924921.690.002443.350.002478.34
Serrano, Orlando,195616021.620.003578.270.002443.35
Blanco, Micheal, A,11113109.880.000.00101.937.95
Alvarez, Tabitha,150283826.400.000.002071.421754.98
Patel, Toni, E,258291894.070.00699.100.001194.97
Zeng, Jon, O,143105200.660.000.002071.423129.24
Luo, Lacey,241752743.040.000.002181.56561.48
Garcia, Tina,1723183.980.000.000.0083.98
Prasad, Brandy, P,1400963.970.000.000.0063.97
Gonzalez, Rebekah, A,1692730.970.000.0030.970.00
Zheng, Kristen, J,244633917.540.000.002181.561735.98
Kumar, Tamara, A,252222120.930.000.001000.441120.49
Suarez, Joy, B,1266574.540.000.000.0074.54
Bradley, Emma,142115662.900.000.002049.103613.80
Ashe, Joanna, F,209972744.520.002181.560.00562.96
Zhu, Jessie, D,1266634.560.000.000.0034.56
Carson, Bradley,239952983.340.000.002443.35539.99
Ramos, Naomi, M,236564144.340.000.002443.351700.99
Gao, Todd, M,110618129.023374.990.002369.962384.07
Rodriguez, Harold, M,2118474.980.000.000.0074.98
Yuan, Lacey, W,123496772.140.002049.100.004723.04
Munoz, Gary, D,2023032.280.000.000.0032.28
Shen, Devon, G,2735878.980.000.000.0078.98
Smith, Adriana,187025333.250.003578.271754.980.00
Weber, Ivan,28317539.990.000.000.00539.99
Vazquez, Joanna, J,119908164.010.003374.990.004789.02
Andersen, Shawna, C,195566035.600.003578.270.002457.33
Green, Jonathan, A,173324480.733578.270.000.00902.46
Kumar, Wayne,175026070.590.003578.270.002492.32
Tang, Terrence, R,17303123.450.000.000.00123.45
Chander, Devon,246122152.200.001000.441151.760.00
Raje, Gilbert,110558168.013374.990.002394.972398.05
Deng, Jaime, R,219684722.880.000.002181.562541.32
Vazquez, Marie,218994663.790.002181.560.002482.23
Zhu, Jake, G,2460339.980.000.000.0039.98
Allen, Luis, C,260191957.470.00782.990.001174.48
White, Ashley, D,2188739.990.000.0039.990.00
Flores, Connor,157554404.080.000.002049.102354.98
Kumar, Tommy,17297100.250.000.0037.2762.98
Mehta, Ebony, J,228544659.900.000.002181.562478.34
Gonzalez, Jay, C,142385642.900.000.002049.103593.80
Madan, Carla, D,28135548.980.000.000.00548.98
Ye, Gilbert,29344548.980.000.000.00548.98
Andersen, Maurice,1520698.960.000.000.0098.96
Liang, Rosa, L,197704127.250.003578.27548.980.00
Kapoor, Cynthia,29457756.330.000.000.00756.33
Nath, Grant, A,2894714.980.000.000.0014.98
Jai, Latoya, S,212294198.330.002443.350.001754.98
Zhang, Ronnie,166565930.233578.270.000.002351.96
Rai, Calvin,152292833.570.000.002049.10784.47
Moore, Sarah,289389.990.000.000.009.99
Brown, Kaitlyn,2912049.970.000.000.0049.97
Tang, Shawn,258321850.860.00699.100.001151.76
Gao, Cara, B,156423772.410.000.002071.421700.99
Chen, Willie, C,2832229.480.000.000.0029.48
Jiménez, Orlando, M,21283124.940.000.000.00124.94
Martinez, Ethan, C,202605314.250.003578.270.001735.98
Dominguez, Theresa, L,187695304.250.003578.270.001725.98
Nara, Karl,15142138.460.000.000.00138.46
Ross, Julian,113635035.810.003399.990.001635.82
Nara, Gregory,266511957.470.000.00782.991174.48
Zheng, Rosa, G,166295933.263578.270.000.002354.99
Perez, Kyle, J,161804386.370.000.002049.102337.27
Raji, Karl,291032419.060.000.000.002419.06
Kapoor, Dominic, J,1669967.580.000.000.0067.58
He, Ramon,269191350.750.000.00782.99567.76
Cox, Jared, E,28114570.470.000.00570.470.00
Perez, Joel,166844158.243578.270.000.00579.97

Generated 2024-11-10 05:15:57.685 UTC