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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Yuan, Lacey, W,123496772.140.002049.100.004723.04
Lu, Micah,221743007.830.000.002443.35564.48
Gill, Erika, A,182024143.260.003578.270.00564.99
Prasad, Meagan,196116054.220.003578.270.002475.95
Shan, Jenny, W,1670692.970.000.000.0092.97
Gill, Gerald, A,28487805.330.000.000.00805.33
Liu, Jenny,1616581.810.000.000.0081.81
Hernandez, Wendy, A,15124122.440.000.000.00122.44
Fernandez, George,199746021.620.003578.270.002443.35
She, Alicia, W,1725062.980.000.000.0062.98
Andersen, Deborah,19610118.940.000.000.00118.94
Lal, Mitchell, C,204037.280.000.000.007.28
Hu, Susan,252422120.930.000.001000.441120.49
Li, Marshall,126876805.470.002071.420.004734.05
Arun, Levi, A,1107494.190.000.000.0094.19
Gill, Orlando,2136093.970.000.000.0093.97
Weber, Cynthia,269211336.960.000.00782.99553.97
Alonso, Jerome, H,27977553.970.000.000.00553.97
Hu, Aimee, R,2798139.980.000.0039.980.00
Gao, Curtis, D,204295377.750.003578.270.001799.48
Romero, Philip, F,221954909.670.000.002443.352466.32
Raman, Cindy,161574391.410.000.002071.422319.99
Gutierrez, Desiree,15216101.740.000.0027.2874.46
Hu, Kristen, C,197886056.610.003578.270.002478.34
Serrano, Stacy,246132148.210.001000.441147.770.00
Raji, Sharon,2332939.980.000.000.0039.98
Ashe, Deanna,202845328.230.003578.270.001749.96
Luo, Casey,110728194.000.003399.992395.962398.05
Subram, Ivan, A,2614778.980.000.000.0078.98
Moreno, Diana, J,29298548.980.000.000.00548.98
Lopez, Heidi,110528131.323374.990.002337.272419.06
Gill, Alberto, P,177334758.240.003578.270.001179.97
Black, Russell,1889737.290.000.000.0037.29
Kumar, Colin,2918869.970.000.000.0069.97
Ruiz, Leslie, J,260327.280.000.007.280.00
Young, Marcus, A,184946037.890.003578.272459.620.00
Bailey, Melissa, C,1957282.250.000.000.0082.25
Dominguez, Walter,125762653.070.002049.100.00603.97
Sanchez, Marie,2292490.950.000.0090.950.00
Raman, Levi,291142384.070.000.000.002384.07
Moreno, Casey,2060280.470.000.000.0080.47
Alonso, Meredith, M,206216117.690.003578.270.002539.42
Raji, Christy,1558462.270.000.000.0062.27
Alvarez, Roy, A,16709143.940.000.000.00143.94
Coleman, Dalton, M,234123586.810.000.003586.810.00
Walker, Seth, E,27689539.990.000.000.00539.99
Luo, Jerry, M,245864144.340.000.002443.351700.99
Reed, Steven,2437327.770.000.000.0027.77
Torres, Jacquelyn, P,274646.280.000.000.006.28
Sun, Jorge,160253831.890.000.002071.421760.47
Gonzalez, Veronica, C,233113337.040.000.003337.040.00
Xu, Barbara,1407459.880.000.000.0059.88
Kumar, Karl, J,142185651.880.000.002049.103602.78
Guo, Louis, D,157644413.390.000.002071.422341.97
Zhao, Laura, T,2458968.970.000.0068.970.00
Price, Vanessa, A,2356939.980.000.000.0039.98
Pal, Arturo, P,293032419.060.000.000.002419.06
Wang, Jon, A,261911938.470.000.00782.991155.48
Suri, Marie,242813302.050.000.002181.561120.49
Ruiz, Natasha,219944659.900.000.002181.562478.34
Mehta, Arthur, A,199576035.600.003578.270.002457.33
Anand, Alícia, J,291132453.040.000.000.002453.04
Lal, Darrell,1995325.480.000.000.0025.48
Ye, Claudia, J,191026029.570.003578.270.002451.30
Dominguez, Diana, L,292922393.060.000.000.002393.06
Gonzalez, Carla, J,183366145.070.003578.270.002566.80
Hall, Mary, R,202774.990.000.000.004.99
Liang, Rosa, L,197704127.250.003578.27548.980.00
Li, Crystal, L,143255152.700.000.002049.103103.60
Pal, Sheena, D,211973917.540.002181.560.001735.98
Weber, Cory,1673981.260.000.0031.2749.99
Liang, Christy, I,212397.280.000.000.007.28
Gonzalez, Edgar, A,156483807.400.000.002071.421735.98
Peterson, Allison, A,2642160.470.000.000.0060.47
Kumar, Cristina, N,15426115.920.000.000.00115.92
Goel, Peter, L,1526438.980.000.008.9929.99
Subram, Arthur, E,2735069.990.000.000.0069.99
Dominguez, Kellie, E,1724486.270.000.000.0086.27
Gao, Todd, M,110618129.023374.990.002369.962384.07
Gutierrez, Francis,2524558.980.000.000.0058.98
Guo, Cara, R,15721118.960.000.000.00118.96
Lopez, Manuel, M,140505650.240.000.003295.262354.98
Anderson, Richard, G,249242143.900.000.001000.441143.46
Gao, Bianca, C,131125717.890.000.002049.103668.79
Prasad, Gerald, B,1203581.240.000.0064.9716.27
Chander, Latoya, C,261381957.470.000.00782.991174.48
Chandra, Jermaine, A,142995108.760.000.002071.423037.34
Xie, Cristina, C,170504496.233578.270.000.00917.96
Hernandez, Gina,140495290.680.000.002071.423219.26
Jai, Calvin, S,229184.990.000.000.004.99
Zhou, Laura, D,126836801.450.002071.420.004730.03
Wang, Alan,136226841.430.000.002071.424770.01
Carson, Kristin, C,244593961.030.000.002181.561779.47
Henderson, Isabella, L,2198175.970.000.000.0075.97
Garcia, Darren,2871629.480.000.000.0029.48
Lin, Dawn, N,15805127.470.000.000.00127.47
Sharma, Jodi, N,182606035.600.003578.272457.330.00
Ma, Roger, V,151305215.400.000.002049.103166.30
Ye, Erica, E,130105716.520.000.002071.423645.10
Ortega, Briana, L,29346567.760.000.000.00567.76
Hu, Lacey,199486021.620.003578.270.002443.35
Navarro, Byron,1662236.590.000.000.0036.59
Gill, Carolyn,2309467.930.000.000.0067.93
Sara, Ebony,249232159.400.000.001000.441158.96
Gutierrez, Tabitha, A,2188474.980.000.000.0074.98
Gutierrez, Kristine, G,251332155.920.000.001000.441155.48
Russell, Ashley,120008183.000.003399.990.004783.01
Romero, Frank, M,152092916.560.000.002049.10867.46
Nath, Carly, J,172554442.243578.270.000.00863.97
Li, David, A,218944624.910.000.002181.562443.35
Tang, Julie,265891966.460.000.00782.991183.47
Brown, Kaitlyn,2912049.970.000.000.0049.97
Rubio, Bruce, E,233433936.540.000.002181.561754.98
Carlson, Jonathon, N,1707378.970.000.000.0078.97
Deng, April,111178184.990.003399.992365.942419.06
Munoz, Diane, R,15795132.440.000.000.00132.44
Subram, Kari,12682227.960.000.000.00227.96
Jiménez, Deanna,28115562.960.000.00562.960.00
Suarez, Dana, M,235413337.040.000.002181.561155.48
Alonso, Natasha, L,2500914.980.000.000.0014.98
Shen, Michele,27985539.990.000.000.00539.99
Anand, Jodi,2612921.490.000.000.0021.49
Lin, Margaret, C,1830687.770.000.000.0087.77
Lopez, Donald, A,267401938.470.000.00782.991155.48
Goel, April, C,16166108.850.000.0069.9738.88
Washington, Sydney,289244.990.000.000.004.99
Tang, Grant, H,1146690.190.000.000.0090.19
Hernandez, Krista, J,269181399.940.000.00782.99616.95
Flores, Katherine,211803882.550.002181.560.001700.99
Carlson, Briana,264361957.470.000.00782.991174.48
Zhao, Rosa, A,1967274.980.000.000.0074.98
Harris, Eduardo, S,182386030.610.003578.272452.340.00
Jai, Bonnie,119778212.500.003399.990.004812.51
Smith, Andre,2117442.280.000.000.0042.28
Price, Deb,245023623.320.000.002443.351179.97
Garcia, Edgar, A,17729110.460.000.000.00110.46
Beck, Derek,1732285.480.000.000.0085.48
Li, Colin, J,1844521.490.000.000.0021.49
Malhotra, Arthur, E,2526725.480.000.000.0025.48
Fernandez, Arthur, J,223992785.050.000.002181.56603.49
Goel, Bradley,1580366.260.000.000.0066.26
Shen, Russell, M,11150192.420.000.000.00192.42
Carson, Terrence,113565069.290.003374.990.001694.30
Hernandez, Ebony, S,235743337.040.000.002181.561155.48
Zhou, Jon, L,110608153.023399.990.002319.992433.04
Rivera, Mariah,202615314.250.003578.270.001735.98
Serrano, Reginald, J,130252690.400.000.002071.42618.98
Rana, Stefanie, K,196165279.260.003578.270.001700.99
Morgan, Natalie,1514963.970.000.000.0063.97
Tang, Sharon, M,1582367.960.000.000.0067.96
Cook, Sydney, D,131185669.900.000.002049.103620.80
Raje, Jodi, E,1963074.450.000.000.0074.45
Jiménez, Alberto, C,152154468.560.000.002049.102419.46
Liang, Steve,1431781.260.000.0049.9931.27
Guo, Trisha,1825345.950.000.000.0045.95
Shen, Karla, E,22925134.930.000.000.00134.93
Mr., Schulte, Scot,1580770.570.000.000.0070.57
Lewis, Nicole,21881128.970.000.000.00128.97
Williams, Madison, J,2119869.970.000.000.0069.97
Bhat, Edwin,130796752.130.000.002049.104703.03
Ramos, Marc,182126029.570.003578.272451.300.00
Barnes, Isabella, J,252397.280.000.000.007.28
Martin, Natasha, N,274901331.970.000.00782.99548.98
Lopez, Patricia,2830529.480.000.000.0029.48
Garcia, Dalton, M,187685314.250.003578.270.001735.98
Martin, Byron, E,2521739.980.000.000.0039.98
Zheng, Laura,167014426.743578.270.00848.470.00
Andersen, Nina,183386124.580.003578.270.002546.31
Gonzalez, Virginia,119294965.780.003374.990.001590.79
Zhu, Alisha, G,182396030.610.003578.272452.340.00
Luo, Julie, M,2912169.970.000.000.0069.97
Diaz, Devin, D,15829187.980.000.000.00187.98
Ma, Cara,18885110.460.000.00110.460.00
Patel, Ruben, I,197654132.240.003578.27553.970.00
Gao, Stacey,166624355.713578.270.00777.440.00
Liu, Alejandro, R,195556110.600.003578.270.002532.33
Arthur, Joel,277011155.480.000.000.001155.48
Alexander, Hailey, C,1966635.000.000.000.0035.00
Gutierrez, Darren, A,257141308.060.00699.100.00608.96
Carlson, Jose,1995474.450.000.0060.4713.98
West, James, M,1514890.750.000.000.0090.75
Li, Cara,275871145.480.000.000.001145.48
Vazquez, Erika, S,229747.280.000.000.007.28
Luo, Barbara,2797829.480.000.0029.480.00
Gao, Gilbert,241653046.840.000.002443.35603.49
Liu, Kelli, A,244804175.610.000.002443.351732.26
Alvarez, Janet, G,110068119.033399.990.002334.972384.07
Hu, Glenn, R,248974.990.000.000.004.99
She, Jaime, D,28482777.340.000.000.00777.34
Mehta, Cassandra,2301413.980.000.000.0013.98
Jai, Brad, C,1826764.980.000.0034.9929.99
Alonso, Darren,27501578.460.000.000.00578.46
Malhotra, Emmanuel,183324752.750.003578.270.001174.48
Ferrier, Jenny,219554900.680.002443.350.002457.33
Sharma, Sharon, T,252941882.57699.100.000.001183.47
Goel, Gilbert,155964460.040.000.002049.102410.94
Lal, Alisha, C,2187234.980.000.000.0034.98
Gomez, Hector, A,2933749.990.000.000.0049.99
Tang, Edwin,204506021.620.003578.270.002443.35
He, Louis, E,212114900.680.002443.350.002457.33
Huang, Amy, C,12244114.960.000.0049.9964.97
Hernandez, Danny,2714674.980.000.000.0074.98
Wu, Shannon, F,152682840.910.000.002071.42769.49
Zeng, Curtis, E,26669123.980.000.000.00123.98
Prasad, Denise,1829478.260.000.000.0078.26
Serrano, Lori,17066105.750.000.000.00105.75
Goel, Alicia, H,204234177.740.003578.270.00599.47
Lin, Bianca,111078171.010.003374.992376.962419.06
Raje, Terry, A,283112393.060.000.002393.060.00
Garcia, Jermaine,2156642.280.000.0042.280.00
Williams, Wyatt, E,196146217.210.003578.270.002638.94
Ruiz, Shannon,208224134.530.003578.27556.260.00
Li, Justin,1412457.590.000.000.0057.59
Vazquez, Shannon,2603588.980.000.000.0088.98
Serrano, Kristi,206166093.200.003578.270.002514.93
Andersen, Gilbert, T,273531371.950.000.00782.99588.96
Lal, Shawna,179244733.750.003578.270.001155.48
Becker, Kelli, E,1663371.580.000.000.0071.58
Raji, Carl,195956095.080.003578.270.002516.81
Allen, Devin,15806102.850.000.0038.8863.97
Jiménez, Briana, T,28118588.960.000.000.00588.96
Wu, Warren, M,1560263.970.000.000.0063.97
Hernandez, Isaac,2581326.970.000.000.0026.97
Serrano, Mallory, E,267511903.480.000.00782.991120.49
Navarro, Latasha, L,111008172.510.003374.990.004797.52
Gonzalez, Michele, D,184916056.610.003578.270.002478.34
She, Mindy, J,13009168.670.000.000.00168.67
Mehta, Jay, S,150353772.410.000.002071.421700.99
Torres, Sebastian, V,258311882.570.00699.100.001183.47
Yang, Stacey,142155665.890.000.002049.103616.79
Goel, Shawna, L,29332165.280.000.00165.280.00
Kumar, Alison,212003932.540.002181.560.001750.98
Carlson, Lawrence, L,2206469.990.000.0069.990.00
Raje, Lacey, T,123586787.760.002071.420.004716.34
Gomez, Adrienne,119208156.320.003374.990.004781.33
Hu, Jenny, A,16634106.560.000.000.00106.56
Perry, Madison, R,233084.990.000.000.004.99
Zeng, Dennis, S,130505651.250.000.002071.423579.83
Vazquez, Janet, R,2197356.970.000.000.0056.97
Srini, Deanna,151824391.410.000.002071.422319.99
Lopez, Joe, L,27512539.990.000.000.00539.99
Ward, Jessica,155874423.380.000.002071.422351.96
Lu, Todd, D,2426914.980.000.000.0014.98
Jimenez, Walter,172324347.760.003578.270.00769.49
Raje, Johnny,139755138.720.000.002049.103089.62
Chande, Arturo, H,1486067.260.000.000.0067.26
Alvarez, Adrienne, L,17067113.960.000.000.00113.96
Zheng, Alisha,222034624.910.000.002181.562443.35
Zheng, Arturo, C,1146747.920.000.000.0047.92
Lin, Dennis,161694404.080.000.002049.102354.98

Generated 2024-11-10 03:38:59.911 UTC