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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Kumar, Bethany,29299548.980.000.000.00548.98
Chande, Michele, C,130786850.460.000.002071.424779.04
Chander, Alisha,125722611.410.002071.420.00539.99
Coleman, Jocelyn,206066054.220.003578.270.002475.95
Becker, Latoya, W,1733030.970.000.000.0030.97
Sai, Molly,1468398.950.000.0018.9779.98
Gill, Diana,257101239.090.00699.100.00539.99
Pal, Dale,1845175.470.000.000.0075.47
Zhou, Gilbert,244753945.530.000.002181.561763.97
Patel, Rachael, G,1364071.250.000.0032.2738.98
Rana, Carla, K,195935306.540.003578.270.001728.27
Cook, Victoria, J,206206044.590.003578.270.002466.32
Mehta, Carla, L,2156339.990.000.0039.990.00
Johnston, Joanna, L,1729663.970.000.000.0063.97
Raji, Derek, D,1959163.420.000.000.0063.42
Diaz, Gary,2748238.980.000.0038.980.00
Yang, Clarence, D,251212155.920.000.001000.441155.48
Shan, Clarence,224082770.520.000.002181.56588.96
Rana, Johnathan, R,2749737.290.000.000.0037.29
Ortega, Lawrence,14685146.740.000.000.00146.74
Rubio, Mallory, S,1109888.960.000.0029.9858.98
Shen, Alison, A,1661471.160.000.000.0071.16
Kapoor, Arthur,2448323.970.000.000.0023.97
Lal, Shaun, H,170564417.753578.270.000.00839.48
Xu, Dennis,2199739.990.000.000.0039.99
Arun, Ross, C,236583936.540.000.002181.561754.98
Rubio, Jessie, J,278682419.060.000.000.002419.06
Mehta, Marco,110078211.003399.990.004811.010.00
Pal, Dustin,265881938.470.000.00782.991155.48
Wood, Fernando, K,242539.990.000.000.009.99
Beck, Alisha, E,1146347.920.000.007.9539.97
Raman, Sergio,278662398.050.000.000.002398.05
Luo, Lacey,241752743.040.000.002181.56561.48
Rai, Rafael, H,18715123.960.000.000.00123.96
Carlson, Jonathon, N,1707378.970.000.000.0078.97
Lopez, Kristi,281377.280.000.000.007.28
Yuan, Karla, W,136296889.110.000.002049.104840.01
Chander, Edwin, T,173704742.740.003578.270.001164.47
Prasad, Denise,1829478.260.000.000.0078.26
Hu, Alvin, E,114498130.320.003374.992362.272393.06
Subram, Joe,136316817.120.000.002049.104768.02
Vazquez, Daisy, L,255601288.060.00699.100.00588.96
Hayes, Alexis,13048190.230.000.000.00190.23
Munoz, Carolyn, L,173156030.613578.270.000.002452.34
Xie, Kelli, J,204526156.700.003578.270.002578.43
Liu, Cedric,126776785.470.002071.420.004714.05
Peterson, Juan, H,130826906.390.000.002071.424834.97
Lal, Devon, L,1523766.260.000.000.0066.26
Kapoor, Candace,1828230.970.000.0021.988.99
Sai, Lydia, L,139685181.700.000.002862.742318.96
Deng, Grant, C,1662581.810.000.000.0081.81
Navarro, Eddie, C,245043563.840.000.002443.351120.49
Pal, Gilbert,27744643.950.000.00643.950.00
Wang, Arturo, A,2772039.980.000.0039.980.00
Moore, Michael,172474432.723578.270.000.00854.45
Xu, Kara, E,2221239.990.000.000.0039.99
Alonso, Kathleen,2119634.980.000.000.0034.98
Rodriguez, Arthur,154383788.680.000.002071.421717.26
Rana, Ruben,276961183.470.000.000.001183.47
Madan, Candace,224092746.040.000.002181.56564.48
Mehta, Abby, C,2217921.980.000.000.0021.98
Jai, Bonnie,119778212.500.003399.990.004812.51
Rana, Evelyn, D,18262142.450.000.000.00142.45
Liang, Brittney, R,261826.280.000.000.006.28
Long, Isabelle, W,231043490.030.000.003490.030.00
Raman, Brett, L,229304900.680.000.002443.352457.33
Zheng, Alisha,222034624.910.000.002181.562443.35
Shen, Alisha, J,264381938.470.000.00782.991155.48
Xie, Ricardo,187106098.580.003578.272520.310.00
Zhang, Glenn, A,139675721.910.000.002049.103672.81
Lin, Dennis,161694404.080.000.002049.102354.98
Hernandez, Ross,1467781.260.000.000.0081.26
Wang, Valerie,202176089.590.003578.270.002511.32
Kumar, Warren, A,240032806.530.000.002181.56624.97
Kumar, Kurt, L,2736069.990.000.000.0069.99
Fernandez, Rachael, M,239933072.320.000.002443.35628.97
Blanco, Rodney, A,201584153.250.003578.27574.980.00
Gomez, Naomi, E,243004144.340.000.002443.351700.99
Jai, Tommy, C,150272853.570.000.002049.10804.47
Luo, Ashlee,235344179.330.000.002443.351735.98
Hill, Luis,275001371.950.000.00782.99588.96
Raje, Karla,289367.280.000.007.280.00
Raje, Kurt,152102926.390.000.002071.42854.97
Madan, Brenda,13043175.930.000.000.00175.93
She, Colin, M,1513959.980.000.0034.9924.99
Gutierrez, Victor, J,2735769.990.000.000.0069.99
Gill, Jimmy,29098628.970.000.000.00628.97
Alvarez, Reginald, A,187466135.090.003578.272556.820.00
Blanco, Wendy, J,19604171.730.000.00147.9523.78
Zhu, Jamie, J,1314069.990.000.000.0069.99
Madan, Joe,293002419.060.000.000.002419.06
Suarez, Kristy,219844175.610.000.002443.351732.26
Hernandez, Mallory,29091756.330.000.000.00756.33
Chavez, Colin,1603290.950.000.0021.9868.97
Gao, Stacey,166624355.713578.270.00777.440.00
Gill, Gerald, A,28487805.330.000.000.00805.33
Shen, Karla, E,22925134.930.000.000.00134.93
Cai, Gilbert, J,1825698.960.000.0063.9734.99
Vazquez, Craig,28117565.470.000.000.00565.47
Wang, Jon, A,261911938.470.000.00782.991155.48
Morris, Eduardo,19619112.750.000.0088.9723.78
Garcia, Toni,221934886.700.000.002443.352443.35
Shen, Shawn,192704127.250.003578.27548.980.00
Hu, Marshall, H,267971957.470.000.00782.991174.48
Jai, Derek, E,13613105.220.000.0027.2877.94
Xie, Wayne, S,183026029.570.003578.272451.300.00
Lopez, Summer,1203669.550.000.002.2967.26
Ms., Salavaria, Sharon,119648173.530.003399.992329.992443.55
Carlson, Jose,1995474.450.000.0060.4713.98
Serrano, Deanna, W,151444344.090.000.002049.102294.99
Alvarez, Tyrone, K,27693539.990.000.000.00539.99
Alexander, Alyssa, M,1728237.270.000.000.0037.27
Sai, Frederick,209914118.260.003578.270.00539.99
Wu, Jamie, S,2759564.470.000.000.0064.47
Garcia, Dalton, M,187685314.250.003578.270.001735.98
Randall, Toni,1660566.260.000.0027.2838.98
Campbell, Seth,187166021.620.003578.272443.350.00
Raje, Donna, A,2060723.780.000.000.0023.78
Martinez, Abby,2933354.980.000.0054.980.00
Xu, Cara,235263563.840.000.003563.840.00
Nath, Dale, B,27343132.970.000.000.00132.97
Gill, Mathew, M,274861371.950.000.00782.99588.96
Davis, Seth, A,163393169.590.000.003169.590.00
Powell, Rachel,208184230.730.003578.27652.460.00
Madan, Ronald,258281873.580.00699.100.001174.48
Srini, Darren, P,155914346.380.000.002049.102297.28
Weber, Jarrod, M,1485931.270.000.0031.270.00
Chande, Latoya, M,2330959.980.000.0059.980.00
Chander, Maurice, L,1408631.270.000.000.0031.27
Serrano, Leslie, T,1401462.270.000.000.0062.27
Deng, Gilbert, C,157654369.090.000.002049.102319.99
Martinez, Holly, B,196286035.600.003578.270.002457.33
Ma, Jessie,290926.280.000.000.006.28
Sun, Dennis, K,244814179.330.000.002443.351735.98
Ruiz, Hector,275924.990.000.000.004.99
Cox, Catherine, K,131226871.430.000.002071.424800.01
Goel, Bethany,27511548.980.000.000.00548.98
Gonzalez, Summer, L,2026660.470.000.000.0060.47
Goel, Derek,170454480.733578.270.000.00902.46
Vazquez, Byron,1112242.930.000.007.9534.98
Gomez, Adrienne,119208156.320.003374.990.004781.33
Carlson, Lance, E,228564.990.000.000.004.99
Garcia, Troy, M,292904.990.000.004.990.00
Martinez, Emma,16734128.970.000.000.00128.97
Lopez, Jay, A,199656056.610.003578.270.002478.34
Blanco, Mallory,219584696.490.002181.560.002514.93
Xu, Trisha,2028237.270.000.000.0037.27
Ramos, Albert, E,277167.280.000.000.007.28
Anand, Alison, J,240092746.040.000.002181.56564.48
Lopez, Adriana, A,120028145.330.003374.990.004770.34
Rodriguez, Toni, J,2525139.980.000.000.0039.98
Vance, Toni, L,23438123.480.000.000.00123.48
Perry, Madison, R,233084.990.000.000.004.99
Ruiz, Leslie, J,260327.280.000.007.280.00
Chande, Derek,267431371.950.000.001371.950.00
Subram, Meredith, S,142615653.920.000.002049.103604.82
Torres, Bailey,1825930.970.000.008.9921.98
Fernandez, Carolyn, S,2930222.930.000.000.0022.93
Yang, Valerie, L,2736169.990.000.000.0069.99
Powell, Grace, B,291942419.060.000.000.002419.06
Liang, Dennis,14034104.240.000.000.00104.24
Subram, Roy,2189674.980.000.000.0074.98
Carter, Sophia, D,2523080.960.000.000.0080.96
Suri, Gerald,13617116.920.000.000.00116.92
Carlson, Lawrence, L,2206469.990.000.0069.990.00
Shan, Bridget,2933839.980.000.000.0039.98
Prasad, Harold,1960868.450.000.000.0068.45
Ye, Vincent,13013256.240.000.000.00256.24
Goel, Alisha, C,267671331.970.000.001331.970.00
Nara, Ricardo,2893464.470.000.000.0064.47
Goel, April, C,16166108.850.000.0069.9738.88
Raman, Johnathan,1910363.910.000.0041.9321.98
Jiménez, Bruce, L,236403936.540.000.002181.561754.98
Gao, Eugene,29464756.330.000.000.00756.33
Shan, Dylan,1967758.980.000.000.0058.98
Sharma, Bonnie, R,255621239.090.00699.100.00539.99
Torres, Sebastian, V,258311882.570.00699.100.001183.47
Rai, Christy,1668369.870.000.000.0069.87
Goel, Lacey, N,1870433.260.000.0030.972.29
Li, Jaclyn,182816081.100.003578.270.002502.83
Martin, Deanna,130916864.950.000.002071.424793.53
Gill, Carolyn,2309467.930.000.000.0067.93
Rubio, Juan,1617032.280.000.000.0032.28
Shen, Cedric,2220974.980.000.000.0074.98
Ortega, Renee,1844721.490.000.000.0021.49
Goel, Bradley,1580366.260.000.000.0066.26
Zheng, Rosa, G,166295933.263578.270.000.002354.99
She, Derek,150363785.080.000.002049.101735.98
Raje, Marshall, J,1926742.280.000.000.0042.28
Rodriguez, Carla, V,212304171.620.002443.350.001728.27
Madan, Cassandra, D,29068751.340.000.000.00751.34
Hernandez, Orlando, C,219514923.290.002443.350.002479.94
Jai, Nichole, R,2834868.490.000.000.0068.49
Holt, Alisha,2835013.980.000.000.0013.98
Hu, Leah,119948169.030.003374.990.004794.04
Garcia, Ruben,196136093.200.003578.270.002514.93
Shen, Karl, M,151514344.090.000.002049.102294.99
Vazquez, Theresa, F,225812749.320.000.002181.56567.76
Chapman, Jodi, L,229663917.540.000.002181.561735.98
Butler, Austin, W,1829374.240.000.0074.240.00
_SUM9051988.22606184.732359497.702477319.573608986.22
Sai, Ann,273391336.960.000.00782.99553.97
Malhotra, Phillip, J,2197774.980.000.000.0074.98
Gomez, Danny, V,166365932.743578.270.000.002354.47
Suri, Evelyn, A,2122356.980.000.0056.980.00
Perez, Rachael, D,26762133.490.000.000.00133.49
Rai, Colleen,2893329.480.000.000.0029.48
Turner, Rebecca, W,276991155.480.000.000.001155.48
Anand, Ricardo,2138369.990.000.000.0069.99
Lin, Wesley,2140742.280.000.0042.280.00
Lin, Darryl, J,1503141.270.000.0032.288.99
Navarro, Mallory,243653331.030.000.002181.561149.47
Li, Glenn, A,292952384.070.000.000.002384.07
Gill, Alberto, P,177334758.240.003578.270.001179.97
Ramos, Randall,215724659.900.002181.560.002478.34
Tang, Christy, R,236603917.540.000.002181.561735.98
Vance, Kristi, T,2833847.970.000.000.0047.97
Chander, Misty,1733380.940.000.000.0080.94
Gao, Erica, R,1908747.200.000.0047.200.00
Tang, Bridget,177304752.230.003578.270.001173.96
Sullivan, Henry, L,2060323.780.000.000.0023.78
Gao, Micah, W,251062170.920.000.001000.441170.48
Green, Jennifer,125712641.390.002071.420.00569.97
Ma, Bianca,19798128.440.000.0060.4767.97
Chandra, Jarrod,241713006.310.000.002443.35562.96
Shen, Michele,27985539.990.000.000.00539.99
Raman, Ronald, M,17077138.450.000.0088.4649.99
Guo, Micah, M,241632756.540.000.002181.56574.98
Zhao, Rosa, A,1967274.980.000.000.0074.98
Kumar, Gilbert, L,2814039.980.000.000.0039.98
Cox, Jared, E,28114570.470.000.00570.470.00
Yang, Jon, V,110008248.993399.990.002341.972507.03
Moreno, Larry, W,282072461.550.000.002461.550.00
Xie, Dustin,2220442.280.000.000.0042.28
Black, Wayne, E,250567.280.000.000.007.28
Suri, Mayra, M,157294393.700.000.002071.422322.28
Arun, Bryant, C,2045321.490.000.0021.490.00
Sai, Ruth, D,244613302.050.000.002181.561120.49
Xie, Chad, A,26155128.970.000.000.00128.97
Jai, Karla,18263126.940.000.0034.9991.95
Saunders, Ruben, G,27983539.990.000.000.00539.99
Sullivan, Dominic, M,2284037.290.000.000.0037.29
Luo, Priscilla, R,1790727.770.000.000.0027.77
Yuan, Colin,1175858.050.000.0024.4933.56
Sanz, Walter, J,1819594.470.000.000.0094.47
Perez, Allen, B,1422974.980.000.000.0074.98
Powell, Kaitlyn,195985310.530.003578.270.001732.26
Andersen, Jenny,202596029.570.003578.270.002451.30
Malhotra, Joel, E,1634358.250.000.000.0058.25
Coleman, Melanie, H,1563934.570.000.000.0034.57

Generated 2025-11-01 00:04:54.476 UTC