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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Sai, Levi,163495898.263578.270.000.002319.99
Zeng, Dawn, D,29455751.340.000.000.00751.34
Jimenez, Jill,110286474.623374.990.000.003099.63
Chavez, Corey, R,1573159.980.000.000.0059.98
Kumar, Misty, H,250101540.430.000.001000.44539.99
Jiménez, Briana, T,28118588.960.000.000.00588.96
Diaz, Gloria,252701854.58699.100.000.001155.48
Rana, Evelyn, D,18262142.450.000.000.00142.45
Alonso, Kristine,166864157.733578.270.000.00579.46
Alvarez, Albert, R,166245938.253578.270.000.002359.98
Zeng, Claudia, M,166964506.763578.270.00928.490.00
Sanz, Craig, M,2199374.980.000.0074.980.00
Guo, Randy, L,2295664.470.000.000.0064.47
Nelson, Kaitlyn, J,2427623.970.000.0023.970.00
Yuan, Bethany, G,110306471.323399.990.000.003071.33
Perez, Johnathan, D,204264139.750.003578.27561.480.00
Yuan, Christine,110466616.813374.990.000.003241.82
Jiménez, Deanna,28115562.960.000.00562.960.00
Raji, Donna,2490661.960.000.000.0061.96
Zhao, Micah,187086056.510.003578.272478.240.00
Moreno, Krista, J,167456021.623578.270.000.002443.35
Lewis, Kayla,120133949.970.003399.99549.980.00
Wu, Kelvin,2459561.960.000.000.0061.96
Anderson, Emily, M,2522023.780.000.0023.780.00
Hu, Glenn, R,248974.990.000.000.004.99
Lopez, Deanna, L,251192148.210.000.001000.441147.77
Stewart, Bryan, M,169284698.763578.270.000.001120.49
Zhou, Clayton,273481382.460.000.00782.99599.47
Beck, Donna, J,1824784.960.000.000.0084.96
Yang, Louis, J,2301312.940.000.000.0012.94
Raman, Patricia, T,167026021.623578.270.002443.350.00
Cooper, Katherine, R,14314122.950.000.000.00122.95
Chow, Amy, E,126996798.130.002049.100.004749.03
Pal, Mohamed, D,126986786.750.002071.420.004715.33
Patel, Monica, J,252342174.920.000.001000.441174.48
Rubio, Jessie, J,278682419.060.000.000.002419.06
Sai, Preston, D,170464467.743578.270.000.00889.47
Vance, Ruth, D,17302147.440.000.0058.9888.46
Romero, Paula, B,166914471.743578.270.00893.470.00
Fernandez, Michele, M,2488423.780.000.000.0023.78
Diaz, Ruben, A,2513639.980.000.000.0039.98
Li, Lisa, J,246004.990.000.000.004.99
Torres, Diane, M,2521179.470.000.000.0079.47
Goldberg, Mindy,161594411.650.000.002071.422340.23
Liu, Autumn, J,209854118.260.003578.270.00539.99
Cook, Faith,278712384.070.000.000.002384.07
Chande, Dale, K,172424387.233578.270.000.00808.96
Zhao, Bianca,139716772.130.000.002049.104723.03
Serrano, Julio,209924139.750.003578.270.00561.48
Van, Brett,26166128.970.000.000.00128.97
Wilson, Zachary,255581307.06699.100.000.00607.96
Hayes, Edward,1579634.990.000.000.0034.99
Zheng, Jeffery, W,150303786.390.000.002071.421714.97
Russell, Alexis, L,13634234.930.000.000.00234.93
Diaz, Samuel,140655608.550.000.002071.423537.13
Chande, Latoya, M,2330959.980.000.0059.980.00
Zhou, Autumn, L,252292155.920.000.001000.441155.48
He, Kelli, A,2887259.980.000.0059.980.00
Goel, Carl, S,172494426.743578.270.000.00848.47
Zhang, Damien, C,267581322.980.000.001322.980.00
Sanz, Victor,172954392.743578.270.000.00814.47
Madan, Meagan,117678319.510.003399.992475.972443.55
Lal, Karla,2521939.980.000.000.0039.98
Sanchez, Francisco, D,2117242.280.000.0042.280.00
Goel, Tara, I,143472900.390.000.002071.42828.97
Yang, Darryl, K,215714624.910.002181.560.002443.35
Rana, Darren, M,172574480.733578.270.000.00902.46
Torres, Dwayne, R,172884426.240.003578.270.00847.97
Malhotra, Cynthia,113585034.780.003374.990.001659.79
Ms., Schultz, Barbara, R.,1581171.160.000.000.0071.16
Deng, Casey, C,1967442.280.000.000.0042.28
Mehta, Brett,114508173.260.003374.992370.222428.05
Coleman, Melanie, H,1563934.570.000.000.0034.57
Barnes, Alexia, D,1523159.480.000.000.0059.48
Murphy, Seth, A,257041239.090.00699.100.00539.99
Green, Fernando,172584347.763578.270.000.00769.49
Raji, Shawna, P,1396149.990.000.000.0049.99
Zeng, Marshall, M,209874132.240.003578.270.00553.97
Jimenez, Jacquelyn,143043595.930.000.002049.101546.83
Serrano, Lori,17066105.750.000.000.00105.75
Gutierrez, Adrienne,189064217.220.003578.27638.950.00
Martin, Joan, R,255561253.070.00699.100.00553.97
Blanco, Lori, A,15735116.250.000.000.00116.25
Liu, Karen, F,1400863.970.000.0034.9928.98
Raman, Michele,172334347.760.003578.270.00769.49
Munoz, Carolyn, L,173156030.613578.270.000.002452.34
Hill, Adam,187406056.610.003578.272478.340.00
Navarro, Tyrone, K,255571262.870.00699.100.00563.77
She, Ashlee,28319556.930.000.000.00556.93
Romero, Ruben,1663268.870.000.000.0068.87
Ortega, Lawrence,14685146.740.000.000.00146.74
Chandra, Carmen, R,2331515.230.000.000.0015.23
Moreno, Deanna,2894169.970.000.000.0069.97
Liu, Bianca, K,1145831.920.000.000.0031.92
Mr., Shakespear, Paul, J.,173264467.760.003578.270.00889.49
Deng, Colin, B,1829932.220.000.000.0032.22
Luo, Casey,110728194.000.003399.992395.962398.05
Alonso, Gary, C,187675314.250.003578.270.001735.98
Goel, Brad, M,29085777.340.000.000.00777.34
She, Latoya, A,117508148.020.003399.990.004748.03
Yuan, Bradley,179204733.750.003578.270.001155.48
Gomez, Andy,187215333.250.003578.270.001754.98
Lal, Carl, C,2895044.980.000.000.0044.98
Butler, Carson, T,12672381.970.000.000.00381.97
Zheng, Darryl,187066060.500.003578.270.002482.23
Luo, Tamara,187386089.590.003578.270.002511.32
Ortega, Janet, L,117548163.530.003399.992319.992443.55
He, Colin, B,143005322.730.000.002071.423251.31
Gutierrez, Jaime, C,114578211.480.003374.992359.962476.53
Huang, Alan, A,126716802.130.002049.100.004753.03
Stone, Colin, K,126736768.140.002049.100.004719.04
Ortega, Felicia, J,1175347.920.000.000.0047.92
Fernandez, Denise, A,187246056.510.003578.272478.240.00
Ashe, Maurice,204306056.610.003578.270.002478.34
Shen, Gilbert, C,120056984.810.003399.990.003584.82
Barnes, Angelica,1512877.270.000.000.0077.27
Gomez, Ricky,187376021.620.003578.272443.350.00
Deng, Tasha,114598141.330.003399.992322.282419.06
Gao, Edwin,257161302.590.00699.100.00603.49
Srini, Kristopher, A,2399739.980.000.000.0039.98
Sun, Candice, A,195686060.500.003578.270.002482.23
Saunders, Patricia, J,195655308.240.003578.270.001729.97
Carlson, Krista,28209574.980.000.000.00574.98
Shen, Willie, S,1845025.480.000.000.0025.48
Subram, Troy, R,196076054.220.003578.270.002475.95
Wood, Julia, L,123566810.130.002049.100.004761.03
Gomez, Randall, R,117628228.010.003399.992389.962438.06
Powell, Kaitlyn,195985310.530.003578.270.001732.26
Chander, Cassie, M,1825845.950.000.000.0045.95
Garcia, Charles, M,2025037.270.000.000.0037.27
Lal, Colin, M,1664069.970.000.000.0069.97
Fernandez, Tammy, A,258254.990.000.000.004.99
Yuan, Willie,234214208.310.000.002443.351764.96
He, Dawn,156473764.070.000.002049.101714.97
Butler, Gavin, D,2294971.970.000.000.0071.97
Prasad, Meagan,196116054.220.003578.270.002475.95
Suri, Gerald,13617116.920.000.000.00116.92
Kennedy, Devon, J,131336813.120.000.002049.104764.02
Suarez, Alfredo,196015314.250.003578.270.001735.98
Arun, Brenda,136306824.730.000.002071.424753.31
Martinez, Kari,196096093.200.003578.270.002514.93
Lopez, Bruce,235403626.820.000.002443.351183.47
Gao, Krystal,258211879.070.00699.100.001179.97
Raji, Kelli, G,131236765.440.000.002049.104716.34
Sun, Franklin,196155279.260.003578.270.001700.99
Xie, Kurt, A,14344126.950.000.000.00126.95
Torres, Sebastian, V,258311882.570.00699.100.001183.47
Zimmerman, Krystal,1722877.270.000.000.0077.27
Ortega, Danny, K,197946098.580.003578.270.002520.31
Suarez, Meredith,150323800.080.000.002049.101750.98
Nath, Louis, C,258301833.570.00699.100.001134.47
Yuan, Alicia,252252129.920.000.001000.441129.48
Romero, Sabrina, L,28534603.490.000.000.00603.49
Zhou, Louis, C,179124752.750.003578.270.001174.48
Young, Morgan, L,123426838.120.002049.100.004789.02
Navarro, Bruce, D,173536035.600.003578.270.002457.33
Tang, Bridget,177304752.230.003578.270.001173.96
Hu, Dennis, J,206006056.610.003578.270.002478.34
Li, Lacey,175154143.260.003578.270.00564.99
Serrano, Natasha,255631239.090.00699.100.00539.99
He, Jorge,2026821.490.000.000.0021.49
Lal, Barbara, W,231012795.010.000.002181.56613.45
Suri, Cesar,175124170.540.003578.27592.270.00
Yuan, Darrell,18271119.950.000.000.00119.95
Pal, Clayton,27721166.280.000.000.00166.28
Perez, Janelle,16172186.040.000.000.00186.04
Ortega, Joanna,179094761.740.003578.270.001183.47
Jimenez, Felicia, L,110758068.030.003374.992294.992398.05
Price, Vanessa, A,2356939.980.000.000.0039.98
Nath, Katie, A,234343882.550.000.002181.561700.99
Muñoz, Jaime, C,245063563.840.000.002443.351120.49
Russell, Seth,251382120.930.000.001000.441120.49
Cai, Tiffany,182044133.240.003578.270.00554.97
Carlson, Joy,13981124.210.000.000.00124.21
Becker, Kathryn,2458813.980.000.000.0013.98
Raji, Sheena, J,182136070.590.003578.272492.320.00
Powell, Thomas, R,182186021.620.003578.272443.350.00
Liang, Tiffany,11068113.360.000.000.00113.36
Serrano, Orlando,195616021.620.003578.270.002443.35
Ramos, Marc,182126029.570.003578.272451.300.00
Green, Sydney,23522120.470.000.000.00120.47
Liu, Jessie,111068079.050.003399.992294.992384.07
Gutierrez, Meredith, T,111118137.000.003399.992318.962418.05
Smith, Arthur,182406098.580.003578.272520.310.00
Jai, Clayton,123396865.460.002071.420.004794.04
Zhu, Alisha, G,182396030.610.003578.272452.340.00
Lu, Tiffany,2284348.980.000.000.0048.98
Malhotra, Darren, L,202456085.590.003578.270.002507.32
Martinez, Bruce, D,184524752.750.003578.270.001174.48
Sun, Brittney,113655024.790.003374.990.001649.80
Diaz, Aaron, C,186956029.570.003578.270.002451.30
Gomez, Naomi, E,243004144.340.000.002443.351700.99
Sara, Tina,243074158.320.000.002443.351714.97
Raji, Carl,195956095.080.003578.270.002516.81
Anand, Bradley,1962639.460.000.000.0039.46
Gonzalez, Kaylee, L,218954657.510.002181.560.002475.95
Subram, Ann, M,186936021.620.003578.272443.350.00
Townsend, Darren,184675279.260.003578.271700.990.00
Alonso, Ricky, S,140705618.930.000.002049.103569.83
Lin, Margaret, C,1830687.770.000.000.0087.77
Munoz, Diane, R,15795132.440.000.000.00132.44
Black, Mindy, W,186966149.570.003578.272571.300.00
Ma, Christy,1502040.260.000.000.0040.26
Munoz, Jacquelyn,291152407.040.000.000.002407.04
Simmons, Gabrielle,291832393.060.000.000.002393.06
McDonald, Kaitlin,184936029.570.003578.272451.300.00
Deng, Barbara,204456078.710.003578.270.002500.44
Zhou, Jessie,206106021.620.003578.270.002443.35
Rai, Brad, S,184906029.570.003578.270.002451.30
Henderson, Paige, C,1732554.940.000.000.0054.94
Zhang, Claudia,131146807.450.000.002071.424736.03
Lopez, Savannah,257091308.060.00699.100.00608.96
Kumar, Kurt, L,2736069.990.000.000.0069.99
Zheng, Claudia,186916070.590.003578.270.002492.32
Lal, Mario, T,233454.990.000.000.004.99
Richardson, Abigail, S,142365710.230.000.002071.423638.81
Serrano, Dwayne,1669576.150.000.000.0076.15
Carlson, Alfredo,16178108.850.000.000.00108.85
Suarez, Linda,1666581.810.000.000.0081.81
Shan, Derek, R,197826089.590.003578.270.002511.32
Hernandez, Melody, E,28212619.460.000.000.00619.46
Zhou, Warren,197916058.210.003578.270.002479.94
Watson, Nathaniel, H,258261854.580.00699.100.001155.48
Liu, Clarence,197976021.620.003578.270.002443.35
Nara, Karla, C,258271873.580.00699.100.001174.48
Liang, Lacey, A,157194429.570.000.002049.102380.47
Mehta, Arthur, A,199576035.600.003578.270.002457.33
Wu, Amy,197906089.590.003578.270.002511.32
Nara, Rafael, J,1705296.920.000.000.0096.92
Wu, Alisha,2365459.980.000.000.0059.98
Lu, Ronnie,199506098.540.003578.270.002520.27
Ramos, Michele, J,1957496.740.000.000.0096.74
Liu, Darryl,199476056.510.003578.270.002478.24
Gonzalez, Summer, L,2026660.470.000.000.0060.47
Raji, Carly, L,233464.990.000.000.004.99
Barnes, Mariah, H,196216021.620.003578.270.002443.35
Garcia, Toni,221934886.700.000.002443.352443.35
Reed, Steven,2437327.770.000.000.0027.77
Lopez, Pamela, E,264441938.710.000.00782.991155.72
Nara, Cristina, R,197926056.610.003578.270.002478.34
Mr., Spencer, Phil,199606120.110.003578.270.002541.84
Huang, Barbara,264421919.750.000.00782.991136.76
Carlson, Byron,119008257.010.003399.992374.982482.04
Raji, Kate, L,119038108.040.003374.992294.992438.06
Zhou, Colleen,2312213.980.000.000.0013.98
Diaz, Cheryl, A,110928110.020.003374.992341.972393.06
Shan, Colin,259211253.070.00699.100.00553.97
Martinez, Virginia,1313662.270.000.000.0062.27
Sanz, Diane, M,2015313.980.000.000.0013.98
Chen, Randy,13004190.270.000.000.00190.27

Generated 2024-11-10 02:40:19.012 UTC