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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Chen, Steve, R,189024186.230.003578.27607.960.00
Navarro, Kathleen, J,192694118.260.003578.27539.990.00
Raji, Nicolas, N,1730174.980.000.000.0074.98
Jones, Ethan,130516831.740.000.002071.424760.32
Ramos, Dana, D,259191248.080.00699.100.00548.98
Xu, Keith, J,2512464.470.000.000.0064.47
Lopez, Brenda,2659278.980.000.000.0078.98
Lal, Alicia,157344426.410.000.002071.422354.99
Sun, Tamara, L,1997644.040.000.000.0044.04
Ferrier, Edwin, J,157574366.410.000.002071.422294.99
Rai, Willie,146735117.750.000.002071.423046.33
He, Brent, R,257121262.060.00699.100.00562.96
Martin, Reginald,14054210.770.000.000.00210.77
Andersen, Warren,119198171.520.003374.990.004796.53
Diaz, Vanessa, J,29100102.960.000.000.00102.96
Gonzalez, Virginia,119294965.780.003374.990.001590.79
Alvarez, Max, M,119868245.230.003399.990.004845.24
Guo, Glenn, J,1871224.270.000.000.0024.27
Gao, Curtis, D,204295377.750.003578.270.001799.48
Ashe, Deanna,202845328.230.003578.270.001749.96
Serrano, Tyrone,113605025.800.003399.990.001625.81
Chavez, Kurt, C,2356356.970.000.000.0056.97
Schmidt, Kaitlin,13628191.250.000.000.00191.25
Ye, Leah,110778169.030.003374.992374.982419.06
Gonzalez, Kristopher, C,192644132.240.003578.27553.970.00
Xu, Julie,183016056.610.003578.272478.340.00
Hernandez, Monique, J,15138123.450.000.0034.9988.46
Zhang, Barbara,16338169.430.000.0058.47110.96
Lu, Christy,1706291.260.000.0091.260.00
Black, Priscilla,1576662.270.000.0034.9927.28
Sun, Rafael,267491322.980.000.001322.980.00
Zhao, Jaclyn, D,261671903.480.000.00782.991120.49
He, Jon, L,142625652.540.000.002071.423581.12
Ross, Julian,113635035.810.003399.990.001635.82
Subram, Kristi, N,15025128.940.000.000.00128.94
Williams, Alexis, D,14674142.470.000.000.00142.47
Patel, Toni, E,258291894.070.00699.100.001194.97
Gomez, Marc, J,2188039.990.000.000.0039.99
Blanco, Erika, L,1466990.250.000.000.0090.25
Sanders, Charles, E,21967123.960.000.000.00123.96
Subram, Cassandra, M,1661876.150.000.000.0076.15
Yuan, Derek, L,275891183.470.000.000.001183.47
Chandra, Tina, S,139745237.730.000.002071.423166.31
Ma, Jorge, O,1405286.260.000.0027.2858.98
Johnson, Emma, M,1513662.270.000.0034.9927.28
Fernandez, Ross, R,1176376.650.000.0024.4952.16
Blanco, Rodney, A,201584153.250.003578.27574.980.00
Blanco, Micheal, A,11113109.880.000.00101.937.95
Arun, Levi, A,1107494.190.000.000.0094.19
Ramirez, Olivia, D,197856076.610.003578.270.002498.34
She, Mandy, K,2197240.230.000.000.0040.23
Beck, Alisha, E,1146347.920.000.007.9539.97
Gutierrez, Carrie, C,28139127.280.000.000.00127.28
Gonzalez, Marco,27598556.260.000.000.00556.26
Yuan, Lacey, W,123496772.140.002049.100.004723.04
Raman, Abby, T,151225193.720.000.002071.423122.30
Xu, Lacey, S,179134733.750.003578.270.001155.48
Alexander, Olivia, L,146675295.410.000.002049.103246.31
Gao, Tiffany, E,163525948.493578.270.000.002370.22
Perez, Evelyn,143463583.260.000.002071.421511.84
Nara, Jaclyn, M,119305035.810.003399.990.001635.82
Romero, Philip, F,221954909.670.000.002443.352466.32
Lin, Autumn, E,182726056.610.003578.272478.340.00
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
Alonso, Teresa,1313883.970.000.0058.9824.99
Martin, Larry,182546021.620.003578.272443.350.00
Sanchez, Denise,167036090.593578.270.002512.320.00
Serrano, Stacy,246132148.210.001000.441147.770.00
James, Evan, V,1111985.220.000.0035.2349.99
Zhao, Ernest, C,187005328.230.003578.271749.960.00
Zhou, Cedric,175144142.230.003578.27563.960.00
Nath, Michele, L,110568207.503374.990.002413.452419.06
Bradley, Diane, A,1514062.270.000.0027.2834.99
Madan, Stanley,196026093.200.003578.270.002514.93
Sanchez, Clifford,21188123.960.000.000.00123.96
Gray, Jeremiah,233314144.340.000.002443.351700.99
Brooks, Jared,244763563.840.000.002443.351120.49
Subram, Douglas,273521357.970.000.00782.99574.98
Munoz, Deanna,110548223.023399.990.002403.972419.06
Pal, Willie, J,1175546.250.000.000.0046.25
Nara, Willie,244603302.050.000.002181.561120.49
Ward, Brooke,130075671.240.000.002071.423599.82
Sai, Monica, L,29055765.320.000.000.00765.32
Patterson, Jennifer, M,151295177.730.000.002071.423106.31
Adams, Devin,2187129.990.000.000.0029.99
Romero, Ebony, A,2771712.940.000.000.0012.94
Weber, Levi, A,13120205.390.000.0049.48155.91
Chande, Kelli, C,229333917.540.000.002181.561735.98
Goel, Peter, L,1526438.980.000.008.9929.99
Shen, Karla, E,22925134.930.000.000.00134.93
Hernandez, Kristine,142865234.400.000.002049.103185.30
Alonso, Lance, I,1405764.970.000.000.0064.97
Hernandez, Jessie, A,241722735.530.000.002181.56553.97
Zhu, Jenny, J,17078186.940.000.00186.940.00
Luo, Barbara,2797829.480.000.0029.480.00
Vazquez, Neil, K,287192384.070.000.002384.070.00
Martin, Gerald, K,1728490.250.000.0031.2758.98
Sanchez, Terrance,19584116.740.000.0088.9727.77
Ferrier, Leslie, M,285352433.040.000.002433.040.00
Romero, Gina,142345687.720.000.002071.423616.30
Raman, Rachael,2521679.470.000.000.0079.47
Browning, Jay, M,242512983.340.000.002443.35539.99
Goel, Marshall, M,27691603.490.000.000.00603.49
Huang, Jake,1958995.260.000.000.0095.26
Lal, Sheena,2331213.980.000.000.0013.98
Clark, Joshua, A,2613769.990.000.000.0069.99
Lu, Valerie,229134684.390.000.002181.562502.83
Liang, Kelvin, L,166165915.543578.270.000.002337.27
Ramos, Monique,164956002.233578.270.000.002423.96
Zheng, Colleen,13026155.940.000.000.00155.94
Sanz, Ross,114558142.030.003374.992319.992447.05
Gao, Jon, C,114568224.460.003399.992391.432433.04
Xu, Cedric, M,24278184.480.000.000.00184.48
Mr., Rodgers, Scott, M.,202115333.250.003578.270.001754.98
Perez, Preston,1237061.530.000.002.2959.24
Kapoor, Brandy, I,15236126.950.000.000.00126.95
He, Susan, A,244673337.040.000.002181.561155.48
Zheng, Randy, B,2257469.990.000.000.0069.99
She, Glenn, L,291179.990.000.000.009.99
Lu, Darryl,277021155.480.000.000.001155.48
Diaz, Kendra,130212668.380.000.002071.42596.96
Ma, Roger, V,151305215.400.000.002049.103166.30
Martinez, Jay,245923896.530.000.002181.561714.97
Tang, Cristina, D,19623153.930.000.000.00153.93
Nath, Melvin, D,276971120.490.000.000.001120.49
Xie, Wayne, S,183026029.570.003578.272451.300.00
Hernandez, Audrey,1829084.960.000.008.9975.97
Garcia, Harold, K,14087341.970.000.00159.00182.97
Lal, Franklin, A,141013679.900.000.002888.58791.32
Madan, Cassandra, D,29068751.340.000.000.00751.34
Long, Alexis,225803051.310.000.002443.35607.96
Cooper, Alex, L,273621407.450.000.00782.99624.46
Ramos, Marie, A,143085140.400.000.002049.103091.30
Chander, Andres, E,29460751.340.000.000.00751.34
Mehta, Heidi,142265656.240.000.002071.423584.82
Munoz, Felicia, D,2040659.980.000.000.0059.98
Jimenez, Marie, C,241763042.820.000.002443.35599.47
Tang, Terrence, R,17303123.450.000.000.00123.45
Gill, Orlando,2136093.970.000.000.0093.97
Suarez, Lawrence, C,261311952.450.00782.990.001169.46
Chandra, Veronica,146815178.400.000.002049.103129.30
Chapman, Patricia,120377107.100.003374.990.003732.11
Kumar, Katie, P,123416840.620.002049.100.004791.52
Kapoor, Troy, E,2461039.980.000.000.0039.98
Ross, Mya, E,277151147.770.000.000.001147.77
Becker, Grant,2139032.280.000.000.0032.28
She, Kristin, L,1996197.970.000.000.0097.97
Chen, Louis, J,17059123.960.000.000.00123.96
Bell, Isabella,276981179.970.000.000.001179.97
Lal, Andres, L,166235973.243578.270.000.002394.97
Mitchell, Wyatt, A,140485123.740.000.002071.423052.32
Chander, Brad, K,2138269.990.000.0069.990.00
Saunders, Brandy,119464697.310.003399.99554.97742.35
Cai, Alvin, D,1111535.230.000.0027.287.95
Ramos, Jaime,1572070.220.000.0035.2334.99
Black, Tonya, M,2125489.970.000.0089.970.00
Evans, Adam, H,2582048.970.000.0048.970.00
Carter, Amber, E,16679106.560.000.0071.5834.98
Vance, Kristi, T,2833847.970.000.000.0047.97
Liang, Ronnie,2458430.480.000.000.0030.48
Garcia, Stefanie, E,277431155.480.000.000.001155.48
Weber, Cynthia,269211336.960.000.00782.99553.97
Dominguez, Robin,166854183.233578.270.000.00604.96
Zheng, Rosa, G,166295933.263578.270.000.002354.99
Alvarez, Carrie, W,234104016.530.000.002181.561834.97
Gomez, Brandi, M,14675187.980.000.000.00187.98
Ma, Amy, E,173096030.613578.270.000.002452.34
Bell, Stephanie, A,273701322.980.000.00782.99539.99
Gonzalez, Carolyn, H,224072756.540.000.002181.56574.98
Liang, Alan, L,29063801.830.000.000.00801.83
Beck, April,143025140.730.000.002071.423069.31
Ramos, Naomi, M,236564144.340.000.002443.351700.99
Washington, Abigail,236613961.030.000.002181.561779.47
Chander, Alisha,125722611.410.002071.420.00539.99
Kovár, Whitney,131055585.450.000.002049.103536.35
Zheng, Sandra, P,1514163.970.000.000.0063.97
Suarez, Billy, M,1728795.260.000.000.0095.26
Carson, Kelvin, A,119958249.010.003399.990.004849.02
Carlson, Ebony,139596858.420.000.002049.104809.32
Dominguez, Lee, R,245974009.500.000.002181.561827.94
Chande, Tonya,119928123.030.003399.990.004723.04
Huang, Margaret, H,17070123.960.000.00123.960.00
Lu, Rosa, A,166634471.743578.270.00893.470.00
Gill, Byron, J,184836056.610.003578.272478.340.00
Weber, Jarrod, M,1485931.270.000.0031.270.00
Schmidt, Monica,1201273.960.000.008.9964.97
Zhou, Arturo, F,27910574.980.000.00574.980.00
Li, Elijah,167406099.103578.270.002520.830.00
Liang, Colin,13639188.960.000.003.99184.97
Moore, Nathan, N,283232384.070.000.002384.070.00
Madan, Jarrod, C,215554715.490.002181.560.002533.93
Kapoor, Cynthia,29457756.330.000.000.00756.33
Serrano, Gloria, G,215564930.680.002443.350.002487.33
Raman, Virginia,2615969.990.000.000.0069.99
Shen, Russell, M,11150192.420.000.000.00192.42
Gutierrez, Erika,1722783.970.000.000.0083.97
Vazquez, Andy,196205279.260.003578.270.001700.99
Weber, Deanna, L,148553759.080.000.002049.101709.98
Andersen, Gilbert, T,273531371.950.000.00782.99588.96
Ye, Amy,11073191.900.000.000.00191.90
Rodriguez, Douglas, W,196525314.250.003578.270.001735.98
Ye, Alejandro, W,150293826.400.000.002071.421754.98
Yuan, Marshall, P,199786060.500.003578.270.002482.23
Blanco, Orlando,225753018.330.000.002443.35574.98
Lee, Dalton, J,169314767.733578.270.000.001189.46
Zhao, Heather,245964168.830.000.002443.351725.48
Guo, Lisa, S,1731478.960.000.000.0078.96
Li, Trisha, A,182966117.690.003578.272539.420.00
Anand, Johnny,140585652.520.000.003355.242297.28
Andersen, Roger,2446964.470.000.0064.470.00
Carlson, Lawrence, L,2206469.990.000.0069.990.00
Huang, Amy, C,12244114.960.000.0049.9964.97
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
Nara, Katrina, Z,246082120.930.001000.441120.490.00
Lin, Claudia, A,14312191.270.000.00166.2824.99
Coleman, Dalton, M,234123586.810.000.003586.810.00
Lin, Rafael,14099200.260.000.0027.28172.98
Moreno, Danny, M,29458811.320.000.000.00811.32
Sai, Tina, L,154253772.410.000.002071.421700.99
Raji, Colleen,27707561.480.000.000.00561.48
Fernandez, Shane, A,1312786.260.000.000.0086.26
Gonzalez, Dominique, J,2797658.980.000.000.0058.98
Ma, Colin,2642869.990.000.000.0069.99
Luo, Lacey,241752743.040.000.002181.56561.48
Zhou, Carol, L,2445421.490.000.000.0021.49
Malhotra, Phillip, J,2197774.980.000.000.0074.98
Adams, Savannah,2353639.980.000.000.0039.98
Hayes, Christian, R,2853739.980.000.000.0039.98
Yang, Martha, G,2221035.000.000.000.0035.00
Martin, Jay,1959733.980.000.000.0033.98
Deng, Clayton, G,172856093.203578.270.000.002514.93
Sun, Todd,2201876.970.000.000.0076.97
Wood, Maria,126676813.120.002049.100.004764.02
Lal, Alisha, C,2187234.980.000.000.0034.98
Xie, Lindsey, M,251324.990.000.000.004.99
Raji, Lacey, E,1634188.250.000.000.0088.25
She, Mindy, J,13009168.670.000.000.00168.67
Diaz, Emma, L,1871110.240.000.000.0010.24
Serrano, Mathew, A,29186603.490.000.000.00603.49
Malhotra, Pedro,215594900.680.002443.350.002457.33
Hu, Amy,14320261.950.000.000.00261.95
Lewis, Nicole,21881128.970.000.000.00128.97
Malhotra, Douglas, L,229604.990.000.000.004.99
Campbell, Haley, L,1730462.270.000.000.0062.27
Zheng, Shannon, M,1467849.990.000.0049.990.00
He, Ramon,269191350.750.000.00782.99567.76

Generated 2024-11-10 02:55:43.631 UTC