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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Rubio, Kendra,170474347.763578.270.000.00769.49
Nelson, Julia, L,11102102.910.000.000.00102.91
Sharma, Sharon, T,252941882.57699.100.000.001183.47
Anand, Kelli, A,204516054.220.003578.270.002475.95
Nelson, Sophia,166644377.753578.270.00799.480.00
Shan, Mario,252711854.58699.100.000.001155.48
Blanco, Lee, M,166605898.263578.270.000.002319.99
Gutierrez, Meghan, E,260211917.460.00782.990.001134.47
Ashe, Joanna, F,209972744.520.002181.560.00562.96
Zheng, Laura,167014426.743578.270.00848.470.00
Xu, Barbara,291952419.060.000.000.002419.06
Gill, Roy,29465791.320.000.000.00791.32
Cai, Cedric,195596056.610.003578.270.002478.34
Raje, Colleen, M,190846093.200.003578.270.002514.93
Nara, Tony, L,167136090.593578.270.002512.320.00
Zhang, Ronnie,166565930.233578.270.000.002351.96
Suarez, Ricky,29066539.990.000.000.00539.99
Vazquez, Kristi,2834939.980.000.000.0039.98
Zhu, Alan,173204391.743578.270.000.00813.47
Kapoor, Regina,1581067.170.000.000.0067.17
Wang, Crystal, C,111128295.020.003374.990.004920.03
Vazquez, Roy,260291930.760.00782.990.001147.77
Zheng, Christy,170694426.743578.270.000.00848.47
Torres, Meghan, I,212563917.540.002181.560.001735.98
Beck, Alicia, L,172484382.753578.270.000.00804.48
Perez, Kevin, M,255651239.090.00699.100.00539.99
Sai, Molly,1468398.950.000.0018.9779.98
Nath, Carly, J,172554442.243578.270.000.00863.97
Vazquez, Craig,28117565.470.000.000.00565.47
Rai, Tracy, K,170794417.750.003578.270.00839.48
Alvarez, Reginald, A,187466135.090.003578.272556.820.00
Weber, Cory,1673981.260.000.0031.2749.99
Kumar, Tommy,17297100.250.000.0037.2762.98
Srini, Cindy, E,260264.990.000.004.990.00
Shen, Bridget,1723762.980.000.0062.980.00
Zhao, Glenn, C,1422182.260.000.0049.9932.27
Vazquez, Ross,11148126.240.000.0053.9972.25
Blanco, Lori, A,15735116.250.000.000.00116.25
Munoz, Carolyn, L,173156030.613578.270.000.002452.34
She, Ashlee,28319556.930.000.000.00556.93
Diaz, Cheryl, A,110928110.020.003374.992341.972393.06
Martinez, Virginia,1313662.270.000.000.0062.27
Chen, Randy,13004190.270.000.000.00190.27
Nath, Tommy, B,289377.280.000.000.007.28
Ma, Omar, I,1523239.970.000.000.0039.97
Cai, Gilbert, J,1825698.960.000.0063.9734.99
Barnes, Taylor,142795137.710.000.002049.103088.61
Goel, Mario, J,123606750.480.002071.420.004679.06
Xie, Chad, A,26155128.970.000.000.00128.97
Hernandez, Logan,123506791.750.002071.420.004720.33
Shan, Jaime,2202056.970.000.000.0056.97
Gonzalez, Carla, J,183366145.070.003578.270.002566.80
Liu, Kelli, A,244804175.610.000.002443.351732.26
Munoz, Theresa, M,139536840.750.000.002071.424769.33
Wu, Glenn, R,29343553.970.000.000.00553.97
He, Karen, C,27861539.990.000.000.00539.99
Sullivan, Ruth,277231155.480.000.000.001155.48
Rodriguez, Rachael, M,119444776.270.003374.99609.96791.32
Sanz, Craig, M,2199374.980.000.0074.980.00
Nelson, Kaitlyn, J,2427623.970.000.0023.970.00
Perez, Johnathan, D,204264139.750.003578.27561.480.00
Jiménez, Deanna,28115562.960.000.00562.960.00
Zhao, Micah,187086056.510.003578.272478.240.00
Lewis, Kayla,120133949.970.003399.99549.980.00
Anderson, Emily, M,2522023.780.000.0023.780.00
Townsend, Larry, D,111344911.830.003399.990.001511.84
Patel, Deanna, H,273541322.980.000.00782.99539.99
Vazquez, Eddie, T,140125249.920.000.002049.103200.82
Prasad, Arthur,142755158.370.000.002800.442357.93
Chander, Damien,110808204.020.003374.992359.982469.05
Lopez, Kari,15235190.890.000.000.00190.89
Kapoor, Dominic, J,1669967.580.000.000.0067.58
Xu, Brad,2615769.990.000.000.0069.99
Scott, Savannah, E,169294733.753578.270.000.001155.48
Kapoor, Ruben, D,111098245.010.003374.992476.962393.06
Shen, Jaclyn, A,125752668.080.002049.100.00618.98
Zeng, Dawn, D,29455751.340.000.000.00751.34
Taylor, Logan,1352259.980.000.000.0059.98
Chavez, Corey, R,1573159.980.000.000.0059.98
Chande, Latoya, M,2330959.980.000.0059.980.00
He, Kelli, A,2887259.980.000.0059.980.00
Zhang, Damien, C,267581322.980.000.001322.980.00
Madan, Meagan,117678319.510.003399.992475.972443.55
Sanchez, Francisco, D,2117242.280.000.0042.280.00
Martin, Hector,27860615.470.000.000.00615.47
Alonso, Joanna, M,27862548.980.000.000.00548.98
Alonso, Armando, M,136476793.150.000.002049.104744.05
Munoz, Meredith,139575645.240.000.002071.423573.82
Subram, Ivan, A,2614778.980.000.000.0078.98
Zhou, Gilbert,244753945.530.000.002181.561763.97
Madan, Brandy, A,276871183.470.000.000.001183.47
Pal, Mohamed, D,126986786.750.002071.420.004715.33
Rubio, Jessie, J,278682419.060.000.000.002419.06
Vance, Ruth, D,17302147.440.000.0058.9888.46
Goel, Dale, M,204164118.260.003578.27539.990.00
Raje, Dale, H,27746628.970.000.00628.970.00
Subram, Rebekah,2603021.490.000.000.0021.49
Lin, Karen,2424348.970.000.000.0048.97
Lin, Margaret, C,1830687.770.000.000.0087.77
Sanders, Kaylee, C,202216035.600.003578.270.002457.33
Luo, Casey,110728194.000.003399.992395.962398.05
Liu, Jessie,111068079.050.003399.992294.992384.07
Blue, Richard,12006144.740.000.000.00144.74
Guo, Cara, R,15721118.960.000.000.00118.96
He, Ramon,269191350.750.000.00782.99567.76
Raji, Misty,165204727.743578.270.000.001149.47
Beck, Alejandro,110256576.803374.990.002405.47796.34
Mehta, Marco,110078211.003399.990.004811.010.00
Ward, Haley, J,166315900.553578.270.000.002322.28
Raji, Donna,2490661.960.000.000.0061.96
Fernandez, Brenda, L,164934197.253578.270.000.00618.98
Liang, Martha,165254752.753578.270.000.001174.48
Wu, Kelvin,2459561.960.000.000.0061.96
Suarez, Jacquelyn, C,110108088.043399.990.002294.992393.06
Liang, Louis, M,127066851.410.000.002071.424779.99
Raman, Roy,163485918.243578.270.000.002339.97
Lin, Kelvin, A,130756843.940.000.002071.424772.52
Hu, Glenn, R,248974.990.000.000.004.99
Beck, Donna, J,1824784.960.000.000.0084.96
Patel, Monica, J,252342174.920.000.001000.441174.48
Sai, Levi,163495898.263578.270.000.002319.99
Jimenez, Jill,110286474.623374.990.000.003099.63
Kumar, Misty, H,250101540.430.000.001000.44539.99
Diaz, Ruben, A,2513639.980.000.000.0039.98
Diaz, Gloria,252701854.58699.100.000.001155.48
Shen, Shaun,126846893.080.002049.100.004843.98
Liu, Autumn, J,209854118.260.003578.270.00539.99
Serrano, Julio,209924139.750.003578.270.00561.48
Alonso, Kristine,166864157.733578.270.000.00579.46
Zheng, Jeffery, W,150303786.390.000.002071.421714.97
Diaz, Samuel,140655608.550.000.002071.423537.13
Zeng, Claudia, M,166964506.763578.270.00928.490.00
Zhou, Autumn, L,252292155.920.000.001000.441155.48
Guo, Randy, L,2295664.470.000.000.0064.47
Yuan, Bethany, G,110306471.323399.990.000.003071.33
Raje, Ashlee, E,166585873.263578.270.000.002294.99
Yuan, Christine,110466616.813374.990.000.003241.82
Moreno, Krista, J,167456021.623578.270.000.002443.35
Lal, Karla,2521939.980.000.000.0039.98
Fernandez, Michele, M,2488423.780.000.000.0023.78
Martin, Marc, J,110396636.583399.990.000.003236.59
Li, Lisa, J,246004.990.000.000.004.99
Goel, Tara, I,143472900.390.000.002071.42828.97
Andersen, Nicolas, A,2759439.980.000.0039.980.00
Ms., Schultz, Barbara, R.,1581171.160.000.000.0071.16
Jiménez, Briana, T,28118588.960.000.000.00588.96
Coleman, Melanie, H,1563934.570.000.000.0034.57
Sai, Cassandra, R,28110845.310.000.00845.310.00
Ye, Dennis, M,166385974.233578.270.000.002395.96
Rana, Evelyn, D,18262142.450.000.000.00142.45
Jimenez, Jacquelyn,143043595.930.000.002049.101546.83
Gill, Stacy,12679187.980.000.0024.99162.99
Stewart, Bryan, M,169284698.763578.270.000.001120.49
Alvarez, Albert, R,166245938.253578.270.000.002359.98
Raman, Patricia, T,167026021.623578.270.002443.350.00
Liu, Trisha, V,202145304.250.003578.270.001725.98
Chow, Amy, E,126996798.130.002049.100.004749.03
Arun, Cory, O,165274752.753578.270.000.001174.48
Sai, Preston, D,170464467.743578.270.000.00889.47
Zhou, Jon, L,110608153.023399.990.002319.992433.04
Goel, Brad, M,29085777.340.000.000.00777.34
Ruiz, Adrienne,1352367.260.000.000.0067.26
Romero, Paula, B,166914471.743578.270.00893.470.00
Raji, Willie, T,110708165.550.003399.992345.222420.34
Romero, Sabrina, L,28534603.490.000.000.00603.49
Yang, Darryl, K,215714624.910.002181.560.002443.35
Torres, Diane, M,2521179.470.000.000.0079.47
Torres, Dwayne, R,172884426.240.003578.270.00847.97
Chande, Dale, K,172424387.233578.270.000.00808.96
Deng, Casey, C,1967442.280.000.000.0042.28
Wilson, Zachary,255581307.06699.100.000.00607.96
Barnes, Alexia, D,1523159.480.000.000.0059.48
Young, Morgan, L,123426838.120.002049.100.004789.02
Raji, Shawna, P,1396149.990.000.000.0049.99
Hu, Dennis, J,206006056.610.003578.270.002478.34
Serrano, Lori,17066105.750.000.000.00105.75
Goel, Carl, S,172494426.743578.270.000.00848.47
Goldberg, Mindy,161594411.650.000.002071.422340.23
Cook, Faith,278712384.070.000.000.002384.07
Zhao, Bianca,139716772.130.000.002049.104723.03
Van, Brett,26166128.970.000.000.00128.97
Hayes, Edward,1579634.990.000.000.0034.99
Russell, Alexis, L,13634234.930.000.000.00234.93
Perez, Dominique,1234468.700.000.0032.2736.43
Lu, Margaret, D,208144186.230.003578.27607.960.00
Romero, Erika,199586056.510.003578.270.002478.24
Patel, Kaitlin, L,1661595.840.000.000.0095.84
Dominguez, Gerald, E,2063171.960.000.000.0071.96
Chen, Claudia, R,1662764.880.000.0029.9934.89
Kumar, Deborah, K,173086021.623578.270.000.002443.35
Lin, Sandra, A,250522155.920.000.001000.441155.48
Hernandez, Leslie, D,129906829.470.000.002071.424758.05
Liu, Jaclyn,129966808.150.000.002049.104759.05
Jones, Destiny,151714392.020.000.002049.102342.92
Romero, Marie,204244132.240.003578.27553.970.00
Ross, Connor, J,208164228.720.003578.27650.450.00
Nara, Edwin, R,110978099.030.003374.992304.982419.06
Zheng, Alan,110505007.303374.990.00854.97777.34
Lin, Damien, L,234143391.030.000.003391.030.00
Watson, Adrian, K,13641144.740.000.00117.4627.28
Pal, Christy, R,187395371.740.003578.271793.470.00
Diaz, Jacquelyn, K,187476089.590.003578.272511.320.00
Xie, Ricardo,187106098.580.003578.272520.310.00
Zheng, Vincent,184966121.710.003578.272543.440.00
Suarez, Natasha,1467937.970.000.000.0037.97
Kumar, Cedric, B,228604663.790.000.002181.562482.23
Schmidt, Joe, M,229054624.910.000.002181.562443.35
Dominguez, Darren, M,139666842.120.000.002049.104793.02
Serrano, Neil, L,17076103.460.000.000.00103.46
Ms., Robinson, Rebecca, A.,1191341.260.000.000.0041.26
Chen, Jake,228454633.900.000.002181.562452.34
Martinez, Ethan, C,202605314.250.003578.270.001735.98
Ramos, Sabrina, L,29082742.350.000.000.00742.35
Deng, Priscilla, M,251272174.920.000.001000.441174.48
Cook, Kaylee,119048214.500.003399.990.004814.51
Vazquez, Byron,1112242.930.000.007.9534.98
Rodriguez, Jonathan, J,1304664.970.000.0029.9834.99
Sun, Leah,177344698.760.003578.270.001120.49
Suarez, Renee, L,127036891.120.000.002049.104842.02
Chander, Lindsay, R,1997249.700.000.000.0049.70
Raman, Meagan, J,151345151.710.000.002071.423080.29
Patel, Arthur, B,2667169.990.000.000.0069.99
Moreno, Mallory, P,229124659.900.000.002181.562478.34
Shen, Devon, G,2735878.980.000.000.0078.98
Raji, Grant, R,1618528.980.000.000.0028.98
Gomez, Erik, T,291802452.040.000.000.002452.04
Chander, Clarence, E,1398259.980.000.0034.9924.99
Jenkins, Angela,157224448.570.000.002049.102399.47
Rodriguez, Evelyn,131176831.420.000.002049.104782.32
Dominguez, Jerome, F,229873942.030.000.002181.561760.47
Nelson, Mary, L,131075650.900.000.002049.103601.80
Russell, Noah, M,264471938.470.000.00782.991155.48
Arthur, Rebekah,229393961.030.000.002181.561779.47
Johnson, Logan, K,229313882.550.000.003882.550.00
Parker, Timothy, C,229434144.340.000.002443.351700.99
Cai, Warren,249182120.930.000.001000.441120.49
Wilson, Edward, L,265621925.410.000.00782.991142.42
Pal, Lacey, K,265711938.470.000.00782.991155.48
Shan, Carl, D,249192212.890.000.001000.441212.45
Kumar, Tonya, A,229344173.320.000.002443.351729.97
Lopez, Manuel, M,140505650.240.000.003295.262354.98
Chande, Bonnie, L,239923167.820.000.002443.35724.47
Garcia, Monica, D,2026749.970.000.000.0049.97
Zhao, Shannon,1980735.470.000.000.0035.47
Kumar, Yolanda, J,1819485.960.000.000.0085.96
Zhu, Omar,250332120.930.000.001000.441120.49
Chande, Ashlee, N,230967.280.000.000.007.28
Martinez, Emma,16734128.970.000.000.00128.97
Raje, Arturo, C,1422849.990.000.000.0049.99
Carlson, Francis,273401350.750.000.00782.99567.76

Generated 2024-11-10 04:04:23.546 UTC