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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Moreno, Robin,195635333.250.003578.270.001754.98
Andersen, Shawna, C,195566035.600.003578.270.002457.33
Rana, Stefanie, K,196165279.260.003578.270.001700.99
Liu, Christy,197846021.620.003578.270.002443.35
Navarro, Casey,197956044.590.003578.270.002466.32
Lin, Edwin,197664167.230.003578.27588.960.00
Alonso, Gloria, S,199646056.610.003578.270.002478.34
Jai, Tasha, A,197714167.230.003578.27588.960.00
Hu, Lacey,199486021.620.003578.270.002443.35
Munoz, Gloria, L,197896058.210.003578.270.002479.94
Romero, Erika,199586056.510.003578.270.002478.24
Liang, Rosa, L,197704127.250.003578.27548.980.00
Gonzalez, Tina,196535314.250.003578.270.001735.98
Tang, Rafael, A,119088079.050.003374.992319.992384.07
Sanchez, Abby, J,199666021.620.003578.270.002443.35
Anand, Niñia, L,199496054.220.003578.270.002475.95
Liu, Trisha, V,202145304.250.003578.270.001725.98
Gutierrez, Orlando,259201819.590.00699.100.001120.49
Arthur, Raymond, S,202286093.200.003578.270.002514.93
Perez, Johnathan, D,204264139.750.003578.27561.480.00
Romero, Marie,204244132.240.003578.27553.970.00
Anand, Kara,119898139.530.003374.990.004764.54
Srini, Veronica,119967058.700.003374.991291.772391.94
Shen, Katie, A,202835314.250.003578.270.001735.98
Martinez, Ethan, C,202605314.250.003578.270.001735.98
Ramos, Alfredo,204566029.570.003578.270.002451.30
Vazquez, Joanna, J,119908164.010.003374.990.004789.02
Russell, Ashley,120008183.000.003399.990.004783.01
Deng, Jodi,161612700.050.000.002049.10650.95
Rubio, Pedro, E,230982745.330.000.002181.56563.77
Zeng, Tiffany, B,2189039.990.000.000.0039.99
Martinez, Heidi, L,2292268.970.000.000.0068.97
Hu, Leah,119948169.030.003374.990.004794.04
Yuan, Deborah,120214043.460.003399.990.00643.47
Raman, Summer, C,259491882.570.00699.100.001183.47
Sai, Frederick,209914118.260.003578.270.00539.99
Taylor, Christopher, E,2117137.290.000.000.0037.29
Lewis, Kayla,120133949.970.003399.99549.980.00
Fernandez, Carolyn, S,2930222.930.000.000.0022.93
Lu, Margaret, D,208144186.230.003578.27607.960.00
Guo, Autumn, A,1421386.260.000.000.0086.26
Ross, Connor, J,208164228.720.003578.27650.450.00
Ye, Steve,29087810.320.000.000.00810.32
Sharma, Clayton, D,122403964.980.003399.990.00564.99
Patel, Virginia, R,1136677.270.000.000.0077.27
Hernandez, Philip,211933905.520.002181.560.001723.96
Nara, Tommy,1672938.920.000.000.0038.92
Green, Jennifer,125712641.390.002071.420.00569.97
Blanco, Philip, M,1560339.970.000.000.0039.97
Yuan, Chad, C,211734659.900.002181.560.002478.34
Raman, Cindy,161574391.410.000.002071.422319.99
Goel, Ricardo, T,259611938.470.00782.990.001155.48
Liang, Amy,161642639.080.000.002049.10589.98
Lu, Willie,211914169.330.002443.350.001725.98
Ramos, Roy, A,244823882.550.000.002181.561700.99
Allen, Luis, C,260191957.470.00782.990.001174.48
Gao, Susan,274711386.480.000.00782.99603.49
Sai, Martin, L,2122129.990.000.000.0029.99
Tang, Nina,274851354.710.000.00782.99571.72
Hernandez, Logan,123506791.750.002071.420.004720.33
Xu, Kristen,157514446.400.000.002071.422374.98
Yang, Tiffany, K,212154624.910.002181.560.002443.35
Prasad, George, C,157674379.090.000.002049.102329.99
Ortega, Alfredo, W,259581903.480.00782.990.001120.49
Gill, Mathew, M,274861371.950.000.00782.99588.96
Lal, Corey, H,233132906.030.000.002181.56724.47
Flores, Connor,157554404.080.000.002049.102354.98
Pal, Sheena, D,211973917.540.002181.560.001735.98
Xu, Dawn,278731249.840.000.001249.840.00
Blanco, Billy,233162835.020.000.002181.56653.46
Raji, Kathryn, C,2199537.290.000.000.0037.29
Chander, Lindsay, R,1997249.700.000.000.0049.70
Suri, Cassandra, B,1871787.210.000.000.0087.21
Shen, Jaclyn, A,125752668.080.002049.100.00618.98
Diaz, Derrick, R,1485337.970.000.000.0037.97
Goel, Mario, J,123606750.480.002071.420.004679.06
Zhang, Dawn, A,1422282.260.000.000.0082.26
Chapman, Clifford, C,211684624.910.002181.560.002443.35
Romero, Roberto, A,18285141.550.000.000.00141.55
Moreno, Casey,2060280.470.000.000.0080.47
Guo, Aimee,1707577.270.000.000.0077.27
Liang, Margaret,17254147.480.000.0093.4953.99
Vance, Phillip,293082438.060.000.000.002438.06
Madan, Terrance,249102183.910.000.001000.441183.47
Zeng, Alisha, A,15727134.460.000.000.00134.46
Sanz, Larry,14067114.960.000.000.00114.96
Huang, Micah,251307.280.000.000.007.28
Gao, Rafael, R,1873324.270.000.002.2921.98
Ramos, Victor, D,242469.990.000.000.009.99
Ramos, Mathew, E,289612478.040.000.000.002478.04
Xu, Peter, K,282042419.060.000.002419.060.00
Vance, Denise, L,212054886.700.002443.350.002443.35
Zeng, Brittney, K,13670178.450.000.0024.49153.96
Nara, Tara,211943911.530.002181.560.001729.97
Gomez, Jill,29315103.960.000.000.00103.96
Navarro, Albert, L,215614947.780.002443.350.002504.43
Ruiz, Kari, L,12695192.970.000.000.00192.97
Parker, Gabriella,213944657.510.002181.560.002475.95
Beck, Derek,1732285.480.000.000.0085.48
Suarez, Pedro, A,246112219.420.001000.441218.980.00
Moreno, Larry, W,282072461.550.000.002461.550.00
Sun, Jamie,213892770.520.002181.560.00588.96
Jimenez, Krista,18257115.950.000.00106.968.99
Jai, Michele, E,212254732.860.002181.560.002551.30
Sharma, Andres, C,2423013.980.000.000.0013.98
Hall, Jesse,261331938.470.00782.990.001155.48
Blanco, Erik, J,2909328.480.000.000.0028.48
Ms., Roy, Lisa, K.,214034895.690.002443.350.002452.34
James, Brooke,1874578.260.000.000.0078.26
Chen, Autumn, I,214084624.910.002181.560.002443.35
Xu, Barbara,1407459.880.000.000.0059.88
Henderson, Cassidy,212283936.540.002181.560.001754.98
Hu, Stacey,12696159.000.000.000.00159.00
Alvarez, Francis,215524624.910.002181.560.002443.35
Sanz, Rodney,1692644.950.000.000.0044.95
Sara, Candace,213802735.530.002181.560.00553.97
Luo, Roger, J,1872856.710.000.000.0056.71
Huang, Colleen, S,213792992.330.002443.350.00548.98
Perez, Marie,1399666.260.000.000.0066.26
Romero, Ricky,213612997.320.002443.350.00553.97
Black, Michele,1399564.970.000.000.0064.97
Sanz, Francis,125772614.080.002049.100.00564.98
Ye, Marshall, R,2655938.980.000.000.0038.98
Ma, Laura, L,245033617.830.000.002443.351174.48
Gomez, Nelson, L,2905338.980.000.000.0038.98
Natsuhara, Tony,230972770.520.000.002181.56588.96
Pal, Gilbert,27744643.950.000.00643.950.00
Xu, Jessie, R,27517539.990.000.000.00539.99
Alexander, Gail, C,14682138.450.000.000.00138.45
Yang, Stacey,142155665.890.000.002049.103616.79
Moreno, Dwayne, T,2310385.480.000.000.0085.48
Raman, Levi,291142384.070.000.000.002384.07
Ortega, Renee,1844721.490.000.000.0021.49
Chander, Alejandro, M,2445575.470.000.000.0075.47
Gill, Mallory, P,16698197.880.000.000.00197.88
Nara, Dale, L,212264659.800.002181.560.002478.24
Sara, Ruben, A,19566164.910.000.000.00164.91
Zhou, Laura, D,126836801.450.002071.420.004730.03
Rana, Molly,2155474.980.000.000.0074.98
Zhu, Candice, S,212194696.490.002181.560.002514.93
Lin, Wesley,2140742.280.000.0042.280.00
Goel, Christine, A,212313936.540.002181.560.001754.98
Sanz, Mathew, L,1455763.970.000.0063.970.00
Chow, Christy, M,126816784.130.002049.100.004735.03
Rowe, Jacquelyn, I,13615146.910.000.007.95138.96
Lal, Kate,215574886.700.002443.350.002443.35
Allen, Logan,1581281.250.000.000.0081.25
Zhang, Aimee,260251917.460.00782.990.001134.47
Morgan, Nathaniel, E,1662671.570.000.0036.5934.98
Garcia, Brandy,260281938.470.00782.990.001155.48
Lu, Ramon, B,1673844.950.000.0013.9830.97
Ms., Rusek, Pearlie, J.,219454886.700.002443.350.002443.35
Alonso, Krista, P,20212100.740.000.000.00100.74
Gonzalez, Ruth,126936820.470.002071.420.004749.05
Raman, Pamela, C,2736978.980.000.000.0078.98
Yang, Darryl, K,215714624.910.002181.560.002443.35
Serrano, Leslie, T,1401462.270.000.000.0062.27
Pal, Mohamed, D,126986786.750.002071.420.004715.33
Sara, Ann, A,2357639.980.000.000.0039.98
Suarez, Brandi,218744638.890.002181.560.002457.33
Suarez, Leslie, C,2295513.980.000.000.0013.98
Raje, Lindsey,246142120.930.001000.441120.490.00
Suarez, Orlando,1112158.160.000.000.0058.16
Long, Emily, L,261401917.460.000.00782.991134.47
Navarro, Kellie, I,218734661.500.000.002181.562479.94
Mehta, Cindy, A,219434624.910.000.002181.562443.35
Garcia, Andre, H,127056854.110.000.002049.104805.01
Suarez, Renee, L,127036891.120.000.002049.104842.02
Gutierrez, Philip, M,219793936.540.000.002181.561754.98
Martinez, Monica, A,141293750.090.000.002049.101700.99
Raman, Frederick, F,289429.990.000.000.009.99
Blanco, Cheryl,135244528.750.000.002071.422457.33
Zhu, Erica,252212143.900.000.001000.441143.46
Hernandez, Leslie, D,129906829.470.000.002071.424758.05
Serrano, Jésus, B,129915641.900.000.002049.103592.80
Liu, Jaclyn,129966808.150.000.002049.104759.05
Sara, Geoffrey,261881938.470.000.00782.991155.48
Hill, Noah,261921903.480.000.00782.991120.49
Kumar, Mindy, R,127006860.440.000.002071.424789.02
Andersen, Drew, K,224123018.330.000.002443.35574.98
Martin, Ruben,224002737.820.000.002181.56556.26
Yuan, Kathryn, L,231063956.010.000.002181.561774.45
Chapman, Jodi, L,229663917.540.000.002181.561735.98
Rana, Meredith,250322184.900.000.001000.441184.46
Zhou, Krystal,235933990.010.000.002181.561808.45
Srini, Douglas, M,1673335.260.000.000.0035.26
Xu, Tony, L,225762721.550.000.002181.56539.99
Lal, Kara,225792730.540.000.002181.56548.98
Fernandez, Arthur, J,223992785.050.000.002181.56603.49
Shen, Kelvin,224063018.330.000.002443.35574.98
Chen, Clarence, R,1514797.450.000.000.0097.45
Diaz, Felicia, J,1502629.980.000.000.0029.98
Gill, Kristy,13669102.430.000.000.00102.43
Lal, Rafael, W,2894568.970.000.000.0068.97
Sanz, Bruce,231173931.520.000.002181.561749.96
Lopez, Stanley, M,289622477.530.000.000.002477.53
Van, Cassandra,135254607.230.000.002071.422535.81
Cai, Amy,249202155.920.000.001000.441155.48
Kapoor, Bryant,229463911.530.000.003911.530.00
Nelson, Carol,135204551.360.000.004551.360.00
Serrano, Lori,17066105.750.000.000.00105.75
Pal, Derek,2459158.980.000.000.0058.98
Griffin, Noah, E,2911873.960.000.000.0073.96
Bradley, Emma,142115662.900.000.002049.103613.80
Chen, Randy,13004190.270.000.000.00190.27
She, Yolanda, M,183042.290.000.000.002.29
Carlson, Armando,17484126.960.000.0021.98104.98
Sara, Marco, L,1564196.750.000.000.0096.75
Madan, Bruce, G,1820665.960.000.000.0065.96
Deng, Tracy, E,2197837.290.000.000.0037.29
Madan, Kristi, I,291842420.340.000.000.002420.34
Pal, Kara,249162169.900.000.001000.441169.46
Lu, Sandra, N,135214514.770.000.004514.770.00
Cox, Nicole, V,229503917.540.000.003917.540.00
Zhou, Heather, M,249142149.910.000.001000.441149.47
Foster, Lucas,135194492.450.000.004492.450.00
Sara, Ebony,249232159.400.000.001000.441158.96
Prasad, Cesar,234113577.820.000.003577.820.00
Lin, Damien, L,234143391.030.000.003391.030.00
Hughes, Lucas, E,266571357.970.000.001357.970.00
Lopez, Carmen, S,135284531.040.000.002071.422459.62
Ortega, Max,234133617.830.000.003617.830.00
Zhu, Dawn,266611912.470.000.00782.991129.48
Raman, César, C,240042744.520.000.002181.56562.96
Guo, Micah, M,241632756.540.000.002181.56574.98
Hu, Susan,252422120.930.000.001000.441120.49
Hill, Aaron,2581835.960.000.000.0035.96
Ashe, Jimmy, S,2895914.980.000.000.0014.98
Dominguez, Sabrina, M,28116617.470.000.000.00617.47
Ramirez, Jessica, R,291922419.060.000.000.002419.06
Taylor, Logan,1352259.980.000.000.0059.98
Deng, Johnny,2140935.000.000.000.0035.00
Liu, Lacey, L,235453882.550.000.002181.561700.99
Serrano, Rebekah,141303814.060.000.002049.101764.96
Ray, Bobby,235753302.050.000.002181.561120.49
Shen, Roger, G,140113831.890.000.003831.890.00
Garcia, Rebekah, M,140073772.410.000.003772.410.00
She, Stacey,267481357.970.000.001357.970.00
Tang, Jenny, E,142105621.240.000.002071.423549.82
Yuan, Ricardo,1667476.150.000.000.0076.15
Alexander, Austin,266731505.760.000.001505.760.00
Munoz, Kendra, S,235293617.830.000.003617.830.00
Hernandez, Ebony, S,235743337.040.000.002181.561155.48
Anand, Alison, J,240092746.040.000.002181.56564.48
Adams, Sydney,2736769.990.000.000.0069.99
Goel, Roger, A,236523907.540.000.002181.561725.98
Cooper, Katherine, R,14314122.950.000.000.00122.95
Munoz, Jimmy, E,2157361.970.000.000.0061.97
Raman, Arthur,240012983.340.000.002443.35539.99
Gill, Carolyn,2309467.930.000.000.0067.93

Generated 2024-11-10 02:34:07.300 UTC