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

287 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Allen, Logan,1581281.250.000.000.0081.25
Lu, Ramon, B,1673844.950.000.0013.9830.97
Serrano, Leslie, T,1401462.270.000.000.0062.27
Hernandez, Monique, J,15138123.450.000.0034.9988.46
Perez, Brett, M,28313647.940.000.000.00647.94
Black, Peter, E,2121364.260.000.000.0064.26
Raman, Cindy,161574391.410.000.002071.422319.99
Liang, Amy,161642639.080.000.002049.10589.98
Kumar, Bridget,158024444.070.000.002049.102394.97
Lal, Alicia,157344426.410.000.002071.422354.99
Gutierrez, Kari,157564441.390.000.002071.422369.97
Zeng, Warren, R,244773302.050.000.002181.561120.49
Suri, Mayra, M,157294393.700.000.002071.422322.28
Andersen, Marshall, V,157864366.070.000.002049.102316.97
Raje, Tara, F,28483765.320.000.000.00765.32
Yang, Rosa,18713237.260.000.000.00237.26
Chandra, Carmen, R,2331515.230.000.000.0015.23
Shan, Darrell, J,2734569.990.000.000.0069.99
Sanchez, Manuel,1512686.260.000.0058.9827.28
Cooper, Allison, J,29294553.970.000.000.00553.97
Kapoor, Pedro, H,242297.280.000.000.007.28
Prasad, Edgar, E,17306117.960.000.000.00117.96
Vazquez, Jésus,2666578.980.000.000.0078.98
Lee, Destiny,1705883.980.000.000.0083.98
Rodriguez, Cynthia, E,22206201.280.000.000.00201.28
Saunders, Jillian,2117839.990.000.000.0039.99
Rana, Stanley, J,2291958.980.000.000.0058.98
Zeng, Stacey, J,17317128.950.000.000.00128.95
Xu, Alisha,14100226.260.000.000.00226.26
Shen, Willie, S,1845025.480.000.000.0025.48
Serrano, Diane, E,1485787.970.000.0078.988.99
Goel, Dawn,235354.990.000.000.004.99
Vance, Marco,1312487.930.000.000.0087.93
Cai, Trisha,1826564.980.000.000.0064.98
Sanz, Theodore, M,1649238.980.000.000.0038.98
Suarez, Linda,1666581.810.000.000.0081.81
Taylor, Ashley, E,18215150.970.000.000.00150.97
Anand, Ricardo,2138369.990.000.000.0069.99
Vazquez, Latasha,2195299.470.000.000.0099.47
Hayes, Alexis,13048190.230.000.000.00190.23
Raman, Harold, F,28484778.620.000.000.00778.62
Gutierrez, Francis,2524558.980.000.000.0058.98
Saunders, Ruben, G,27983539.990.000.000.00539.99
Zhang, Ramon, D,12352274.240.000.000.00274.24
Black, Rafael,1196655.760.000.000.0055.76
Zhu, Louis,14858196.970.000.00187.988.99
Torres, Kellie,19569112.240.000.000.00112.24
Prasad, Marco, C,15606115.930.000.0077.9637.97
Tang, Terrence, R,17303123.450.000.000.00123.45
Guo, Aimee,1707577.270.000.000.0077.27
Travers, Danny,1258777.270.000.000.0077.27
Zhang, Susan, S,1821638.920.000.008.9929.93
Wright, Haley,2603688.980.000.000.0088.98
Walker, Austin, F,2022969.970.000.000.0069.97
James, Brooke,1874578.260.000.000.0078.26
Malhotra, Terrance, E,20223187.380.000.000.00187.38
Luo, Nichole, A,2929649.970.000.000.0049.97
Sanchez, Michele,2354312.940.000.000.0012.94
Ye, Brent,2892229.480.000.000.0029.48
Patel, Marco, L,1957560.050.000.0023.7836.27
Vazquez, Ross,11148126.240.000.0053.9972.25
Sharma, Julie, R,1819194.470.000.008.9985.48
West, Nathan,2437067.930.000.000.0067.93
Raji, Sharon,2332939.980.000.000.0039.98
Navarro, Mathew, A,1967337.290.000.000.0037.29
Kapoor, Brett, L,2214769.990.000.000.0069.99
Ramos, Mary, B,1501972.960.000.008.9963.97
Ramos, Paula, W,213764.990.000.000.004.99
Rogers, Seth, R,14318138.450.000.0063.9774.48
Gao, Jake, A,19955173.450.000.000.00173.45
Gutierrez, Joy, A,1846653.990.000.000.0053.99
Sanchez, Levi, A,27745617.470.000.00617.470.00
Hernandez, Victor, T,2353759.980.000.000.0059.98
Guo, Lisa, S,1731478.960.000.000.0078.96
Srini, Candace,154372.290.000.000.002.29
Martinez, Tyler, T,282012419.060.000.002419.060.00
She, Jenny,275861120.490.000.000.001120.49
Morgan, Natalie,1514963.970.000.000.0063.97
Raje, Terry, A,283112393.060.000.002393.060.00
Lu, Christy,1706291.260.000.0091.260.00
Moreno, Melody, R,11760274.920.000.000.00274.92
Carlson, Billy, C,19667150.950.000.000.00150.95
Chande, Raul, L,2117635.000.000.0035.000.00
Johnson, Emma, M,1513662.270.000.0034.9927.28
Malhotra, Ruben, M,1707490.250.000.0058.9831.27
Navarro, Dana, J,1112579.690.000.0047.4232.27
Lopez, Toni, K,2514021.490.000.000.0021.49
Malhotra, Meredith,29314564.480.000.000.00564.48
Moreno, Janet, L,1559259.980.000.0024.9934.99
Xu, Roger,2796839.980.000.0039.980.00
Parker, Mason, W,259236.280.000.006.280.00
Liu, Candice,287202419.060.000.002419.060.00
Xie, Alvin, M,16617160.550.000.0069.9790.58
Sun, Clayton,285334.990.000.004.990.00
Shen, Misty, S,2501923.970.000.000.0023.97
Xie, Dawn,2139129.990.000.0029.990.00
Ramos, Cindy, G,11361114.960.000.000.00114.96
Van, Brenda, J,2489039.980.000.0039.980.00
Ramos, Jaime,1572070.220.000.0035.2334.99
Patel, Bryant, L,27969599.470.000.000.00599.47
Andersen, Calvin,2292091.950.000.000.0091.95
Alonso, Kathleen,2119634.980.000.000.0034.98
Zhu, Wesley, L,1962423.780.000.000.0023.78
Xu, Cristina,2501714.980.000.000.0014.98
Johnston, Joanna, L,1729663.970.000.000.0063.97
Lopez, Kari,15235190.890.000.000.00190.89
Williams, Nicholas, A,2580921.490.000.000.0021.49
Goel, Lacey, N,1870433.260.000.0030.972.29
Zhou, Steve, C,2026321.490.000.000.0021.49
Zhao, Susan, L,2512239.980.000.000.0039.98
Martinez, Clifford,2308739.980.000.000.0039.98
Rodriguez, Dylan, E,1661175.530.000.0042.9332.60
Raji, Nicolas, N,1730174.980.000.000.0074.98
Li, Kristen, R,15153113.970.000.0088.9824.99
Martin, Reginald,14054210.770.000.000.00210.77
Gomez, Marc, J,2188039.990.000.000.0039.99
Lal, Donna,25812113.970.000.000.00113.97
Serrano, Linda,11071110.230.000.0042.2667.97
Raje, Darrell,2025269.970.000.000.0069.97
Black, Russell,1889737.290.000.000.0037.29
Garcia, Tina,1723183.980.000.000.0083.98
Sai, Holly, V,2676937.290.000.000.0037.29
Lopez, Clifford, E,27709628.970.000.000.00628.97
Long, Megan, J,1579142.260.000.0024.9917.27
Romero, Ebony, A,2771712.940.000.000.0012.94
Perez, Preston,1237061.530.000.002.2959.24
Carter, Amber, E,16679106.560.000.0071.5834.98
Navarro, Lori,2118232.280.000.000.0032.28
Sharma, Tracy,1773123.780.000.000.0023.78
Malhotra, Heidi, A,2642669.990.000.000.0069.99
Martin, Casey, J,2296239.980.000.000.0039.98
Bryant, Lauren,11752137.870.000.0077.9659.91
Lu, Darryl,277021155.480.000.000.001155.48
Rana, Ruben,276961183.470.000.000.001183.47
Garcia, Troy, M,292904.990.000.004.990.00
Weber, Jarrod, M,1485931.270.000.0031.270.00
Romero, Jacquelyn,2581539.980.000.0039.980.00
Moore, Nathan, N,283232384.070.000.002384.070.00
Chen, Claudia, R,1662764.880.000.0029.9934.89
Luo, Shaun,278642447.050.000.000.002447.05
Zheng, Randy, B,2257469.990.000.000.0069.99
She, Glenn, L,291179.990.000.000.009.99
Nath, Bethany,16177133.340.000.000.00133.34
Chen, Bianca,248914.990.000.000.004.99
Chen, Louis, J,17059123.960.000.000.00123.96
Goel, Peter, L,1526438.980.000.000.0038.98
Andersen, Roger,2446964.470.000.0064.470.00
Vazquez, Victor, R,29453742.350.000.000.00742.35
Andersen, Ashlee, J,11059116.930.000.00116.930.00
Raman, Rachael,2521679.470.000.000.0079.47
Ruiz, Kristine, J,246074.990.000.000.004.99
Ye, Franklin, L,1395282.260.000.000.0082.26
Blanco, Kristi,1546437.270.000.000.0037.27
Vance, Ruth, D,17302147.440.000.0058.9888.46
Lal, Tommy,1451678.980.000.0024.9953.99
Lal, Nicolas, D,2121274.980.000.0074.980.00
Raman, Allen, R,2512960.470.000.0060.470.00
Raman, Dominique, D,1302358.980.000.000.0058.98
Jimenez, Neil,22151133.490.000.000.00133.49
Flores, Brianna,27706553.970.000.000.00553.97
Chande, Warren,17307132.950.000.00132.950.00
Mehta, Gerald,2023432.280.000.0032.280.00
Kovár, Donald, M,242779.990.000.009.990.00
Chander, Tommy,190862.290.000.002.290.00
Kapoor, Troy, E,2461039.980.000.000.0039.98
Martin, Roy,2206569.990.000.0069.990.00
Torres, Naomi, J,1406182.260.000.0032.2749.99
Dominguez, Ebony, R,17350127.470.000.0034.9992.48
Subram, Martin, S,1959032.280.000.0032.280.00
Romero, Raquel, Z,2291658.980.000.000.0058.98
Gill, Dwayne, A,19675198.990.000.000.00198.99
Gill, Jay,2797583.470.000.000.0083.47
Lu, Todd, D,2426914.980.000.000.0014.98
Gao, Candice, M,17493130.960.000.000.00130.96
Walker, Seth, E,27689539.990.000.000.00539.99
Li, Cedric,2736478.980.000.0078.980.00
Garcia, Chelsea,2196142.280.000.0042.280.00
Nara, Derek, A,2613934.470.000.0034.470.00
Moreno, Tanya,1113983.970.000.000.0083.97
Raji, Colleen,27707561.480.000.000.00561.48
Fernandez, Shane, A,1312786.260.000.000.0086.26
Gutierrez, Dana,2025460.470.000.000.0060.47
Gutierrez, Victor, J,2735769.990.000.000.0069.99
Kapoor, Arthur,2448323.970.000.000.0023.97
Johnson, Brianna, J,1731938.980.000.000.0038.98
Navarro, Jaime, T,27690574.980.000.000.00574.98
Ma, Todd,1958121.490.000.000.0021.49
Malhotra, Marco, L,29459805.330.000.000.00805.33
Vance, Henry,27986553.970.000.000.00553.97
Liang, Alejandro, W,2919349.970.000.000.0049.97
Zhao, Randy, J,278741288.310.000.001288.310.00
Patel, Pamela, G,278751268.840.000.001268.840.00
Yang, Warren, F,1790835.720.000.0035.720.00
Chande, Latoya, M,2330959.980.000.0059.980.00
Evans, Xavier,19098122.240.000.000.00122.24
Martin, Pedro, B,281031214.850.000.000.001214.85
Gao, Laura,2202930.970.000.000.0030.97
Torres, Alfredo,2768574.980.000.000.0074.98
Chandra, Andre, L,2526235.720.000.000.0035.72
Hu, Ramon,2343968.970.000.0068.970.00
Hernandez, Roberto,289232393.060.000.002393.060.00
Martin, Meghan, B,2677369.990.000.0069.990.00
Watson, Adrian, K,13641144.740.000.00117.4627.28
Nara, Jon,2200642.280.000.0042.280.00
Raje, April, R,1874432.220.000.000.0032.22
Jai, Rafael, L,1732384.960.000.000.0084.96
Johnsen, Jerry,2667069.990.000.000.0069.99
Lu, Glenn,12692156.260.000.000.00156.26
Weber, Ivan,28317539.990.000.000.00539.99
Torres, Walter,2678488.970.000.0088.970.00
Anand, Jodi,2612921.490.000.000.0021.49
Morgan, Melissa, M,2022274.450.000.000.0074.45
Malhotra, Arthur, E,2526725.480.000.000.0025.48
Vazquez, Erika, S,229747.280.000.000.007.28
Ruiz, Carolyn, M,27863565.470.000.000.00565.47
Brown, Kaitlyn,2912049.970.000.000.0049.97
Chandra, Rebekah,28486776.330.000.000.00776.33
Alonso, Stacy,28315556.930.000.000.00556.93
Gao, Trisha, A,289532462.550.000.000.002462.55
Alvarez, Rodney, D,2928613.980.000.000.0013.98
Cai, Autumn, O,26163123.980.000.000.00123.98
Hernandez, Isaac,2581326.970.000.000.0026.97
Serrano, Kristine,289402393.060.000.000.002393.06
Wu, Glenn, R,29343553.970.000.000.00553.97
Zhu, Amy, W,26664123.980.000.000.00123.98
Ortega, Armando, K,25223102.960.000.000.00102.96
Zhou, Carol, L,2445421.490.000.000.0021.49
Shan, Franklin, C,2771858.980.000.000.0058.98
Serrano, Gerald, M,275914.990.000.000.004.99
Bryant, Madison, J,16481194.910.000.000.00194.91
Lu, Randy,2644178.980.000.000.0078.98
Zhang, Jon,28111865.310.000.000.00865.31
Navarro, Erik, E,250557.280.000.000.007.28
Gomez, Carrie,229657.280.000.000.007.28
Ma, Jeffery,1826469.970.000.000.0069.97
Nara, Devon, C,21964103.490.000.000.00103.49
Shan, Jenny, W,1670692.970.000.000.0092.97
Zhao, Kristen,169307.950.000.000.007.95
Lopez, Dominic, B,275901189.460.000.000.001189.46
Lal, Mitchell, C,204037.280.000.000.007.28
Van, Brett,26166128.970.000.000.00128.97
Morgan, Melanie,2122726.970.000.000.0026.97
Sullivan, Toni, M,290833.990.000.000.003.99
Sanz, Tabitha,17496110.960.000.000.00110.96
Munoz, Teresa, R,277121174.480.000.000.001174.48
Tang, Ashlee, D,11369118.960.000.000.00118.96
Deng, Arturo, A,281021299.830.000.000.001299.83
Lopez, Mason, E,2292321.980.000.000.0021.98
Williams, Madison, J,2119869.970.000.000.0069.97
Munoz, Gary, D,2023032.280.000.000.0032.28
Chande, Franklin, L,2023291.950.000.000.0091.95
Rana, Johnathan, R,2749737.290.000.000.0037.29
Navarro, Janet, J,28320539.990.000.000.00539.99
Torres, Joanna, E,244644.990.000.000.004.99
Shan, Connor, C,1890135.000.000.000.0035.00
Chande, Casey,2614978.980.000.000.0078.98
Nara, Michele, R,2284286.460.000.000.0086.46
Young, Allison, R,2364439.980.000.000.0039.98
King, Nathan,27719599.470.000.000.00599.47
Travers, Reginald,28488742.350.000.000.00742.35
Liu, Dennis,29062742.350.000.000.00742.35
Alan, Jamie, S,2122442.280.000.000.0042.28
Yuan, Warren, P,190912.290.000.000.002.29
Xu, Kelvin,18305160.550.000.000.00160.55
Wood, Fernando, K,242539.990.000.000.009.99
King, Jesse, J,1466581.260.000.000.0081.26
Nath, Tommy, B,289377.280.000.000.007.28
Fernandez, Marie,289297.280.000.000.007.28
Martin, Jésus,28324548.980.000.000.00548.98
Ma, Louis,2187935.000.000.000.0035.00
Chow, Shannon,1844425.480.000.000.0025.48
Guo, Don,1874221.980.000.000.0021.98
Shen, Carly,2291513.980.000.000.0013.98
Deng, Willie, J,278761214.850.000.000.001214.85
Gao, Eugene,29464756.330.000.000.00756.33
Romero, Joy, D,2488680.470.000.000.0080.47
Dominguez, Gerald, E,2063171.960.000.000.0071.96
Fernandez, Jay,2015559.980.000.000.0059.98
Ramos, Sabrina, L,29082742.350.000.000.00742.35
Vazquez, Krista,2616469.990.000.000.0069.99
Zhang, Roger,126906.280.000.000.006.28
Nath, Dale, B,27343132.970.000.000.00132.97
Raman, Sergio,278662398.050.000.000.002398.05
Ms., Ryan, Justine, J.,230797.280.000.000.007.28
Dominguez, Rebekah,278771228.830.000.000.001228.83
Alonso, Darren,27501578.460.000.000.00578.46
_SUM9051988.22546835.112386860.532383298.863734993.72

Generated 2024-11-10 08:41:46.205 UTC