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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Williams, Alexis, D,14674142.470.000.000.00142.47
Goel, Katie, D,2770864.470.000.000.0064.47
Liu, Warren,150143860.870.000.002071.421789.45
Alexander, Elizabeth,130896800.450.000.002071.424729.03
Rubio, Erika, A,114528183.040.003374.992414.992393.06
Suarez, Billy, M,1728795.260.000.000.0095.26
Lin, Jeffery, J,2734778.980.000.000.0078.98
Gao, Micah, W,251062170.920.000.001000.441170.48
Mehta, Abby, C,2217921.980.000.000.0021.98
Carlson, Jay,202645333.250.003578.270.001754.98
Xie, Kelli, J,204526156.700.003578.270.002578.43
Serrano, Kristi,206166093.200.003578.270.002514.93
Luo, Shawn,122463947.250.003374.990.00572.26
Sun, Shannon,120077023.780.003399.990.003623.79
Vance, Meredith, B,209834178.730.003578.270.00600.46
Sara, Cassandra, D,209894148.740.003578.270.00570.47
Perez, Molly,259411255.360.00699.100.00556.26
Lu, Margaret, D,208144186.230.003578.27607.960.00
Sun, Jenny, L,122534066.930.003399.990.00666.94
Arun, Gerald,259401277.560.00699.100.00578.46
Ms., Seidel, Birgit,1662173.860.000.000.0073.86
Moreno, Roberto, R,212063882.550.002181.560.001700.99
Raje, Cristina, S,179174733.750.003578.270.001155.48
Beck, Alicia, L,172484382.753578.270.000.00804.48
Ortega, Alfredo, W,259581903.480.00782.990.001120.49
Yuan, Lacey, W,123496772.140.002049.100.004723.04
Hu, Jenny, A,16634106.560.000.000.00106.56
Raman, Abby, T,151225193.720.000.002071.423122.30
Xu, Lacey, S,179134733.750.003578.270.001155.48
Rubio, Kristy,122433914.980.003374.990.00539.99
Green, Jennifer,125712641.390.002071.420.00569.97
Kumar, Katie, P,123416840.620.002049.100.004791.52
Huang, Crystal, L,260231917.460.00782.990.001134.47
Pal, Sheena, D,211973917.540.002181.560.001735.98
Gutierrez, Clinton,210013018.330.002443.350.00574.98
Goel, Mario, J,123606750.480.002071.420.004679.06
Ashe, Joanna, F,209972744.520.002181.560.00562.96
She, Corey, T,212144659.900.002181.560.002478.34
Nath, Cassie,246062155.920.001000.441155.480.00
Liang, Vincent,204024.990.000.000.004.99
Kapoor, Abby, J,29054751.340.000.000.00751.34
Gao, Jamie,260221938.470.00782.990.001155.48
Wood, Maria,126676813.120.002049.100.004764.02
Arun, Candace, J,213934925.170.002443.350.002481.82
Hernandez, Kellie, A,125862636.410.002071.420.00564.99
Serrano, Gloria, G,215564930.680.002443.350.002487.33
Liu, Cedric,126776785.470.002071.420.004714.05
Jai, Michele, E,212254732.860.002181.560.002551.30
Vazquez, Danny, J,260331903.480.00782.990.001120.49
Ms., Roy, Lisa, K.,214034895.690.002443.350.002452.34
Chapman, Alicia, A,214184659.900.002181.560.002478.34
Alvarez, Francis,215524624.910.002181.560.002443.35
Sara, Candace,213802735.530.002181.560.00553.97
Xu, Kelvin, K,212223936.540.002181.560.001754.98
Sanz, Francis,125772614.080.002049.100.00564.98
Gonzalez, Joel, A,150433846.890.000.002071.421775.47
Zeng, Amy,242422756.540.000.002181.56574.98
Raji, Wayne, A,261611903.480.000.00782.991120.49
Munoz, Robyn,142145759.870.000.002049.103710.77
Ruiz, Marie, J,274981350.750.000.00782.99567.76
Gill, Kellie,1729294.220.000.000.0094.22
Patel, Gerald,230954.990.000.000.004.99
Hernandez, Melinda,16174140.450.000.000.00140.45
Raji, Brad, C,234093917.540.000.002181.561735.98
Chander, Devon,246122152.200.001000.441151.760.00
Madan, Michele, A,126766859.460.002071.420.004788.04
Lopez, Kristopher, L,215604702.390.002181.560.002520.83
Madan, Jarrod, C,215554715.490.002181.560.002533.93
King, Kevin, W,214024624.910.002181.560.002443.35
Zhu, Candice, S,212194696.490.002181.560.002514.93
Vazquez, Roy,260291930.760.00782.990.001147.77
Garcia, Brandy,260281938.470.00782.990.001155.48
Sun, Micah,248872218.900.001000.441218.460.00
Deng, Michele,219464659.800.002181.560.002478.24
Romero, Gina,142345687.720.000.002071.423616.30
Nath, Carly, J,172554442.243578.270.000.00863.97
Browning, Jay, M,242512983.340.000.002443.35539.99
Lal, Sheena,2331213.980.000.000.0013.98
Xu, Tasha, E,1194882.260.000.000.0082.26
Zhou, Clayton,273481382.460.000.00782.99599.47
Nara, Rafael, J,1705296.920.000.000.0096.92
Martin, Anne, V,250342164.910.000.001000.441164.47
Xu, Clarence,218774624.910.002181.560.002443.35
Nara, Dawn, M,218914921.690.002443.350.002478.34
Li, Marshall,126876805.470.002071.420.004734.05
Sun, Erica, P,261351967.450.00782.990.001184.46
Madan, Cory,261541938.470.00782.990.001155.48
Long, Emily, L,261401917.460.000.00782.991134.47
Navarro, Kellie, I,218734661.500.000.002181.562479.94
Pal, Tamara,126896846.920.000.002071.424775.50
Rai, Brendan, A,215694960.160.000.002443.352516.81
Blanco, Mallory,219584696.490.000.002181.562514.93
Rana, Nancy, H,261501992.460.000.00782.991209.47
Li, David, A,218944624.910.000.002181.562443.35
Dominguez, Micheal,261421952.450.000.00782.991169.46
Subram, Francisco, A,218974909.670.000.002443.352466.32
She, Kelli, J,248892269.910.000.002269.910.00
Ramos, Jay, D,218824886.700.000.002443.352443.35
Goel, Carly, C,129896817.120.000.002049.104768.02
Ma, Rafael, T,130222644.020.000.002049.10594.92
Torres, Jacqueline,219764198.330.000.002443.351754.98
Martinez, Cynthia,221702745.330.000.002181.56563.77
Murphy, Jill, J,249022120.930.000.001000.441120.49
Ortega, Shannon,263751971.450.000.00782.991188.46
Fernandez, Ivan,220323882.550.000.002181.561700.99
Cai, Bianca, D,221732735.530.000.002181.56553.97
Subram, Virginia,130362677.070.000.002049.10627.97
Chandra, Cynthia,220004663.790.000.002181.562482.23
Hernandez, Frank, G,221984661.500.000.002181.562479.94
Gao, Christy, D,262041967.450.000.00782.991184.46
Deng, Jaime, R,219684722.880.000.002181.562541.32
Suarez, Kristy,219844175.610.000.002443.351732.26
Romero, Francis,221964632.860.000.002181.562451.30
Lee, David, J,221994693.880.000.002181.562512.32
Ortega, Anne,130116819.110.000.002049.104770.01
Perez, Ebony, M,249002155.920.000.002155.920.00
Lal, Deborah, T,219823882.550.000.002181.561700.99
Kumar, Mindy, R,127006860.440.000.002071.424789.02
Garcia, Toni,221934886.700.000.002443.352443.35
Wang, Jon, A,261911938.470.000.00782.991155.48
Garcia, Martin, l,233324144.340.000.002443.351700.99
Lin, Bianca,111078171.010.003374.992376.962419.06
Martin, Deanna,130916864.950.000.002071.424793.53
Anderson, Blake,110768159.040.003399.992374.982384.07
Diaz, Cheryl, A,110928110.020.003374.992341.972393.06
Martinez, Virginia,1313662.270.000.000.0062.27
Pal, Mindy,1909724.270.000.000.0024.27
Ramos, Marie, A,143085140.400.000.002049.103091.30
Moreno, Randall, F,2120939.990.000.000.0039.99
Cai, Steve, M,2215569.990.000.000.0069.99
Stone, Brenda, J,12697296.190.000.000.00296.19
Zeng, Suzanne,179184733.750.003578.270.001155.48
Alvarez, Jessie,143245121.430.000.002049.103072.33
Carlson, Audrey, A,2526360.470.000.000.0060.47
Nara, Kelsey, A,249052195.910.000.001000.441195.47
Diaz, Roberto, A,222024671.740.000.002181.562490.18
Rubio, Nelson,264331903.480.000.00782.991120.49
Mehta, Ebony, J,228544659.900.000.002181.562478.34
Shen, Mitchell, M,229044759.990.000.002181.562578.43
She, Kathryn, I,264431938.470.000.00782.991155.48
Munoz, Theresa, M,139536840.750.000.002071.424769.33
Cooper, Victoria, S,136376777.130.000.002049.104728.03
Wang, Curtis, A,131085718.660.000.002071.423647.24
Nara, Clayton,117688139.040.003399.992319.992419.06
Perez, Ross, E,14307196.260.000.00159.0037.26
Andersen, Willie, M,2797064.470.000.000.0064.47
Madan, Toni,26668119.980.000.000.00119.98
Xie, Dustin,2220442.280.000.000.0042.28
Chen, Willie, C,2832229.480.000.000.0029.48
Lin, Kelvin, A,130756843.940.000.002071.424772.52
Hu, Glenn, R,248974.990.000.000.004.99
Brown, Cameron, D,13041153.950.000.000.00153.95
Ramos, Briana, J,143033636.910.000.002049.101587.81
Shen, Russell, M,11150192.420.000.000.00192.42
Patel, Monica, J,252342174.920.000.001000.441174.48
Serrano, Max, E,120108203.500.003374.990.004828.51
Chapman, Kathryn,119888078.020.003374.990.004703.03
Alexander, Olivia, L,146675295.410.000.002049.103246.31
Shen, Shaun,126846893.080.002049.100.004843.98
Allen, Hailey, C,26759123.980.000.000.00123.98
Suri, Roy, M,1725353.990.000.000.0053.99
Liu, Autumn, J,209854118.260.003578.270.00539.99
Martinez, Emmanuel, V,2137039.980.000.000.0039.98
Shen, Nichole,129996840.460.000.002071.424769.04
Zheng, Jeffery, W,150303786.390.000.002071.421714.97
Price, Megan,249072183.910.000.001000.441183.47
Anand, Kelli, A,204516054.220.003578.270.002475.95
Rodriguez, Allen, L,177324752.750.003578.270.001174.48
Zhu, Gilbert,1192163.240.000.000.0063.24
Diaz, Samuel,140655608.550.000.002071.423537.13
Zheng, Arturo, C,1146747.920.000.000.0047.92
Andersen, Maurice,1520698.960.000.000.0098.96
Rodriguez, Jarrod,136366831.760.000.002071.424760.34
Prasad, Darren,1237299.030.000.000.0099.03
Romero, Latasha,142205696.190.000.002071.423624.77
Gutierrez, Meghan, E,260211917.460.00782.990.001134.47
Shan, Peter,2428027.770.000.000.0027.77
Jimenez, Jacquelyn,143043595.930.000.002049.101546.83
Cai, Cedric,195596056.610.003578.270.002478.34
Griffin, Brianna, K,1648773.240.000.000.0073.24
Evans, Carlos, J,235384198.330.000.002443.351754.98
Ma, Cedric, W,11094157.930.000.000.00157.93
Romero, Billy,204194.990.000.000.004.99
Young, Morgan, L,123426838.120.002049.100.004789.02
Hu, Dennis, J,206006056.610.003578.270.002478.34
Moreno, Beth,219804334.610.000.002443.351891.26
Patel, Janelle, T,2911617.270.000.000.0017.27
Patel, Kaitlin, L,1661595.840.000.000.0095.84
Goel, Barbara,129886915.440.000.002049.104866.34
Chander, Maurice, L,1408631.270.000.000.0031.27
Goldstein, Dustin,123378137.010.003399.990.004737.02
Martin, Ethan, M,13998245.250.000.0097.97147.28
Chander, Yolanda,165194752.753578.270.000.001174.48
Zhao, Rosa, A,1967274.980.000.000.0074.98
Vazquez, Shannon,2603588.980.000.000.0088.98
Gonzalez, Ivan, C,1962552.770.000.000.0052.77
Nath, Katie, A,234343882.550.000.002181.561700.99
Pal, Alison,1304284.470.000.000.0084.47
Andersen, Jenny,202596029.570.003578.270.002451.30
Martinez, Meredith, M,190956056.610.003578.270.002478.34
Russell, Ashley,120008183.000.003399.990.004783.01
Shen, Karl, M,151514344.090.000.002049.102294.99
Hill, Noah,261921903.480.000.00782.991120.49
Rodriguez, Donald, L,28351574.980.000.000.00574.98
Zhang, Aimee,260251917.460.00782.990.001134.47
Lopez, Adriana, A,120028145.330.003374.990.004770.34
Liang, Colin,13639188.960.000.003.99184.97
Moreno, Casey,2060280.470.000.000.0080.47
Ma, Warren, A,1976248.970.000.000.0048.97
Allen, Alexandra, B,172934417.750.003578.270.00839.48
Liang, Margaret,17254147.480.000.0093.4953.99
Alvarez, Tanya,172796021.620.003578.270.002443.35
Serrano, Orlando,195616021.620.003578.270.002443.35
Anand, Kara,119898139.530.003374.990.004764.54
Sanz, Reginald, K,1752274.950.000.000.0074.95
Cai, Roger, A,13002294.940.000.00167.99126.95
Chapman, Patricia,120377107.100.003374.990.003732.11
Mehta, Cesar, J,202415347.230.003578.270.001768.96
Madan, Terrance,249102183.910.000.001000.441183.47
Pal, Clayton,27721166.280.000.000.00166.28
Lal, Kurt, R,1401559.980.000.000.0059.98
Perez, Janelle,16172186.040.000.000.00186.04
Raje, Shawn,1705483.980.000.000.0083.98
Raji, Bradley, E,179254698.760.003578.270.001120.49
Garcia, Sarah,119078135.330.003399.992297.282438.06
Chander, Latoya, C,261381957.470.000.00782.991174.48
Alonso, Casey, E,234223911.530.000.002181.561729.97
Lu, Trisha,255551277.56699.100.000.00578.46
Zhang, Willie, T,16023166.890.000.000.00166.89
Xu, Arturo,136196808.100.000.002049.104759.00
Ramos, Mathew, E,289612478.040.000.000.002478.04
Suarez, Brandi,218744638.890.002181.560.002457.33
Vazquez, Jimmy, D,123486906.090.002049.100.004856.99
Martinez, Sarah, S,126706785.130.002049.100.004736.03
Ruiz, Danny,2445621.490.000.000.0021.49
Alonso, Ricky, S,140705618.930.000.002049.103569.83
Lin, Margaret, C,1830687.770.000.000.0087.77
Bhat, Yolanda,152254401.410.000.002071.422329.99
Malhotra, Cory, E,179234752.750.003578.270.001174.48
Zhu, Jamie, J,1314069.990.000.000.0069.99
Ms., Sandidge, Mary, R.,14016121.060.000.000.00121.06
Martin, Craig, M,2501274.460.000.000.0074.46
Liang, Dennis,14034104.240.000.000.00104.24
Smith, Allen,1407274.980.000.000.0074.98
Guo, Sandra,236643941.530.000.002181.561759.97
Moreno, Diana, J,29298548.980.000.000.00548.98
Shan, Bethany, L,139735185.680.000.002071.423114.26
Chander, Roger,252142149.910.000.001000.441149.47
Xu, Cedric,181984143.250.003578.270.00564.98
Kumar, Kurt, L,2736069.990.000.000.0069.99

Generated 2024-11-10 05:21:15.205 UTC