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

287 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Xu, Barbara,1407459.880.000.000.0059.88
Prasad, Denise,1829478.260.000.000.0078.26
Hu, Stacey,12696159.000.000.000.00159.00
Chande, Mindy, V,274721345.950.000.00782.99562.96
Xu, Kristen,157514446.400.000.002071.422374.98
Perez, Kyle, J,161804386.370.000.002049.102337.27
Xu, Dawn,278731249.840.000.001249.840.00
Xu, Terry,2422815.230.000.000.0015.23
Srini, Candace,154372.290.000.000.002.29
Tang, Sharon, M,1582367.960.000.000.0067.96
Black, Michele,1399564.970.000.000.0064.97
Evans, Jackson,1432127.280.000.000.0027.28
Srini, Beth, A,259136.280.000.000.006.28
Ruiz, Alberto, L,2521227.770.000.000.0027.77
Li, Jake, L,1958397.960.000.000.0097.96
Shen, Michele,27985539.990.000.000.00539.99
Xie, Alicia,26427123.980.000.000.00123.98
Malhotra, Meredith,29314564.480.000.000.00564.48
Pal, Gilbert,27744643.950.000.00643.950.00
Long, Angelica, C,282062398.050.000.002398.050.00
Chandra, Virginia, M,2758815.230.000.000.0015.23
Cox, Angel, M,1879330.480.000.000.0030.48
Goel, Chad,2821939.980.000.000.0039.98
Pal, Arturo, P,293032419.060.000.000.002419.06
Jenkins, Anna, M,1723491.260.000.000.0091.26
Patel, Bryant, L,27969599.470.000.000.00599.47
Andersen, Calvin,2292091.950.000.000.0091.95
Lin, Wesley,2140742.280.000.0042.280.00
Butler, Austin, W,1829374.240.000.0074.240.00
Zhou, Steve, C,2026321.490.000.000.0021.49
Vazquez, Carolyn,2365039.980.000.000.0039.98
Hu, Aimee, R,2798139.980.000.0039.980.00
Zhou, Rafael, A,244949.990.000.009.990.00
Li, Alejandro, A,2751978.980.000.000.0078.98
Xu, Roger,2796839.980.000.0039.980.00
Parker, Mason, W,259236.280.000.006.280.00
Gill, Meredith, E,2426849.970.000.000.0049.97
Madan, Joe,293002419.060.000.000.002419.06
Vazquez, Latasha,2195299.470.000.000.0099.47
Raman, Harold, F,28484778.620.000.000.00778.62
Zhao, Kelvin,251357.280.000.000.007.28
Green, Kyle,283284.990.000.000.004.99
Long, Mariah, C,1673068.970.000.000.0068.97
Rodriguez, Toni, J,2525139.980.000.000.0039.98
Sai, Jay, A,234274.990.000.000.004.99
Romero, Ebony, A,2771712.940.000.000.0012.94
Luo, Barbara,2797829.480.000.0029.480.00
Mehta, Brandy,2283939.250.000.0039.250.00
Sara, Phillip, R,2511639.980.000.000.0039.98
Luo, Alison, A,2352756.970.000.000.0056.97
Sai, Monica, L,29055765.320.000.000.00765.32
Navarro, Lori,2118232.280.000.000.0032.28
Nath, Melvin, D,276971120.490.000.000.001120.49
Zhu, Jorge,2614178.980.000.0078.980.00
Ross, Mya, E,277151147.770.000.000.001147.77
Becker, Grant,2139032.280.000.000.0032.28
Bell, Isabella,276981179.970.000.000.001179.97
Martin, Jaime,28316539.990.000.000.00539.99
Zheng, Randy, B,2257469.990.000.000.0069.99
Garcia, Stefanie, E,277431155.480.000.000.001155.48
Kapoor, Jarrod,2893015.230.000.000.0015.23
Chander, Brad, K,2138269.990.000.0069.990.00
Zeng, Wesley,2046021.490.000.0021.490.00
Kelly, Emma, A,156463804.080.000.002049.101754.98
Sanz, Kari, V,273411322.980.000.00782.99539.99
Lopez, Mayra, E,273561336.960.000.00782.99553.97
Cooper, Alex, L,273621407.450.000.00782.99624.46
Sharma, Julie, R,1819194.470.000.008.9985.48
Lal, Warren, B,2524627.770.000.000.0027.77
Alonso, Jerome, H,27977553.970.000.000.00553.97
Guo, Cedric, R,274871322.980.000.00782.99539.99
Munoz, Sheila,274881322.980.000.00782.99539.99
Mr., Schmidt, Steve,157894486.070.000.002049.102436.97
Travers, Alexa, A,244663337.040.000.002181.561155.48
Ruiz, Marie, J,274981350.750.000.00782.99567.76
Allen, Ian, A,160313750.090.000.002049.101700.99
Ms., Sherwood, Irma, J.,245984228.310.000.002443.351784.96
Jenkins, Joan,161554489.570.000.002049.102440.47
Moore, Olivia, A,252312189.900.000.001000.441189.46
Lin, Clayton, M,274921344.910.000.00782.99561.92
Xu, Colin,157902668.380.000.002668.380.00
Huang, Omar, C,1423277.270.000.0049.9927.28
She, Jaime, D,28482777.340.000.000.00777.34
Navarro, Renee,157934369.090.000.002049.102319.99
Tang, Nina,274851354.710.000.00782.99571.72
Dominguez, Raquel, A,274701371.950.000.00782.99588.96
Patel, Abby,160293807.400.000.002071.421735.98
Deng, Gilbert, C,157654369.090.000.002049.102319.99
Davis, Seth, A,163393169.590.000.003169.590.00
Ferrier, Edwin, J,157574366.410.000.002071.422294.99
Hill, Luis,275001371.950.000.00782.99588.96
Shen, Katrina,158014381.380.000.002049.102332.28
Hernandez, Javier, A,161564344.090.000.002049.102294.99
Zeng, Alvin, M,11118115.850.000.000.00115.85
Stone, Mitchell,2501369.970.000.000.0069.97
Kumar, Cristina, N,15426115.920.000.00106.938.99
Zhao, Crystal,259066.280.000.000.006.28
King, Maria, E,282022419.060.000.002419.060.00
Wu, Bianca, F,28485751.340.000.000.00751.34
Black, Shaun, M,1735546.470.000.000.0046.47
Rivera, Jada,2197032.280.000.000.0032.28
Gomez, Victor, I,282032384.070.000.002384.070.00
Sanchez, Levi, A,27745617.470.000.00617.470.00
Xu, Kelsey, W,2822013.980.000.000.0013.98
She, Jenny,275861120.490.000.000.001120.49
Morgan, Natalie,1514963.970.000.000.0063.97
Mehta, Regina,1724592.970.000.000.0092.97
Lin, Kelli, A,2139229.990.000.000.0029.99
Blanco, Wendy, J,19604171.730.000.00147.9523.78
Xu, Colleen, C,18325108.850.000.0038.8869.97
Alonso, Krista, P,20212100.740.000.000.00100.74
Gutierrez, Diana,1967667.970.000.000.0067.97
Raman, Pamela, C,2736978.980.000.000.0078.98
Martinez, Tyler, T,282012419.060.000.002419.060.00
Zhou, Jamie,1732799.940.000.000.0099.94
Pal, Dale,1845175.470.000.000.0075.47
Zhao, Alisha, M,2198835.000.000.000.0035.00
Carlson, Marie,29311603.960.000.000.00603.96
Raje, Jodi, E,1963074.450.000.000.0074.45
Alvarez, Mathew, L,17494111.960.000.000.00111.96
Li, Vincent, D,21207123.960.000.000.00123.96
Ramos, Jaime,1572070.220.000.0035.2334.99
Subram, Kari,12682227.960.000.000.00227.96
Sanz, Arthur,27688166.280.000.00166.280.00
Raje, Terry, A,283112393.060.000.002393.060.00
Malhotra, Ross, R,2930714.980.000.0014.980.00
Vazquez, Janet, R,2197356.970.000.000.0056.97
Jai, Ethan,1521741.260.000.0031.279.99
Zhao, Susan, L,2512239.980.000.000.0039.98
Nara, Lindsay, M,252474.990.000.000.004.99
Zheng, Roger,2932149.970.000.000.0049.97
Serrano, Diane, E,1485787.970.000.0078.988.99
Hill, James, S,293172438.060.000.000.002438.06
Xu, Keith, J,2512464.470.000.000.0064.47
Lopez, Brenda,2659278.980.000.000.0078.98
Torres, Neil,17305196.970.000.00196.970.00
Chande, Raul, L,2117635.000.000.0035.000.00
Gao, Erica, R,1908747.200.000.0047.200.00
Ward, Shelby,2613239.980.000.0039.980.00
Deng, Kurt, D,13635215.740.000.0032.27183.47
Arun, Bryant, C,2045321.490.000.0021.490.00
Andersen, Kelvin, C,2136639.980.000.0039.980.00
Munoz, Marvin,1468049.990.000.000.0049.99
Gill, Stacy,12679187.980.000.0024.99162.99
Dominguez, Andy, L,14126135.550.000.0063.9771.58
Martin, Reginald,14054210.770.000.000.00210.77
Diaz, Vanessa, J,29100102.960.000.000.00102.96
Ortega, Briana, L,29346567.760.000.000.00567.76
Lal, Donna,25812113.970.000.000.00113.97
Blanco, Leslie, L,276951120.490.000.000.001120.49
She, Katie, B,11965118.740.000.0094.2524.49
Serrano, Linda,11071110.230.000.0042.2667.97
Shen, Jodi, A,2202869.990.000.0069.990.00
Ms., Robinson, Rebecca, A.,1191341.260.000.000.0041.26
Jai, Karla,18263126.940.000.0034.9991.95
Zhu, Jenny, J,17078186.940.000.00186.940.00
Sanchez, Clifford,21188123.960.000.000.00123.96
Lopez, Brandy, S,1819999.940.000.000.0099.94
Martin, Casey, J,2296239.980.000.000.0039.98
Ma, Jessie,290926.280.000.000.006.28
Malhotra, Heidi, A,2642669.990.000.000.0069.99
Rai, Rafael, H,18715123.960.000.000.00123.96
Romero, Clinton, F,28132548.980.000.000.00548.98
Zheng, Colleen,13026155.940.000.000.00155.94
Alvarez, Pedro, E,28120539.990.000.000.00539.99
Zhang, Cara,12351117.970.000.000.00117.97
Rana, Ruben,276961183.470.000.000.001183.47
Nara, Tonya, C,17251123.960.000.0069.9753.99
Ma, Cara,18885110.460.000.00110.460.00
Chen, Louis, J,17059123.960.000.000.00123.96
Rana, Terrance, M,28134574.980.000.000.00574.98
Lin, Dawn, N,15805127.470.000.000.00127.47
Martin, Adrienne,1995239.460.000.0025.4813.98
Xu, Cedric, M,24278184.480.000.000.00184.48
Luo, Shaun,278642447.050.000.000.002447.05
Russell, Stephanie,2025575.480.000.0075.480.00
Evans, Adam, H,2582048.970.000.0048.970.00
Martin, Felicia, L,15018112.460.000.00112.460.00
Carter, Amber, E,16679106.560.000.00106.560.00
Ma, Curtis,28119574.980.000.000.00574.98
Lu, Alan,1976167.930.000.000.0067.93
Bailey, Allison,2137769.990.000.000.0069.99
Ashe, Marshall,2893293.970.000.000.0093.97
Evans, Xavier,19098122.240.000.000.00122.24
Deng, Kenneth,2023534.980.000.000.0034.98
Torres, Alfredo,2768574.980.000.000.0074.98
Mr., Schulte, Scot,1580770.570.000.0024.9945.58
Johnsen, Jerry,2667069.990.000.000.0069.99
She, Sharon, F,2201769.990.000.000.0069.99
Flores, Miranda,1724383.980.000.0053.9929.99
Jai, Brendan,26755123.980.000.000.00123.98
Sanz, Sabrina, A,1965042.280.000.000.0042.28
Rai, Shaun,2643123.780.000.000.0023.78
Wu, Warren, M,1560263.970.000.000.0063.97
Jai, Derek, E,13613105.220.000.0027.2877.94
Weber, Jarrod, M,1485931.270.000.0031.270.00
Lopez, Carla, G,283262442.540.000.002442.540.00
Simpson, Tara, K,28107810.320.000.00810.320.00
West, James, M,1514890.750.000.0059.4831.27
Martinez, Ivan,278722393.060.000.000.002393.06
Gonzalez, Rebekah, A,1692730.970.000.0030.970.00
Andersen, Ashlee, J,11059116.930.000.00116.930.00
Gill, Kellie,1729294.220.000.000.0094.22
Li, Dawn, B,1396240.220.000.0040.220.00
Zhu, Vincent, E,24899105.450.000.00105.450.00
Torres, Bailey,1825930.970.000.008.9921.98
Lal, Julie, A,283092419.060.000.002419.060.00
Rana, Cindy,213677.280.000.007.280.00
Wu, Glenn, R,29343553.970.000.000.00553.97
Arthur, Joel,277011155.480.000.000.001155.48
Lu, Randy,2644178.980.000.000.0078.98
Jiménez, Briana, T,28118588.960.000.000.00588.96
Adams, Savannah,2353639.980.000.000.0039.98
Yang, Martha, G,2221035.000.000.000.0035.00
Sun, Todd,2201876.970.000.000.0076.97
Carlson, Joanna,1559434.990.000.000.0034.99
Chande, Warren,17307132.950.000.00132.950.00
Mehta, Gerald,2023432.280.000.0032.280.00
Guo, Martha, A,2853613.980.000.0013.980.00
Sun, Karen, C,282082398.050.000.002398.050.00
Suarez, Gina,2024869.970.000.000.0069.97
Xie, Marshall, M,1979613.980.000.0013.980.00
Munoz, Gary, D,2023032.280.000.000.0032.28
Navarro, Janet, J,28320539.990.000.000.00539.99
Munoz, Teresa, R,277121174.480.000.000.001174.48
Tang, Ashlee, D,11369118.960.000.000.00118.96
Arthur, Carla,1671091.260.000.000.0091.26
Kumar, Gilbert, L,2814039.980.000.000.0039.98
Smith, Kristi, M,2196235.000.000.0035.000.00
Yuan, Franklin,2459439.980.000.0039.980.00
Andersen, Mitchell, H,250266.280.000.006.280.00
Madan, Rachael, R,1648676.970.000.0076.970.00
Shan, Connor, C,1890135.000.000.000.0035.00
Subram, Rebekah,2603021.490.000.000.0021.49
Li, Cedric,2736478.980.000.0078.980.00
Garcia, Chelsea,2196142.280.000.0042.280.00
Torres, Danielle, G,2294775.970.000.0075.970.00
White, Kayla,2642479.470.000.0079.470.00
Henderson, Dalton,248954.990.000.004.990.00
She, Maurice,229174.990.000.004.990.00
Liu, Dennis,29062742.350.000.000.00742.35
Shen, Corey,2673961.970.000.0061.970.00
Powell, Aaron,252414.990.000.000.004.99
Gonzalez, Brandy,27368132.970.000.00132.970.00
King, Jesse, J,1466581.260.000.000.0081.26
Prasad, Candace, S,2214869.990.000.000.0069.99
Chow, Shannon,1844425.480.000.000.0025.48
Johnson, Daniel,1105158.980.000.000.0058.98
Lu, Martha, R,2125532.280.000.0032.280.00
Chandra, Monica, H,1889874.980.000.0074.980.00
Jiménez, Deanna,28115562.960.000.00562.960.00
Patel, Pamela, G,278751268.840.000.001268.840.00
Zhou, Stacey, L,213747.280.000.007.280.00
Tang, Leonard, L,28109778.620.000.00778.620.00
Raje, Karla,289367.280.000.007.280.00
Wu, Arturo, A,28321599.470.000.000.00599.47
Shen, Bonnie,2140574.980.000.000.0074.98
Rubio, Walter, R,2591263.470.000.000.0063.47
Deng, Willie, J,278761214.850.000.000.001214.85
Ramos, Lance, S,289492473.050.000.002473.050.00
Gill, Gerald, A,28487805.330.000.000.00805.33
Zhou, Alan,1648075.970.000.000.0075.97
Chande, Louis, A,1668168.870.000.000.0068.87
Romero, Joy, D,2488680.470.000.000.0080.47
Ramos, Albert, E,277167.280.000.000.007.28
Turner, Savannah, E,234304.990.000.000.004.99
Luo, Darrell, J,2118732.280.000.000.0032.28
Martin, Arthur, L,2894349.970.000.000.0049.97
Becker, Keith, P,27515539.990.000.000.00539.99
Rodriguez, Jonathan, J,1304664.970.000.0029.9834.99
Lu, Jamie, M,2364613.980.000.000.0013.98
Parker, Gabriel,1960683.970.000.0083.970.00
Liu, Ronnie,2613021.490.000.0021.490.00
Zheng, Cara, L,27513563.770.000.000.00563.77
Nath, Dale, B,27343132.970.000.000.00132.97
Hernandez, Marvin, A,230777.280.000.007.280.00
Navarro, Jill,2200356.970.000.000.0056.97
Hernandez, Julio, J,2307815.230.000.000.0015.23
Hernandez, Tabitha, L,1960325.480.000.0025.480.00
Ortega, Armando, K,25223102.960.000.00102.960.00
Wu, Margaret,289282473.050.000.002473.050.00
Mehta, Patricia, K,291792393.060.000.002393.060.00
Liang, Candice,2220842.280.000.0042.280.00
Subram, Arthur, E,2735069.990.000.0069.990.00
Mehta, Marie, L,291022384.070.000.002384.070.00
Wang, Willie,2930423.970.000.0023.970.00
_SUM9051988.22897617.272294723.692701377.523158269.74

Generated 2024-09-20 07:19:47.451 UTC