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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Zhu, Ernest,201594167.230.003578.27588.960.00
Reed, Riley, A,201574118.260.003578.27539.990.00
Mr., Rovira Diez, Pablo,2119042.280.000.0042.280.00
Lal, Franklin, A,141013679.900.000.002888.58791.32
Ma, Roger, V,151305215.400.000.002049.103166.30
Chandra, Jarrod,241713006.310.000.002443.35562.96
Chow, Christy, M,126816784.130.002049.100.004735.03
Vazquez, Rodney, M,13047241.930.000.000.00241.93
Rubio, Tanya, I,15598167.930.000.000.00167.93
Dominguez, Walter,125762653.070.002049.100.00603.97
Patterson, Melissa, E,126686839.460.002071.420.004768.04
Gao, Jon, C,114568224.460.003399.992391.432433.04
Xu, Cedric, M,24278184.480.000.000.00184.48
Sai, Ruth, D,244613302.050.000.002181.561120.49
Lopez, Summer,1203669.550.000.002.2967.26
Scott, Timothy,196315279.260.003578.270.001700.99
Gill, Hector, M,261871932.460.000.00782.991149.47
Martin, Marc, J,110396636.583399.990.000.003236.59
Shen, Wayne, P,2364712.940.000.000.0012.94
Liu, Jenny,1616581.810.000.000.0081.81
Coleman, Brittany,1557934.980.000.0034.980.00
Patel, Jillian,266671390.950.000.001390.950.00
Gutierrez, Desiree,15216101.740.000.0027.2874.46
Sanchez, Marie,2292490.950.000.0090.950.00
Evans, Adam, H,2582048.970.000.0048.970.00
Martin, Felicia, L,15018112.460.000.00112.460.00
Goel, April, C,16166108.850.000.0069.9738.88
Lin, Darryl, J,1503141.270.000.0032.288.99
Guo, Krystal, S,17381188.930.000.00188.930.00
Flores, Noah,172564362.740.003578.270.00784.47
Long, Julian,1203472.250.000.000.0072.25
Raman, Summer, C,259491882.570.00699.100.001183.47
Perez, Joe, A,143265207.700.000.002071.423136.28
Diaz, Stacy, L,123406752.130.002049.100.004703.03
Rubio, Randall, M,172866029.570.003578.270.002451.30
Sai, Ivan, E,1730094.220.000.000.0094.22
Bailey, Allison,2137769.990.000.000.0069.99
Lal, Devon, L,1523766.260.000.000.0066.26
Rubio, Larry,14223155.940.000.000.00155.94
Navarro, Carolyn,110698104.050.003399.992319.992384.07
Carson, Terrence,113565069.290.003374.990.001694.30
Vazquez, Theresa, F,225812749.320.000.002181.56567.76
Cai, Gilbert, J,1825698.960.000.0063.9734.99
Madan, Summer, D,123476839.120.002049.100.004790.02
Wang, Randy, G,2512568.490.000.000.0068.49
Srini, Jay, M,1832662.980.000.000.0062.98
Hernandez, Danny,2714674.980.000.000.0074.98
Liu, Karen, F,1400863.970.000.0034.9928.98
Lu, Rosa, A,166634471.743578.270.00893.470.00
Tang, Grant, H,1146690.190.000.000.0090.19
Alexander, Gabriel, C,14073156.840.000.0038.88117.96
Gonzalez, Tina,196535314.250.003578.270.001735.98
Shen, Roger, G,140113831.890.000.003831.890.00
She, Valerie, C,202266067.200.003578.270.002488.93
Gonzalez, Shane, Y,141253772.410.000.003772.410.00
Lopez, Carla, G,283262442.540.000.002442.540.00
Wang, Alejandro,173106029.573578.270.000.002451.30
Zhou, Arturo, F,27910574.980.000.00574.980.00
Chander, Drew, J,251112145.920.000.001000.441145.48
Luo, Raul, Q,201544153.250.003578.27574.980.00
Rubio, Robyn, A,184696021.620.003578.272443.350.00
Muñoz, Ruben, L,114518249.490.003399.992366.942482.56
Flores, Miranda,1724383.980.000.0053.9929.99
Jai, Ethan,1521741.260.000.0031.279.99
Gill, Stacy,12679187.980.000.0024.99162.99
Jackson, Joshua,1723583.980.000.000.0083.98
Coleman, Luis, L,142305661.900.000.002049.103612.80
Arun, Ross, C,236583936.540.000.002181.561754.98
Xu, Tracy, L,179164787.740.003578.270.001209.47
Lopez, Mayra, E,273561336.960.000.00782.99553.97
Yang, Stacey,142155665.890.000.002049.103616.79
Malhotra, Joel, E,1634358.250.000.000.0058.25
Gonzalez, Carolyn, H,224072756.540.000.002181.56574.98
Xu, Kathryn,2521023.780.000.000.0023.78
Ruiz, Sabrina, A,2221442.280.000.000.0042.28
Sutton, Kern, A,266601957.470.000.00782.991174.48
Fernandez, Michele, M,2488423.780.000.000.0023.78
Li, Trisha, A,182966117.690.003578.272539.420.00
Raje, Lindsey,246142120.930.001000.441120.490.00
Arthur, Kristi, W,166754385.033578.270.00806.760.00
Shan, Sheena, J,2156548.980.000.0048.980.00
Jai, Jaime, M,248944.990.000.004.990.00
Jai, Brad, C,1826764.980.000.0034.9929.99
Lin, Claudia, A,14312191.270.000.00166.2824.99
Suri, Holly, M,18286141.550.000.0069.9771.58
Hernandez, Clinton,29462854.820.000.000.00854.82
Wu, Aimee,16690165.070.000.000.00165.07
Deng, Casey, C,1967442.280.000.000.0042.28
Raji, Shawna, P,1396149.990.000.000.0049.99
Shan, Colleen, D,151504379.080.000.002049.102329.98
Serrano, Pedro,261891926.450.000.00782.991143.46
Romero, Walter, A,250201549.420.000.001000.44548.98
Ramos, Byron,143063653.230.000.002071.421581.81
Griffin, Grace,114438235.000.003374.990.004860.01
Collins, James, E,2674269.990.000.000.0069.99
Tang, Louis, A,1829239.250.000.000.0039.25
Chow, Warren, L,243053945.530.000.002181.561763.97
Nelson, Julia, L,11102102.910.000.000.00102.91
Arthur, Johnathan,1873036.960.000.000.0036.96
Gill, Lawrence, J,2022444.460.000.000.0044.46
Zheng, Shannon, M,1467849.990.000.0049.990.00
Arthur, Tabitha, E,164824783.743578.270.001205.470.00
Li, Dawn, B,1396240.220.000.0040.220.00
Zhu, Vincent, E,24899105.450.000.00105.450.00
Chander, Marshall,1909059.260.000.002.2956.97
Lal, Julie, A,283092419.060.000.002419.060.00
Wang, Jaclyn, M,17063100.250.000.0037.2762.98
Ramos, Craig,14209193.970.000.004.99188.98
He, Aimee, A,110938180.000.003399.992360.952419.06
Alan, Bob, A,273661322.980.000.00782.99539.99
Andersen, Gilbert, T,273531371.950.000.00782.99588.96
Malhotra, Cynthia,113585034.780.003374.990.001659.79
Rodriguez, Douglas, W,196525314.250.003578.270.001735.98
Yuan, Marshall, P,199786060.500.003578.270.002482.23
Lee, Dalton, J,169314767.733578.270.000.001189.46
Diaz, Megan, A,243034207.320.000.002443.351763.97
Rubio, Philip, P,218764663.380.000.002181.562481.82
Coleman, Paige, L,1526369.970.000.000.0069.97
Vazquez, Francis, E,1728183.970.000.000.0083.97
Chander, Carl,14315109.710.000.000.00109.71
Patel, Arthur, B,2667169.990.000.000.0069.99
Sanchez, Andre,155954369.090.000.002049.102319.99
Shen, Brendan, L,143053652.200.000.002049.101603.10
She, Jeffery, M,2714942.280.000.000.0042.28
Blanco, Krista, L,2758039.980.000.000.0039.98
Guo, Cara, R,15721118.960.000.000.00118.96
Luo, Priscilla, R,1790727.770.000.000.0027.77
Chande, Melvin, R,114608137.520.003399.992294.992442.54
Adams, Savannah,2353639.980.000.000.0039.98
Yang, Martha, G,2221035.000.000.000.0035.00
Alonso, Jonathon, A,1523898.960.000.000.0098.96
Nara, Tonya, C,17251123.960.000.0069.9753.99
Sun, Franklin,196155279.260.003578.270.001700.99
Deng, Clayton, G,172856093.203578.270.000.002514.93
Xu, Tony, L,225762721.550.000.002181.56539.99
Raje, Johnny,139755138.720.000.002049.103089.62
Raman, Veronica, R,1235995.740.000.000.0095.74
Martinez, Jermaine, L,151704391.410.000.002071.422319.99
Xu, Rafael, A,218854641.850.002181.560.002460.29
Liang, Tiffany,11068113.360.000.000.00113.36
Gutierrez, Jaime, A,2522739.980.000.000.0039.98
Alonso, Natasha, L,2500914.980.000.000.0014.98
Jai, Melvin, M,27722564.210.000.000.00564.21
Jiménez, Daisy,219444713.890.002181.560.002532.33
Pal, Drew,1190263.040.000.006.2856.76
Ashe, Kathryn,1616880.110.000.0034.8945.22
Vazquez, Byron,1112242.930.000.007.9534.98
Sharma, Christian,1580962.590.000.0032.6029.99
Guo, Martha, A,2853613.980.000.0013.980.00
Alexander, Hailey, C,1966635.000.000.000.0035.00
Blanco, Kari,1962741.750.000.0027.7713.98
Sanz, Orlando,1430999.470.000.0074.4824.99
Martin, Ebony, F,152234366.410.000.002071.422294.99
Vazquez, Marie,218994663.790.002181.560.002482.23
Carlson, Kristy,282172408.290.000.002408.290.00
Romero, Wendy, H,113724965.810.003374.990.001590.82
Arthur, Jay, R,126946785.130.002049.100.004736.03
Guo, Jamie,201514152.730.003578.27574.460.00
Mrs., Nara, Barbara,12704217.460.000.000.00217.46
Sun, Edwin, O,2117074.980.000.000.0074.98
Gonzalez, Devin,184856063.210.003578.272484.940.00
Gao, Lisa, A,197534.990.000.000.004.99
Madan, Marco,1889527.770.000.0027.770.00
Ye, Leah,110778169.030.003374.992374.982419.06
Alonso, Meghan, A,244573356.040.000.002181.561174.48
Cai, Suzanne,250512174.920.000.001000.441174.48
Washington, Julian, C,2333031.970.000.000.0031.97
Sanchez, Lydia, S,125792589.090.002049.100.00539.99
Munoz, Briana,234374.990.000.000.004.99
Ferrier, Mathew,2342639.980.000.000.0039.98
Lopez, Kristi,281377.280.000.000.007.28
Dominguez, Andy, L,14126135.550.000.0063.9771.58
Shan, Kristin,234163598.830.000.003598.830.00
Mehta, Carla, L,2156339.990.000.0039.990.00
Garcia, Roy, H,155854367.020.000.002049.102317.92
Serrano, Mallory, E,267511903.480.000.00782.991120.49
Lu, Jeffery, B,199716056.610.003578.270.002478.34
Jai, Drew, M,215624632.860.000.002181.562451.30
Sara, Edgar, A,111048173.030.003399.992334.982438.06
Liu, Jessie,111068079.050.003399.992294.992384.07
Sara, Ruben, A,19566164.910.000.000.00164.91
Rana, Raymond,251152155.920.000.001000.441155.48
Rodriguez, Heidi, L,251202155.920.000.001000.441155.48
Alvarez, Randall,267501938.470.000.00782.991155.48
Suri, Arthur,261901932.460.000.00782.991149.47
Becker, Julie,13614114.210.000.000.00114.21
Gao, Rafael, R,1873324.270.000.002.2921.98
Ye, Valerie, C,289482419.060.000.002419.060.00
Raman, Ronald, M,17077138.450.000.0088.4649.99
Campbell, Seth,187166021.620.003578.272443.350.00
Torres, Danielle, G,2294775.970.000.0075.970.00
Yang, Crystal, A,236654207.320.000.002443.351763.97
Suri, Shane, L,251262174.920.000.001000.441174.48
Evans, Mason,154393804.080.000.002049.101754.98
Navarro, Kristine, B,255661253.070.00699.100.00553.97
Mehta, Brett,114508173.260.003374.992370.222428.05
Chander, Cassie, M,1825845.950.000.000.0045.95
Subram, Ross, L,230857.280.000.000.007.28
Guo, Jorge, L,2659069.990.000.000.0069.99
Moreno, Lori, M,152264391.410.000.002071.422319.99
Liu, Krystal, D,135264549.760.000.002071.422478.34
Lal, Shawna,179244733.750.003578.270.001155.48
Garcia, Andre, H,127056854.110.000.002049.104805.01
Zhu, Dawn,266611912.470.000.00782.991129.48
Rodriguez, Arthur,154383788.680.000.002071.421717.26
Kumar, Misty, H,250101540.430.000.001000.44539.99
Ms., Rusek, Pearlie, J.,219454886.700.002443.350.002443.35
Gomez, Derrick,186946035.600.003578.272457.330.00
Beck, Alisha, E,1146347.920.000.007.9539.97
Rana, Jermaine, S,289272419.060.000.002419.060.00
Fernandez, Denise, A,187246056.510.003578.272478.240.00
Munoz, Kendra, S,235293617.830.000.003617.830.00
Martin, Adrienne,1995239.460.000.0025.4813.98
Guo, Randy, L,2295664.470.000.000.0064.47
She, Keith, L,265631957.470.000.00782.991174.48
She, Cedric, R,125802589.090.002049.100.00539.99
Gonzalez, Jay, C,142385642.900.000.002049.103593.80
Chow, Amy, E,126996798.130.002049.100.004749.03
Ma, Dawn, A,1395682.260.000.000.0082.26
Jordan, Ross, F,111248129.020.003399.992309.972419.06
Simmons, Jacqueline, W,13137177.940.000.000.00177.94
Li, Jenny, B,2216978.980.000.000.0078.98
Fernandez, George,199746021.620.003578.270.002443.35
Yang, Clarence, D,251212155.920.000.001000.441155.48
Black, Priscilla,1576662.270.000.0034.9927.28
Prasad, Clifford,1560466.750.000.000.0066.75
Yang, Louis, J,2301312.940.000.000.0012.94
Sandberg, Kristine,122413989.460.003399.990.00589.47
Vazquez, Kristi,2834939.980.000.000.0039.98
Torres, Meghan, I,212563917.540.002181.560.001735.98
Rai, Colleen,2893329.480.000.000.0029.48
Arun, Troy, P,152214447.870.000.002071.422376.45
Alvarez, Erik, M,14311138.450.000.0074.4863.97
Ross, Adam,110998215.990.003399.992363.962452.04
Patterson, Antonio, G,119638068.030.003374.992294.992398.05
Kumar, Tommy,17297100.250.000.0037.2762.98
Srini, Cindy, E,260264.990.000.004.990.00
Zeng, Claudia, M,166964506.763578.270.00928.490.00
Suri, Jillian, L,151804466.390.000.002071.422394.97
Miller, Edward,113685106.240.003374.990.001731.25
Rowe, Jacquelyn, I,13615146.910.000.007.95138.96
Alexander, David,1578398.960.000.000.0098.96
Shen, Leonard, J,242712745.330.000.002181.56563.77
Ramos, Jerome, L,29187588.960.000.000.00588.96
Romero, Mallory,2643469.990.000.000.0069.99
Butler, Jose,29064815.810.000.000.00815.81
Prasad, Candace, S,2214869.990.000.000.0069.99
Moreno, Roy, J,199516021.620.003578.270.002443.35
Perez, Ivan, S,234084218.820.000.002443.351775.47
Zhang, Louis, K,202276054.220.003578.270.002475.95

Generated 2024-11-10 04:07:14.501 UTC