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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Liang, Steve,1431781.260.000.0049.9931.27
Becker, Leonard, C,22405123.980.000.000.00123.98
Hernandez, Audrey,1829084.960.000.008.9975.97
Perez, Edgar, B,293182384.070.000.000.002384.07
Liu, Erica, A,2156474.980.000.000.0074.98
Madan, Erick, W,1421282.260.000.000.0082.26
Ramos, Meredith, A,2330767.930.000.000.0067.93
Arun, Barry,2770039.980.000.000.0039.98
Sanchez, Marie,2292490.950.000.0090.950.00
Black, Tonya, M,2125489.970.000.0089.970.00
Martin, Felicia, L,15018112.460.000.00112.460.00
Jimenez, Joy,28312574.980.000.000.00574.98
Chande, Carl,1893259.260.000.000.0059.26
Zeng, Curtis, E,26669123.980.000.000.00123.98
Ye, Marshall, R,2655938.980.000.000.0038.98
Gomez, Nelson, L,2905338.980.000.000.0038.98
Garcia, Troy, M,292904.990.000.004.990.00
Huang, Margaret, H,17070123.960.000.00123.960.00
Liu, Karen, F,1400863.970.000.0034.9928.98
Jai, Derek, E,13613105.220.000.0027.2877.94
Weber, Jarrod, M,1485931.270.000.0031.270.00
Alexander, Gabriel, C,14073156.840.000.0038.88117.96
Lopez, Edgar, O,1734681.460.000.000.0081.46
Andersen, Roger,2446964.470.000.0064.470.00
Carlson, Lawrence, L,2206469.990.000.0069.990.00
Jai, Jaime, M,248944.990.000.004.990.00
Andersen, Ashlee, J,11059116.930.000.00116.930.00
Flores, Miranda,1724383.980.000.0053.9929.99
Serrano, Diane, E,1485787.970.000.0078.988.99
Wang, Jaclyn, M,17063100.250.000.0037.2762.98
Vazquez, Lawrence,1963256.980.000.0056.980.00
Lal, Nicolas, D,2121274.980.000.0074.980.00
Xu, Colleen, C,18325108.850.000.0038.8869.97
Chande, Alvin, W,2489323.780.000.000.0023.78
Kumar, Yolanda, J,1819485.960.000.000.0085.96
Pal, Alison,1304284.470.000.000.0084.47
Kovár, Donald, M,242779.990.000.009.990.00
Li, Kristen, R,15153113.970.000.0088.9824.99
Alvarez, Mathew, L,17494111.960.000.000.00111.96
Sanz, Orlando,1430999.470.000.0074.4824.99
Madan, Marco,1889527.770.000.0027.770.00
Hill, James, S,293172438.060.000.000.002438.06
Sun, Tamara, L,1997644.040.000.000.0044.04
Smith, Kristi, M,2196235.000.000.0035.000.00
Patel, Jay,2221359.270.000.0059.270.00
Li, Cedric,2736478.980.000.0078.980.00
Garcia, Chelsea,2196142.280.000.0042.280.00
Wang, Arturo, A,2772039.980.000.0039.980.00
Zhu, Louis,14858196.970.000.00187.988.99
Vazquez, Latasha,2195299.470.000.000.0099.47
Raman, Harold, F,28484778.620.000.000.00778.62
Rubio, Marie, V,2061821.490.000.0021.490.00
Martinez, Douglas, C,2284135.000.000.0035.000.00
Lopez, Brandy, S,1819999.940.000.000.0099.94
Martin, Casey, J,2296239.980.000.000.0039.98
Ramos, Lance, S,289492473.050.000.002473.050.00
Garcia, Preston, M,246023882.550.000.002181.561700.99
Subram, Meredith, S,142615653.920.000.002049.103604.82
Ma, Jessie,290926.280.000.000.006.28
Brown, Kaitlyn,2912049.970.000.000.0049.97
Diaz, Felicia, J,1502629.980.000.000.0029.98
Gonzalez, Donald,1107932.960.000.009.9922.97
Lal, Drew, A,28325574.980.000.000.00574.98
Ye, Amy,11073191.900.000.000.00191.90
Ortega, Felicia, J,1175347.920.000.000.0047.92
Torres, Eddie, L,219853936.540.000.002181.561754.98
Andersen, Maurice,1520698.960.000.000.0098.96
Chandra, Troy,2140674.980.000.000.0074.98
Hernandez, Melody, E,28212619.460.000.000.00619.46
Hu, Marshall, H,267971957.470.000.00782.991174.48
Luo, Alison, A,2352756.970.000.000.0056.97
Torres, Walter,2678488.970.000.000.0088.97
Andersen, Lacey,1960094.460.000.000.0094.46
Gutierrez, Joy, A,1846653.990.000.000.0053.99
Sai, Monica, L,29055765.320.000.000.00765.32
Goel, Lacey, N,1870433.260.000.000.0033.26
Lopez, Stanley, M,289622477.530.000.000.002477.53
Ramos, Leslie,157334443.550.000.002049.102394.45
Weber, Cory,1673981.260.000.0031.2749.99
Moore, Lucas, J,1502138.980.000.000.0038.98
Xu, Peter, K,282042419.060.000.002419.060.00
Raje, Darrell,2025269.970.000.000.0069.97
Zeng, Colleen, L,2830491.970.000.0091.970.00
Chen, Louis, J,17059123.960.000.000.00123.96
Deng, Tracy, E,2197837.290.000.000.0037.29
Collins, Rebecca, M,261531957.470.00782.990.001174.48
Srini, Cindy, E,260264.990.000.004.990.00
Shan, Franklin, C,2771858.980.000.000.0058.98
Sanchez, Levi, A,27745617.470.000.00617.470.00
Sara, George,242472721.550.000.002181.56539.99
Xu, Cedric, M,24278184.480.000.000.00184.48
Martin, Jay,1959733.980.000.000.0033.98
Anand, Alícia, J,291132453.040.000.000.002453.04
Gonzalez, Marco,27598556.260.000.000.00556.26
Nath, Bethany,16177133.340.000.000.00133.34
Romero, Lance,1831021.490.000.000.0021.49
Yang, Kevin, F,2060584.960.000.000.0084.96
Lopez, Isaac,27692603.490.000.000.00603.49
Lu, Martha, R,2125532.280.000.0032.280.00
Xu, Alisha,14100226.260.000.000.00226.26
Vazquez, Randall, Z,2118635.000.000.000.0035.00
Ruiz, Frank, M,142603716.230.000.002964.89751.34
Sanz, Craig, M,2199374.980.000.0074.980.00
Mehta, Erick, E,1412361.580.000.000.0061.58
Arthur, Tammy, L,213634.990.000.000.004.99
Yuan, Lacey, W,123496772.140.002049.100.004723.04
Martinez, Abby,2933354.980.000.0054.980.00
Parker, Gabriel,1960683.970.000.000.0083.97
Andersen, Deborah,19610118.940.000.000.00118.94
Sai, Holly, V,2676937.290.000.000.0037.29
Lopez, Terrance, T,14217139.450.000.0089.4649.99
Malhotra, Arthur, E,2526725.480.000.000.0025.48
Turner, Lucas,2294839.980.000.000.0039.98
Hernandez, Victor, T,2353759.980.000.000.0059.98
Jiménez, Deanna,28115562.960.000.00562.960.00
Ye, Willie,2296358.980.000.000.0058.98
Sanz, Arthur,27688166.280.000.00166.280.00
Andersen, Marshall, V,157864366.070.000.002049.102316.97
Patel, Pamela, G,278751268.840.000.001268.840.00
Munoz, Gary, D,2023032.280.000.000.0032.28
Wright, Miguel,2581186.450.000.0086.450.00
Zhu, Christy,110038139.293399.990.002318.962420.34
Chande, Latoya, M,2330959.980.000.0059.980.00
Luo, Colin, L,2121039.990.000.000.0039.99
Malhotra, Ross, R,2930714.980.000.0014.980.00
Lu, Curtis,110118133.043399.990.002294.992438.06
Gill, Eddie, J,1271574.540.000.0064.979.57
Hernandez, Isaac,2581326.970.000.000.0026.97
McDonald, Brent,1406877.270.000.000.0077.27
Xu, Martha, C,163515873.263578.270.000.002294.99
Yuan, Roger,1962261.750.000.000.0061.75
Moreno, Kathleen, C,1523459.980.000.000.0059.98
Malhotra, Kristina,2503125.480.000.000.0025.48
Jai, Warren, S,164834118.263578.270.000.00539.99
Ramos, Mary, B,1501972.960.000.008.9963.97
Lin, Karen,2424348.970.000.000.0048.97
Chande, Raul, L,2117635.000.000.0035.000.00
Fernandez, Manuel, A,165144761.743578.270.001183.470.00
Chandra, Dominique, H,2676578.980.000.0078.980.00
Liang, Vincent,204024.990.000.000.004.99
Johnson, Emma, M,1513662.270.000.0034.9927.28
Liang, Kelvin, L,166165915.543578.270.000.002337.27
Weber, Ivan,28317539.990.000.000.00539.99
Guo, Cara, R,15721118.960.000.000.00118.96
Ward, Shelby,2613239.980.000.0039.980.00
Arthur, Tabitha, E,164824783.743578.270.001205.470.00
Liang, Ronnie,2458430.480.000.000.0030.48
Chavez, Corey, R,1573159.980.000.000.0059.98
Zhou, Rafael, A,244949.990.000.009.990.00
Fernandez, Brenda, L,164934197.253578.270.000.00618.98
Subram, Roy,2189674.980.000.000.0074.98
Jimenez, Erik, H,2198935.000.000.000.0035.00
Suarez, Orlando,1112158.160.000.000.0058.16
Ashe, Ebony, E,166125898.263578.270.000.002319.99
Pal, Wayne,1976412.940.000.0012.940.00
Gill, Billy, L,1670092.970.000.000.0092.97
Lee, Austin,2615169.990.000.000.0069.99
Sai, Troy,165154733.753578.270.000.001155.48
Chander, Clarence, E,1398259.980.000.0034.9924.99
Patel, Gerald,230954.990.000.000.004.99
Nelson, Julia, L,11102102.910.000.000.00102.91
Huang, Sandra, C,165234698.763578.270.000.001120.49
Hernandez, Roberto,289232393.060.000.002393.060.00
Patel, Cynthia, M,15222123.450.000.000.00123.45
Diaz, Rebekah, J,2137878.980.000.000.0078.98
Sai, Harold,110266575.793399.990.000.003175.80
Nara, Jon,2200642.280.000.000.0042.28
Moyer, Meghan,2122074.980.000.000.0074.98
Goel, Brad, M,29085777.340.000.000.00777.34
Chander, Yolanda,165194752.753578.270.000.001174.48
Sanz, Linda, P,2294512.940.000.000.0012.94
Liu, Bianca, K,1145831.920.000.000.0031.92
Suarez, Ricky,29066539.990.000.000.00539.99
Verhoff, Rob,110088106.313374.990.004731.320.00
Garcia, Tina,1723183.980.000.000.0083.98
Li, Jenny, B,2216978.980.000.000.0078.98
Hu, Amy,14320261.950.000.000.00261.95
Jimenez, Jill,110286474.623374.990.000.003099.63
Zhou, Carol, L,2445421.490.000.000.0021.49
Blanco, Philip, M,1560339.970.000.000.0039.97
Jai, Dylan, J,2312839.980.000.000.0039.98
Carlson, Shannon, C,110098091.333374.990.002297.282419.06
Adams, Savannah,2353639.980.000.000.0039.98
Cooper, Katherine, R,14314122.950.000.000.00122.95
Sanz, Reginald, K,1752274.950.000.000.0074.95
Raman, Shane,166615908.253578.270.000.002329.98
Hayes, Christian, R,2853739.980.000.000.0039.98
Romero, Roberto, A,18285141.550.000.000.00141.55
Becker, Kelli, E,1663371.580.000.000.0071.58
Gao, Stacey,166624355.713578.270.00777.440.00
Yang, Martha, G,2221035.000.000.000.0035.00
Raji, Karl,291032419.060.000.000.002419.06
Dominguez, Gerald, E,2063171.960.000.000.0071.96
Ramos, Theresa, G,110316478.603399.990.000.003078.61
Sun, Todd,2201876.970.000.000.0076.97
Wang, Willie,2930423.970.000.000.0023.97
Ramos, Albert, E,277167.280.000.000.007.28
Alonso, Kristine,166864157.733578.270.000.00579.46
Chande, Franklin, L,2023291.950.000.000.0091.95
Xu, Glenn,1874367.210.000.000.0067.21
Anand, Bradley,1962639.460.000.000.0039.46
Ortega, Jessie, J,170516060.503578.270.000.002482.23
Lin, Jeffery, J,2734778.980.000.000.0078.98
Blanco, Lori, A,15735116.250.000.000.00116.25
Luo, Darrell, J,2118732.280.000.000.0032.28
Romero, Renee, E,166395908.253578.270.000.002329.98
Hernandez, Marvin, A,230777.280.000.000.007.28
Martinez, Virginia,1313662.270.000.000.0062.27
Subram, Stefanie,12371214.040.000.000.00214.04
Raje, Ashlee, E,166585873.263578.270.000.002294.99
Zeng, Ernest, M,12992158.510.000.000.00158.51
Navarro, Meredith,277034.990.000.000.004.99
Becker, Keith, P,27515539.990.000.000.00539.99
Dominguez, Wendy,110356451.313374.990.000.003076.32
Suri, Evelyn, A,2122356.980.000.000.0056.98
Prasad, Candace, S,2214869.990.000.000.0069.99
Rana, Rachael, A,1827094.470.000.000.0094.47
Perez, Joel,166844158.243578.270.000.00579.97
Suarez, Lance, C,1723083.980.000.000.0083.98
Sanders, Arianna, E,228594.990.000.000.004.99
She, Alicia, W,1725062.980.000.000.0062.98
Ye, Dennis, M,166385974.233578.270.000.002395.96
Subram, Rebekah,2603021.490.000.000.0021.49
Rodriguez, Monica, J,289519.990.000.000.009.99
Madan, Geoffrey, M,1524151.910.000.000.0051.91
Lopez, Heidi,110528131.323374.990.002337.272419.06
Lin, Margaret, C,1830687.770.000.000.0087.77
Madan, Henry, E,1728358.980.000.000.0058.98
Carlson, Lance, E,228564.990.000.000.004.99
Stewart, Bryan, M,169284698.763578.270.000.001120.49
Kumar, Cristina, N,15426115.920.000.000.00115.92
Beck, Donna, J,1824784.960.000.000.0084.96
Sanchez, Patrick, W,24382143.780.000.000.00143.78
Lu, Rosa, A,166634471.743578.270.00893.470.00
Huang, Arturo,289522473.040.000.000.002473.04
Xie, Michele, M,1503978.960.000.000.0078.96
Pal, Jenny,15132151.940.000.000.00151.94
Gutierrez, Natasha,170484382.753578.270.000.00804.48
Hernandez, Tabitha, L,1960325.480.000.000.0025.48
Romero, Rodney,14521117.960.000.000.00117.96
Suri, Kari,2526657.980.000.000.0057.98
Serrano, Derrick,167074377.753578.270.000.00799.48
Zhu, Amy, W,26664123.980.000.000.00123.98
Malhotra, Geoffrey, W,1829824.270.000.000.0024.27
Tang, Ashlee, D,11369118.960.000.000.00118.96
Nara, Tony, L,167136090.593578.270.002512.320.00
Ortega, Armando, K,25223102.960.000.000.00102.96
Chavez, Karla, K,1670491.260.000.000.0091.26
Zimmerman, Krystal,1722877.270.000.000.0077.27
Xie, Cristina, C,170504496.233578.270.000.00917.96

Generated 2024-11-13 01:31:12.105 UTC