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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Griffin, Noah, E,2911873.960.000.000.0073.96
Kumar, Yolanda, J,1819485.960.000.000.0085.96
Zhu, Omar,250332120.930.000.001000.441120.49
Gomez, Erik, T,291802452.040.000.002452.040.00
Deng, Latoya, H,219694759.470.002181.560.002577.91
Dominguez, Theodore, F,219874638.890.002181.560.002457.33
Chen, Randy,13004190.270.000.000.00190.27
Andersen, Drew, K,224123018.330.002443.350.00574.98
Xu, Tony, L,225762721.550.002181.560.00539.99
Morris, Isaac, G,264391938.470.00782.990.001155.48
Chande, Ashlee, N,230967.280.000.007.280.00
Raje, Arturo, C,1422849.990.000.0049.990.00
Raji, Arturo,239982756.540.000.002181.56574.98
Xie, Clarence,224022721.550.000.002181.56539.99
Fernandez, Arthur, J,223992785.050.000.002785.050.00
Perez, Rachael, D,26762133.490.000.00133.490.00
Ruiz, Krista, C,130816772.150.000.002049.104723.05
Gomez, Gary,1564034.570.000.0034.570.00
Ashe, Briana,229404207.320.000.004207.320.00
Chander, Russell, E,29067539.990.000.000.00539.99
Ramos, Kristine,17479163.400.000.0062.94100.46
Lal, Kelsey, T,249132155.920.000.001000.441155.48
Shan, Carl, D,249192212.890.000.002212.890.00
Cai, Amy,249202155.920.000.002155.920.00
Becker, Gregory, M,131046894.440.000.002071.424823.02
Kovár, Whitney,131055585.450.000.002049.103536.35
Nelson, Carol,135204551.360.000.004551.360.00
Tang, Jenny, E,142105621.240.000.003286.272334.97
Sara, Ebony,249232159.400.000.001000.441158.96
Perez, Ivan, S,234084218.820.000.002443.351775.47
Hughes, Lucas, E,266571357.970.000.001357.970.00
Coleman, Dalton, M,234123586.810.000.003586.810.00
Ortega, Max,234133617.830.000.003617.830.00
Moyer, Mario,234204144.340.000.002443.351700.99
Mehta, Cassandra,2301413.980.000.000.0013.98
Adams, Sydney,2736769.990.000.000.0069.99
Nath, Latoya, A,27582561.920.000.000.00561.92
Xu, Calvin, E,27583553.970.000.000.00553.97
Jimenez, Jaime, E,29095777.340.000.000.00777.34
Alvarez, Marvin,236513917.540.000.002181.561735.98
Raman, Arthur,240012983.340.000.002443.35539.99
Zhao, Gilbert,231193945.530.000.002181.561763.97
Alvarez, Linda,140475643.540.000.003321.262322.28
Martin, Anne, V,250342164.910.000.001000.441164.47
Ray, Bobby,235753302.050.000.002181.561120.49
Lin, Mandy, C,250352183.910.000.001000.441183.47
Kumar, Ricardo, K,141333764.070.000.003764.070.00
Raman, Brandy,1224777.270.000.0077.270.00
Diaz, Devin, D,15829187.980.000.0024.99162.99
Foster, Luke,15137161.940.000.00161.940.00
Hall, Mary, R,202774.990.000.004.990.00
Kovar, Tabitha,158332611.410.000.002611.410.00
Chander, Gregory, J,2200174.980.000.0074.980.00
Zheng, Erica, K,236434.990.000.004.990.00
Dominguez, Leslie,273461390.950.000.001390.950.00
Li, Ramon,2124834.980.000.000.0034.98
Malhotra, Heidi, A,2642669.990.000.000.0069.99
Romero, Clinton, F,28132548.980.000.000.00548.98
Mehta, Patricia, K,291792393.060.000.002393.060.00
Mr., Schulte, Scot,1580770.570.000.0024.9945.58
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
Alvarez, Pedro, E,28120539.990.000.000.00539.99
Rana, Ruben,276961183.470.000.000.001183.47
Rana, Terrance, M,28134574.980.000.000.00574.98
Lin, Dawn, N,15805127.470.000.000.00127.47
Ma, Curtis,28119574.980.000.000.00574.98
Lu, Alan,1976167.930.000.000.0067.93
Ashe, Marshall,2893293.970.000.000.0093.97
Deng, Kenneth,2023534.980.000.000.0034.98
Torres, Alfredo,2768574.980.000.000.0074.98
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
Martinez, Ivan,278722393.060.000.000.002393.06
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
Carlson, Joanna,1559434.990.000.000.0034.99
Suarez, Gina,2024869.970.000.000.0069.97
Munoz, Teresa, R,277121174.480.000.000.001174.48
Kumar, Gilbert, L,2814039.980.000.000.0039.98
Chow, Shannon,1844425.480.000.000.0025.48
Johnson, Daniel,1105158.980.000.000.0058.98
Chapman, Pamela, L,2714535.000.000.000.0035.00
Gonzalez, Tabitha, A,2613639.980.000.000.0039.98
Kapoor, Phillip,27581539.990.000.000.00539.99
Lal, Cristina, M,146712934.370.000.002071.42862.95
Shan, Tony, M,1617531.270.000.000.0031.27
Blanco, Sheila, I,1772436.960.000.000.0036.96
Munoz, Kendra, S,235293617.830.000.003617.830.00
Hernandez, Ebony, S,235743337.040.000.003337.040.00
Campbell, Devin,236533975.030.000.002181.561793.47
Murphy, Grace, J,236554144.340.000.002443.351700.99
Cai, Suzanne,250512174.920.000.001000.441174.48
Liu, Warren,150143860.870.000.002071.421789.45
Wang, Micah, C,146765188.410.000.002049.103139.31
Huang, Randy,240073042.820.000.002443.35599.47
Zimmerman, Candice, J,267541938.470.000.00782.991155.48
Serrano, Jacquelyn,2196339.990.000.0039.990.00
Guo, Autumn, A,1421386.260.000.0058.9827.28
Morgan, Jared, A,2821339.980.000.000.0039.98
Suarez, Neil,1524237.270.000.000.0037.27
Saunders, Jillian,2117839.990.000.000.0039.99
Rana, Stanley, J,2291958.980.000.000.0058.98
Fernandez, Kristi,1958528.990.000.000.0028.99
She, Jerry, C,142775196.740.000.002071.423125.32
Nath, Omar, F,146725237.720.000.002071.423166.30
Gill, Gina, F,241772721.550.000.002181.56539.99
Gutierrez, Latasha, C,150222999.910.000.002071.42928.49
Zhu, Suzanne, E,251122155.920.000.001000.441155.48
Lin, Jake,242482770.520.000.002181.56588.96
Jai, Tommy, C,150272853.570.000.002049.10804.47
Garcia, Virginia, C,2459926.970.000.000.0026.97
Hernandez, Jessie, A,241722735.530.000.002181.56553.97
Luo, Lacey,241752743.040.000.002181.56561.48
Hu, Valerie, M,150443803.560.000.002049.101754.46
Browning, Jay, M,242512983.340.000.002443.35539.99
Gomez, Teresa, D,241642760.020.000.002181.56578.46
Romero, Frank, M,152092916.560.000.002049.10867.46
Raji, Jaime, L,150373856.380.000.002071.421784.96
Blanco, Robyn, R,241793052.310.000.002443.35608.96
Yang, Cedric,150383750.090.000.002049.101700.99
Lal, Jodi, J,2294464.470.000.0064.470.00
Vance, Phillip,293082438.060.000.002438.060.00
Kapoor, Dominic, J,1669967.580.000.0032.6034.98
Lin, Jaclyn,2872139.980.000.000.0039.98
Suarez, Linda,1666581.810.000.000.0081.81
Zhang, Edwin,157854454.350.000.002071.422382.93
Liang, Lacey, A,157194429.570.000.002049.102380.47
Malhotra, Joel, E,1634358.250.000.000.0058.25
Oliver, Lee,2911969.970.000.000.0069.97
Navarro, Leslie, E,243714193.820.000.002443.351750.47
Srini, Manuel,241682790.520.000.002181.56608.96
Srini, Carolyn, S,273711350.750.000.00782.99567.76
Rai, Calvin,152292833.570.000.002049.10784.47
She, Roger, L,157244359.070.000.002049.102309.97
Subram, Douglas,273521357.970.000.00782.99574.98
Beck, Derek,1732285.480.000.000.0085.48
Romero, Dwayne,28314553.970.000.000.00553.97
Rana, Henry,273421348.460.000.00782.99565.47
Rodriguez, Francisco,243613391.030.000.002181.561209.47
Serrano, Danny,243813970.520.000.002181.561788.96
Price, Trevor, M,157254416.380.000.002071.422344.96
Sara, Ross,243674179.330.000.002443.351735.98
Johnsen, Willie,152184399.080.000.002049.102349.98
Serrano, Leslie, T,1401462.270.000.000.0062.27
Zhu, Louis,14858196.970.000.00187.988.99
Raji, Kathryn, C,2199537.290.000.000.0037.29
Nara, Ricardo,2893464.470.000.000.0064.47
Torres, Kellie,19569112.240.000.000.00112.24
Suri, Cassandra, B,1871787.210.000.000.0087.21
Xu, Barbara,1407459.880.000.000.0059.88
Prasad, Denise,1829478.260.000.000.0078.26
Hu, Stacey,12696159.000.000.000.00159.00
Zheng, Omar, C,14522126.950.000.000.00126.95
Cox, Isaac,157974415.680.000.002071.422344.26
Serrano, Alberto, L,158004399.080.000.002049.102349.98
Kumar, Barbara, N,274991331.970.000.00782.99548.98
Ramos, Leslie,157334443.550.000.002049.102394.45
Li, Margaret,157534399.080.000.002049.102349.98
Hernandez, Erika,161602644.070.000.002049.10594.97
Wright, Haley,2603688.980.000.000.0088.98
Liang, Amy,161642639.080.000.002049.10589.98
Xu, Kristen,157514446.400.000.002071.422374.98
Xu, Dawn,278731249.840.000.001249.840.00
Tang, Sharon, M,1582367.960.000.000.0067.96
Black, Michele,1399564.970.000.000.0064.97
Walker, Austin, F,2022969.970.000.000.0069.97
Kumar, Rafael, L,1908824.270.000.002.2921.98
Luo, Nichole, A,2929649.970.000.000.0049.97
Beck, Bonnie, A,29097548.980.000.000.00548.98
Li, Jake, L,1958397.960.000.000.0097.96
Sara, Ruben, A,19566164.910.000.000.00164.91
Hayes, Alexis,13048190.230.000.000.00190.23
Kumar, Bethany,29299548.980.000.000.00548.98
Sanz, Jésus,29313539.990.000.000.00539.99
West, Nathan,2437067.930.000.000.0067.93
Ramos, Paula, W,213764.990.000.000.004.99
Vazquez, Rodney, M,13047241.930.000.000.00241.93
Alonso, Kathleen,2119634.980.000.000.0034.98
Raman, Johnathan,1910363.910.000.0041.9321.98
Pal, Gilbert,27744643.950.000.00643.950.00
Long, Angelica, C,282062398.050.000.002398.050.00
Xu, Terry,2422815.230.000.000.0015.23
Raman, Deanna, H,17053123.960.000.000.00123.96
Pal, Arturo, P,293032419.060.000.000.002419.06
Rana, Marco, K,2447313.980.000.000.0013.98
Lin, Wesley,2140742.280.000.0042.280.00
Butler, Austin, W,1829374.240.000.0074.240.00
Sai, Ivan, E,1730094.220.000.000.0094.22
Vazquez, Carolyn,2365039.980.000.000.0039.98
Srini, Candace,154372.290.000.000.002.29
Li, Kristen, R,15153113.970.000.0088.9824.99
Ramos, Stacy, D,1826185.960.000.000.0085.96
Williams, Alexis, D,14674142.470.000.000.00142.47
Goel, Katie, D,2770864.470.000.000.0064.47
Guo, Jake, P,1996998.450.000.0067.9730.48
Hu, Aimee, R,2798139.980.000.0039.980.00
Zhou, Rafael, A,244949.990.000.009.990.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
Ms., Seidel, Birgit,1662173.860.000.000.0073.86
Zeng, Krystal, A,2581461.960.000.000.0061.96
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
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
Luo, Barbara,2797829.480.000.0029.480.00
Mehta, Brandy,2283939.250.000.0039.250.00
Lal, Sheena,2331213.980.000.000.0013.98
Martin, Jaime,28316539.990.000.000.00539.99
Zheng, Randy, B,2257469.990.000.000.0069.99
Zhu, Jorge,2614178.980.000.0078.980.00
Carlson, Audrey, A,2526360.470.000.000.0060.47
Jimenez, Neil,22151133.490.000.000.00133.49
Martin, Tabitha,2526923.780.000.000.0023.78
Kapoor, Troy, E,2461039.980.000.000.0039.98
Prasad, Cory,197484.990.000.000.004.99
Chander, Brad, K,2138269.990.000.0069.990.00
Zeng, Wesley,2046021.490.000.0021.490.00
Hernandez, Danny,2714674.980.000.000.0074.98
Vance, Kristi, T,2833847.970.000.000.0047.97
Subram, Roy,2189674.980.000.000.0074.98
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
Gomez, Brandi, M,14675187.980.000.000.00187.98
Romero, Raquel, Z,2291658.980.000.000.0058.98
Gill, Dwayne, A,19675198.990.000.000.00198.99
Suarez, Billy, M,1728795.260.000.000.0095.26
Zhou, Arturo, F,27910574.980.000.00574.980.00
Moore, Nathan, N,283232384.070.000.002384.070.00
Serrano, Tabitha,283272407.040.000.002407.040.00
Kapoor, Cynthia,29457756.330.000.000.00756.33
Liu, Dawn, C,2196039.990.000.000.0039.99
Prasad, Clifford,1560466.750.000.000.0066.75
Walker, Seth, E,27689539.990.000.000.00539.99
Gonzalez, Eric, C,1909278.260.000.000.0078.26
Brown, Kaitlyn,2912049.970.000.000.0049.97
Alonso, Stacy,28315556.930.000.000.00556.93
Gutierrez, Dana,2025460.470.000.000.0060.47
Shen, Michele,27985539.990.000.000.00539.99

Generated 2024-09-20 05:43:17.373 UTC