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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Zhang, Alejandro, P,21992184.260.000.000.00184.26
Huang, Barbara,264421919.750.000.00782.991136.76
Tang, Ashlee, D,11369118.960.000.000.00118.96
Rivera, Evan, Y,267571344.470.000.00782.99561.48
Rodriguez, Arthur,154383788.680.000.002071.421717.26
Hu, Valerie, M,150443803.560.000.002049.101754.46
Rubio, Larry,14223155.940.000.000.00155.94
Yuan, Franklin,2459439.980.000.0039.980.00
Li, Stacey,140645694.210.000.002071.423622.79
Anand, Kelli, A,204516054.220.003578.270.002475.95
Williams, Nicholas, A,2580921.490.000.000.0021.49
Gomez, Kathleen, J,161584369.090.000.002049.102319.99
Kim, Kari, S,114458098.030.003399.992304.982393.06
Zheng, Jamie, L,2215669.990.000.0069.990.00
Shan, Eric, L,2677169.990.000.0069.990.00
Gray, Jeremiah,233314144.340.000.002443.351700.99
Nath, Rafael,235333917.540.000.002181.561735.98
Lin, Jaclyn,2872139.980.000.000.0039.98
Weber, Ivan,28317539.990.000.000.00539.99
Zhou, Ernest, P,157922645.400.000.002071.42573.98
Madan, Kristopher, A,252387.280.000.000.007.28
Oliver, Lee,2911969.970.000.000.0069.97
Suarez, Brandi,218744638.890.002181.560.002457.33
Fernandez, Nancy,1485472.960.000.000.0072.96
Malhotra, Marco, L,29459805.330.000.000.00805.33
Fernandez, Jay,2015559.980.000.000.0059.98
Luo, Nina,2749535.000.000.000.0035.00
Raje, Terry, A,283112393.060.000.002393.060.00
Ruiz, Alberto, L,2521227.770.000.000.0027.77
Rodriguez, Cynthia, E,22206201.280.000.000.00201.28
Gao, Laura,2202930.970.000.000.0030.97
Serrano, Gerald, M,275914.990.000.000.004.99
Andersen, Jenny,202596029.570.003578.270.002451.30
Ruiz, Bruce, W,16171103.860.000.000.00103.86
Yuan, Alicia,252252129.920.000.001000.441129.48
Walker, Austin, F,2022969.970.000.000.0069.97
Schmidt, Monica,1201273.960.000.008.9964.97
Gomez, Sheila, J,211654673.880.002181.560.002492.32
Stewart, Ariana,167436070.593578.270.000.002492.32
Raman, Rachael,2521679.470.000.000.0079.47
White, Taylor, D,250111589.400.000.001000.44588.96
Perez, Allen, B,1422974.980.000.000.0074.98
Garcia, Toni,221934886.700.000.002443.352443.35
Shen, Russell, M,11150192.420.000.000.00192.42
Goel, Karla, L,11146112.930.000.0053.9558.98
Deng, Colin, B,1829932.220.000.000.0032.22
She, Melvin,165164733.753578.270.001155.480.00
Hernandez, Diana, F,110386437.333374.990.000.003062.34
Blanco, Kristi,1546437.270.000.000.0037.27
Ms., Rousey, Linda, R.,212794.990.000.000.004.99
Raman, Raymond, R,195886056.610.003578.270.002478.34
Dominguez, Ebony, R,17350127.470.000.0034.9992.48
Madan, Rachael, R,1648676.970.000.0076.970.00
Zheng, Erica, K,236434.990.000.000.004.99
Zheng, Laura,167014426.743578.270.000.00848.47
Sara, Barry, R,139656872.390.000.002071.424800.97
Sanz, Paula,2643069.990.000.000.0069.99
Anand, Carly,259181260.580.00699.100.00561.48
Blanco, Jésus, E,204486044.590.003578.270.002466.32
Lal, Andres, L,166235973.243578.270.000.002394.97
Lewis, Kayla,120133949.970.003399.99549.980.00
Sullivan, Kaitlin,1691970.950.000.000.0070.95
Xu, Barbara,1407459.880.000.000.0059.88
Kumar, Tony, P,197836021.620.003578.270.002443.35
Gonzales, Victoria,117518215.020.003399.990.004815.03
Raji, Sharon,2332939.980.000.000.0039.98
Hernandez, Hailey, A,1872786.270.000.000.0086.27
Davis, Seth, A,163393169.590.000.003169.590.00
Mehta, Erick, E,1412361.580.000.000.0061.58
Kapoor, Jarrod,2893015.230.000.000.0015.23
Martin, Justin,235423337.040.000.002181.561155.48
Sai, Ivan, E,1730094.220.000.000.0094.22
Alexander, David,1578398.960.000.000.0098.96
Moreno, Deanna,2894169.970.000.000.0069.97
Parker, Gabriella,213944657.510.002181.560.002475.95
Zhang, Ramon, D,12352274.240.000.000.00274.24
She, Alvin, E,166575900.553578.270.000.002322.28
Chapman, Pamela, L,2714535.000.000.000.0035.00
Jimenez, Neil,22151133.490.000.000.00133.49
Ferrier, Mathew,2342639.980.000.000.0039.98
Black, Tonya, M,2125489.970.000.0089.970.00
Navarro, Melinda,114548089.040.003374.992294.992419.06
Malhotra, Heidi, A,2642669.990.000.000.0069.99
Stewart, Margaret, C,29096574.980.000.000.00574.98
Gonzales, Alexis,2352121.980.000.000.0021.98
Jiménez, Beth, H,111208242.490.003374.990.004867.50
Goel, Dale, M,204164118.260.003578.27539.990.00
Lopez, Mayra, E,273561336.960.000.00782.99553.97
Lu, Christy,1706291.260.000.0091.260.00
Townsend, Darren,184675279.260.003578.271700.990.00
Gomez, Armando, S,2117535.000.000.000.0035.00
Alexander, Austin,266731505.760.000.001505.760.00
Malhotra, Terrance, E,20223187.380.000.000.00187.38
Goel, Peter, L,1526438.980.000.000.0038.98
Lopez, Jay, A,199656056.610.003578.270.002478.34
Moreno, Melody, R,11760274.920.000.000.00274.92
Raman, Dominique, D,1302358.980.000.000.0058.98
Martin, Meghan, B,2677369.990.000.0069.990.00
Garcia, Tina,1723183.980.000.000.0083.98
Moreno, Mallory, P,229124659.900.000.002181.562478.34
Miller, Zachary, M,151692919.890.000.002071.42848.47
Romero, Max, C,293162433.040.000.000.002433.04
Alvarez, Janet, G,110068119.033399.990.002334.972384.07
Suarez, Carolyn, B,182226044.590.003578.272466.320.00
Jiménez, Alberto, C,152154468.560.000.002049.102419.46
Jimenez, Felicia, L,110758068.030.003374.992294.992398.05
Suarez, Pedro, A,246112219.420.001000.441218.980.00
Lin, Heather, L,1571863.970.000.000.0063.97
Sanders, Devin, J,120143949.970.003399.990.00549.98
Sai, Martin, L,2122129.990.000.000.0029.99
Rai, Christy,1668369.870.000.000.0069.87
Sharma, Donna,119986962.100.003374.991249.842337.27
Vazquez, Joe, C,204184207.240.003578.27628.970.00
Hernandez, Monique, J,15138123.450.000.0034.9988.46
Rodriguez, Sergio, D,15239123.450.000.000.00123.45
Gao, Krystal,258211879.070.00699.100.001179.97
Vazquez, Marc, H,243623600.770.000.002443.351157.42
Torres, Bailey,1825930.970.000.008.9921.98
Pal, Wayne,1976412.940.000.0012.940.00
Wu, Kelvin,2459561.960.000.000.0061.96
Rodriguez, Toni, J,2525139.980.000.000.0039.98
Gonzalez, Jay, C,142385642.900.000.002049.103593.80
Subram, Kari,12682227.960.000.000.00227.96
Raji, Jaime, L,150373856.380.000.002071.421784.96
Serrano, Audrey,183376021.620.003578.270.002443.35
Lu, Todd, D,2426914.980.000.000.0014.98
Navarro, Stacy, C,126886867.440.002071.420.004796.02
Sara, Tina,243074158.320.000.002443.351714.97
Zhu, Lacey,241672983.340.000.002443.35539.99
Mehta, Pamela,22005135.460.000.000.00135.46
She, Jerry, C,142775196.740.000.002071.423125.32
Lu, Trisha,255551277.56699.100.000.00578.46
Mehta, Tina, C,114448136.020.003374.992376.962384.07
Lin, Margaret, C,1830687.770.000.000.0087.77
Mrs., Nara, Barbara,12704217.460.000.000.00217.46
Cox, Nicole, V,229503917.540.000.003917.540.00
Navarro, Jacquelyn,1546540.230.000.0029.9910.24
Alvarez, Arthur,248927.280.000.000.007.28
Alvarez, Tabitha,150283826.400.000.002071.421754.98
Fernandez, Marie,289297.280.000.000.007.28
Anand, Johnny,140585652.520.000.003355.242297.28
Suarez, Lance, C,1723083.980.000.000.0083.98
Saunders, Ruben, G,27983539.990.000.000.00539.99
Ashe, Brad,252282120.930.000.001000.441120.49
Becker, Grant,2139032.280.000.000.0032.28
Prasad, Marco, C,15606115.930.000.0077.9637.97
Black, Tommy,243764.990.000.000.004.99
Sanz, Larry,14067114.960.000.000.00114.96
Hall, Amanda,266561345.950.000.001345.950.00
Verhoff, Rob,110088106.313374.990.004731.320.00
Suarez, Kristi, D,230992983.340.000.002443.35539.99
Mehta, Cassandra,2301413.980.000.000.0013.98
Ma, Rafael, T,130222644.020.000.002049.10594.92
Martin, Craig, M,2501274.460.000.000.0074.46
Diaz, Randall, T,29345574.980.000.000.00574.98
Gao, Curtis, D,204295377.750.003578.270.001799.48
Liu, Autumn, J,209854118.260.003578.270.00539.99
Patel, Janelle, T,2911617.270.000.000.0017.27
Martinez, Terrance,257181274.080.00699.100.00574.98
Zhao, Randy, J,278741288.310.000.001288.310.00
Beck, Bonnie, A,29097548.980.000.000.00548.98
Reed, Kimberly, D,1731169.970.000.000.0069.97
Chandra, Arthur, L,140326859.430.000.002071.424788.01
Hu, Omar, S,289542393.060.000.000.002393.06
King, Kevin, W,214024624.910.002181.560.002443.35
Vazquez, Danny, J,260331903.480.00782.990.001120.49
Xu, Randy, S,119698173.020.003399.990.004773.03
Madan, Geoffrey, M,1524151.910.000.000.0051.91
Liu, Micah, J,152204384.080.000.002049.102334.98
Gutierrez, Carrie, C,28139127.280.000.000.00127.28
Green, Fernando,172584347.763578.270.000.00769.49
Sharma, Misty,257081253.070.00699.100.00553.97
Griffin, Olivia,2120839.980.000.000.0039.98
Griffin, Caroline,177264721.730.003578.270.001143.46
Luo, Johnny,213593032.310.002443.350.00588.96
Li, Luis, K,2025159.470.000.000.0059.47
Subram, Troy, R,196076054.220.003578.270.002475.95
Lu, Valerie,229134684.390.000.002181.562502.83
Rai, Colleen,2893329.480.000.000.0029.48
Gao, Trisha, A,289532462.550.000.000.002462.55
Hernandez, Frank, G,221984661.500.000.002181.562479.94
Mehta, Mayra,129985694.900.000.002049.103645.80
Lopez, Kristopher, L,215604702.390.002181.560.002520.83
Liu, Lacey, L,235453882.550.000.002181.561700.99
Ms., Simon, Britta,259461873.580.00699.100.001174.48
Martinez, Monica, A,141293750.090.000.002049.101700.99
Madan, Ronald,258281873.580.00699.100.001174.48
Tang, Sharon, M,1582367.960.000.000.0067.96
Ashe, Orlando, I,118978203.020.003399.990.004803.03
Gutierrez, Kristine, G,251332155.920.000.001000.441155.48
Yuan, Karla, W,136296889.110.000.002049.104840.01
Nath, Latoya, A,27582561.920.000.000.00561.92
Jai, Bonnie,119778212.500.003399.990.004812.51
Zhu, Jenny, J,17078186.940.000.00186.940.00
Subram, Kristi, N,15025128.940.000.000.00128.94
Suri, Lydia,131266815.080.000.002049.104765.98
Navarro, Cheryl,131095682.900.000.002049.103633.80
Carlson, Krista,28209574.980.000.000.00574.98
She, Nichole, M,119098105.310.003374.990.004730.32
Serrano, Linda,11071110.230.000.0042.2667.97
Rana, Joe, D,119168178.510.003374.992405.472398.05
Ma, Autumn,209944191.720.003578.270.00613.45
Prasad, Harold,1960868.450.000.000.0068.45
Mehta, Arthur, A,199576035.600.003578.270.002457.33
Nara, Derek, A,2613934.470.000.0034.470.00
Rubio, Walter, R,2591263.470.000.000.0063.47
Serrano, Hector, K,28308588.960.000.000.00588.96
Martinez, Sarah, S,126706785.130.002049.100.004736.03
Lal, Shaun, H,170564417.750.003578.270.00839.48
Madan, Candace,224092746.040.000.002181.56564.48
Chande, Raul, L,2117635.000.000.0035.000.00
Torres, Dwayne, R,172884426.240.003578.270.00847.97
Clark, Madison, A,140625647.920.000.003272.942374.98
Sutton, Jaime, L,166305973.243578.270.000.002394.97
Cox, Angel, M,1879330.480.000.000.0030.48
Alonso, Darren,27501578.460.000.000.00578.46
Zeng, Louis,189034143.740.003578.27565.470.00
Lewis, Jasmine,139646806.450.000.002071.424735.03
Carlson, Joy,13981124.210.000.000.00124.21
Gao, Lisa, A,197534.990.000.000.004.99
Vazquez, Jonathon,1790621.490.000.000.0021.49
Diaz, Briana,131316737.150.000.002049.104688.05
Davis, Nicole,2295739.980.000.000.0039.98
Hernandez, Danny,2714674.980.000.000.0074.98
Guo, Lisa, S,1731478.960.000.000.0078.96
Andersen, Jodi,2676678.980.000.000.0078.98
Chen, Claudia, R,1662764.880.000.0029.9934.89
Martinez, Cynthia,221702745.330.000.002181.56563.77
Gutierrez, Meghan, E,260211917.460.00782.990.001134.47
Sai, Levi,163495898.263578.270.000.002319.99
Ramos, Kristine,17479163.400.000.000.00163.40
Chander, Shawn, S,202165338.740.003578.270.001760.47
Raji, Willie, T,110708165.550.003399.992345.222420.34
Suri, Evelyn, A,2122356.980.000.000.0056.98
Subram, Virginia,130362677.070.000.002049.10627.97
Prasad, Arthur,142755158.370.000.002800.442357.93
Torres, Carolyn,1526170.740.000.000.0070.74
Gutierrez, Joy, A,1846653.990.000.000.0053.99
Zhang, Glenn, A,139675721.910.000.002049.103672.81
Shen, Kelvin,224063018.330.000.002443.35574.98
Beck, Alejandro,110256576.803374.990.002405.47796.34
Gutierrez, Tabitha, A,2188474.980.000.000.0074.98
Hernandez, Roberto,289232393.060.000.002393.060.00
Xu, Keith, J,2512464.470.000.000.0064.47
Powell, Thomas, R,182186021.620.003578.272443.350.00
Hu, Leah,119948169.030.003374.990.004794.04
Rana, Raymond,251152155.920.000.001000.441155.48
Wright, Haley,2603688.980.000.000.0088.98
Sharma, Terrence, N,173516117.693578.270.000.002539.42
Anand, Niñia, L,199496054.220.003578.270.002475.95

Generated 2024-11-10 07:17:58.431 UTC