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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2023202420252026
Serrano, Danny,243813970.520.000.002181.561788.96
Sharma, Misty,257081253.07699.100.000.00553.97
Shen, Barbara,220304144.340.002443.350.001700.99
Serrano, Alberto, L,158004399.080.000.002049.102349.98
Ferrier, Linda, D,1314964.970.000.0034.9929.98
Serrano, Marvin, E,1731697.450.000.000.0097.45
Gonzalez, Ann,118948223.000.003374.994848.010.00
Gomez, Randall, R,117628228.010.003399.994828.020.00
Johnsen, Ross,19618119.450.000.0030.4888.97
Xu, Clayton, W,2500149.970.000.0049.970.00
Garcia, Harold, K,14087341.970.000.00341.970.00
Bryant, Lauren,11752137.870.000.0085.9151.96
Perez, Brenda,118998189.500.003374.994814.510.00
Zhu, Jake, G,2460339.980.000.000.0039.98
Zhang, James,1468438.550.000.000.0038.55
Carlson, Clinton, E,11116148.700.000.0027.28121.42
Navarro, Kristine, B,255661253.07699.100.000.00553.97
Moreno, Naomi, C,156014429.570.000.002049.102380.47
Xie, Karla,182014157.733578.270.000.00579.46
Moreno, Tanya,1113983.970.000.000.0083.97
Xu, Lindsey,1558366.260.000.0034.9931.27
Mr., Short, Carlos, M.,2513960.470.000.000.0060.47
Pal, Jenny,15132151.940.000.000.00151.94
Rana, Nancy, H,261501992.460.00782.990.001209.47
Lal, Alicia,157344426.410.000.002071.422354.99
Martin, Reginald,14054210.770.000.000.00210.77
Lin, Dennis,161694404.080.000.002049.102354.98
Chande, Louis, A,1668168.870.000.0068.870.00
Xu, Kelvin,18305160.550.000.0036.59123.96
Alexander, David,1578398.960.000.000.0098.96
Tang, Edwin,204506021.620.003578.270.002443.35
Martinez, Frederick,119918128.020.003374.990.004753.03
Diaz, Frank, F,29086805.330.000.000.00805.33
Li, Alejandro, A,2751978.980.000.000.0078.98
Hernandez, Frank, G,221984661.500.002181.560.002479.94
Rai, Michele, M,265671957.470.00782.990.001174.48
Chen, Aimee,265911957.470.000.00782.991174.48
Shan, Gregory,206146035.600.003578.270.002457.33
Navarro, Eddie, C,245043563.840.000.002443.351120.49
Moore, Olivia, A,252312189.900.000.001000.441189.46
Muñoz, Pedro, A,234333882.550.000.002181.561700.99
Suarez, Rebekah,136496812.130.000.002049.104763.03
Hernandez, Hailey, A,1872786.270.000.000.0086.27
Zhou, Jamie,1732799.940.000.000.0099.94
Lal, Tommy,1451678.980.000.0024.9953.99
Ramos, Joy,131296823.150.002049.100.004774.05
Chande, Tonya,119928123.030.003399.990.004723.04
Luo, Louis,114658158.040.003399.992319.992438.06
Sara, Troy, R,225832821.510.002181.560.00639.95
Sanz, Gerald, J,17060123.960.000.000.00123.96
Hernandez, Jill, L,13003230.250.000.0071.25159.00
Ma, Jorge, O,1405286.260.000.0086.260.00
Chande, Raul, L,2117635.000.000.0035.000.00
Sharma, Julie, R,1819194.470.000.008.9985.48
Guo, Jake, P,1996998.450.000.0098.450.00
Taylor, Jennifer,184706021.623578.270.002443.350.00
Gao, Erica, R,1908747.200.000.0047.200.00
Hu, Aimee, R,2798139.980.000.0039.980.00
Blanco, Rodney, A,201584153.250.003578.27574.980.00
Arun, Bryant, C,2045321.490.000.0021.490.00
Yang, Hunter, E,2023721.490.000.0021.490.00
Miller, Edward,113685106.243374.990.000.001731.25
Long, Mariah, C,1673068.970.000.000.0068.97
Edwards, Kaylee, M,228514632.860.002181.560.002451.30
Sai, Ronald, B,136436799.450.002071.420.004728.03
Rodriguez, Toni, J,2525139.980.000.000.0039.98
Davis, Isabella, A,229294673.880.002181.560.002492.32
Serrano, Audrey,183376021.623578.270.000.002443.35
Raman, Brandy,1224777.270.000.0077.270.00
Moreno, Janet, L,1559259.980.000.0024.9934.99
Shen, Jodi, A,2202869.990.000.0069.990.00
Lu, Sandra, N,135214514.770.002071.422443.350.00
Sanz, Ricky,182516035.603578.270.002457.330.00
Martin, Larry,182546021.623578.270.002443.350.00
Zhang, Jenny, H,246092120.930.001000.441120.490.00
Nath, Michele, L,110568207.503374.990.004832.510.00
Shen, Tamara, G,229353951.520.002181.560.001769.96
Martin, Diane,139586838.640.002049.100.004789.54
Subram, Virginia,130362677.070.002049.100.00627.97
Suri, Holly, M,18286141.550.000.0069.9771.58
Martinez, Cory, A,1512581.260.000.0031.2749.99
Weber, Levi, A,13120205.390.000.0049.48155.91
Zheng, Alisha,222034624.910.002181.560.002443.35
White, Ashley, D,2188739.990.000.0039.990.00
Zheng, Jenny, R,119474747.300.003374.99629.96742.35
Suarez, Daisy, A,182886093.203578.270.002514.930.00
Goel, Karla, L,11146112.930.000.0053.9558.98
Pal, Peter, K,2284839.990.000.0039.990.00
Liang, Steve,1431781.260.000.0049.9931.27
Malhotra, Heidi, A,2642669.990.000.000.0069.99
Sutton, Jaime, L,166305973.243578.270.000.002394.97
Yuan, Terry, R,136466843.600.000.002049.104794.50
Lal, Terrence,1236994.230.000.000.0094.23
Rubio, Max, L,1957891.260.000.0037.2753.99
Alexander, Gail, C,14682138.450.000.0088.4649.99
Xie, Wayne, S,183026029.573578.270.002451.300.00
Jai, Tasha, A,197714167.230.003578.27588.960.00
Nara, Tonya, C,17251123.960.000.00123.960.00
Reed, Riley, A,201574118.260.003578.27539.990.00
Lal, Kenneth, J,187015357.743578.270.001779.470.00
Ma, Cara,18885110.460.000.00110.460.00
Chander, Brad, K,2138269.990.000.0069.990.00
Martin, Felicia, L,15018112.460.000.00112.460.00
Martinez, Jay,245923896.530.000.002181.561714.97
Zhang, Cara,12351117.970.000.0093.4824.49
Tang, Cristina, D,19623153.930.000.0060.4793.46
White, Olivia, E,184574826.233578.270.000.001247.96
Chen, Claudia, R,1662764.880.000.0064.880.00
Guo, Susan, A,2654314.230.000.0014.230.00
Becker, Grant,2139032.280.000.000.0032.28
Perry, Madison, R,233084.990.000.000.004.99
Lin, Dawn, N,15805127.470.000.000.00127.47
Sharma, Donna,119986962.100.003374.991249.842337.27
Huang, Amy, C,12244114.960.000.00114.960.00
Arthur, Kristi, W,166754385.033578.270.00806.760.00
Jai, Jaime, M,248944.990.000.004.990.00
Nara, Katrina, Z,246082120.930.001000.441120.490.00
Moore, Natalie, W,182736104.213578.270.002525.940.00
Vance, Henry,27986553.970.000.000.00553.97
Sanz, Lawrence, M,140306905.470.000.002071.424834.05
Serrano, Shannon, R,183036030.613578.270.002452.340.00
Li, Dawn, B,1396240.220.000.0040.220.00
Serrano, Diane, E,1485787.970.000.0087.970.00
She, Marshall, D,18707122.760.000.00120.472.29
Zhu, Vincent, E,24899105.450.000.00105.450.00
Sanchez, Manuel,1512686.260.000.0058.9827.28
Lal, Julie, A,283092419.060.000.002419.060.00
Rana, Cindy,213677.280.000.007.280.00
Carlson, Ebony,139596858.420.002049.100.004809.32
Blanco, Hector, J,229384173.320.002443.350.001729.97
Zhang, Kristen,274841322.980.000.00782.99539.99
Gonzalez, Cynthia,15787167.930.000.00103.9663.97
Lu, Alan,1976167.930.000.000.0067.93
Wang, Laura, L,2614669.990.000.000.0069.99
Blanco, Jimmy, V,14013138.450.000.00103.4634.99
Pal, Omar,277141155.480.000.000.001155.48
Torres, Alfredo,2768574.980.000.000.0074.98
Rodriguez, Brett,2513439.980.000.000.0039.98
Huang, Dawn, E,119434734.290.003374.99539.99819.31
Jai, Brendan,26755123.980.000.000.00123.98
Zhang, Dawn, A,1422282.260.000.000.0082.26
Blanco, Kristi,1546437.270.000.000.0037.27
Wang, Curtis, A,131085718.660.002071.420.003647.24
Sanz, Sabrina, A,1965042.280.000.000.0042.28
Raje, Donna, A,2060723.780.000.000.0023.78
Munoz, Sheila,274881322.980.000.00782.99539.99
Martin, Natasha, N,274901331.970.000.00782.99548.98
Ms., Sanchez, Madalena, J.,130202589.090.002049.100.00539.99
Simmons, Jordyn,164945961.203578.270.000.002382.93
Foster, Madison,140386819.120.000.002049.104770.02
Johnson, Brianna, J,1731938.980.000.000.0038.98
Lewis, Jasmine,139646806.450.002071.420.004735.03
Wu, Jamie, S,2759564.470.000.000.0064.47
Zhang, Ronnie,166565930.233578.270.000.002351.96
Luo, Devon, D,228504657.510.002181.560.002475.95
Raje, Johnny,139755138.720.000.002841.442297.28
Sai, Levi,163495898.263578.270.000.002319.99
Garcia, Levi, G,2123239.980.000.000.0039.98
Romero, Renee, E,166395908.253578.270.000.002329.98
Munoz, Natasha, M,246013882.550.000.002181.561700.99
Wu, Glenn, R,29343553.970.000.000.00553.97
Zhang, Glenn, A,139675721.910.002049.100.003672.81
He, Karen, C,27861539.990.000.000.00539.99
Rodriguez, Rachael, M,119444776.270.003374.99609.96791.32
She, Mindy, J,13009168.670.000.000.00168.67
Martin, Hector,27860615.470.000.000.00615.47
Prasad, Francisco,16628187.580.000.000.00187.58
Zhou, Gilbert,244753945.530.000.002181.561763.97
Dominguez, Roberto, A,269171339.250.000.00782.99556.26
Navarro, Marc,1634637.550.000.006.2831.27
Cook, Faith,278712384.070.000.000.002384.07
Wang, Rosa, I,119938131.320.003374.990.004756.33
Kumar, Lacey,139606871.740.000.002071.424800.32
Alonso, Kristine,166864157.733578.270.000.00579.46
Zhao, Bianca,139716772.130.000.002049.104723.03
Serrano, Reginald, J,130252690.400.002071.420.00618.98
Ramos, Tanya, R,140456804.130.000.002049.104755.03
Travers, Danny,1258777.270.000.000.0077.27
Kumar, Cedric, B,228604663.790.002181.560.002482.23
Tang, Dawn, R,164965960.233578.270.000.002381.96
Raji, Christy,1558462.270.000.0034.9927.28
Hernandez, Ross,1467781.260.000.0049.9931.27
Chen, Jake,228454633.900.002181.560.002452.34
Luo, Jerry, M,245864144.340.000.002443.351700.99
Arthur, Carla,1671091.260.000.0037.2753.99
Raman, Brett, L,229304900.680.002443.350.002457.33
Ashe, Ebony, E,166125898.263578.270.000.002319.99
Lopez, Mason, E,2292321.980.000.000.0021.98
Lin, Alan,229737.280.000.000.007.28
She, Jessie, A,136506768.140.000.004384.072384.07
King, Mackenzie, M,269161322.980.000.00782.99539.99
Ashe, Kathryn,1616880.110.000.0080.110.00
Kapoor, Kristina,119977029.780.003399.991249.842379.95
Carlson, Armando,17484126.960.000.00126.960.00
Garcia, George,201604237.220.003578.27658.950.00
Chavez, Colin,1603290.950.000.0090.950.00
Li, Kristen, R,15153113.970.000.0088.9824.99
Sun, Karen, C,282082398.050.000.002398.050.00
Carlson, Kristy,282172408.290.000.002408.290.00
Nelson, Carol,135204551.360.002071.422479.940.00
Cai, Gilbert, J,1825698.960.000.0063.9734.99
Patel, Jay,2221359.270.000.0059.270.00
Andersen, Mitchell, H,250266.280.000.006.280.00
Xu, Colin,157902668.380.000.002668.380.00
Mehta, Preston, G,186926035.603578.270.002457.330.00
Ma, Lacey, K,187235279.260.003578.271700.990.00
Tang, Rafael, A,119088079.050.003374.992319.992384.07
Sun, Jaclyn,1821165.960.000.0056.978.99
Gao, Rafael, R,1873324.270.000.0024.270.00
Xu, Colleen, C,18325108.850.000.00108.850.00
Lin, Laura, L,114628116.330.003374.992322.282419.06
Nara, Johnny, R,184896081.103578.270.002502.830.00
Campbell, Seth,187166021.620.003578.272443.350.00
Sanz, Roy, R,119178121.330.003399.992337.272384.07
Zhu, Louis,14858196.970.000.00187.988.99
White, Kayla,2642479.470.000.0079.470.00
Martin, Naomi, A,15593116.260.000.0088.9827.28
Anand, Katrina, L,187265314.250.003578.271735.980.00
Harris, Ian, W,141283836.380.000.003836.380.00
Perez, Ebony, M,249002155.920.001000.441155.480.00
Zheng, Jamie, L,2215669.990.000.0069.990.00
Alvarez, Erik, M,14311138.450.000.0074.4863.97
Andersen, Tracy,208154118.260.003578.27539.990.00
Alvarez, Reginald, A,187466135.093578.270.002556.820.00
Ortega, Dwayne, C,246152155.920.001000.441155.480.00
Zeng, Claudia, M,166964506.763578.270.00928.490.00
Sharma, Keith,1572863.970.000.0028.9834.99
Lu, Martha, R,2125532.280.000.0032.280.00
Nelson, Kaitlyn, J,2427623.970.000.0023.970.00
Jiménez, Deanna,28115562.960.000.00562.960.00
Lewis, Kayla,120133949.970.003399.99549.980.00
Lu, Christy,1706291.260.000.0091.260.00
Parker, Evan, R,187295333.250.003578.271754.980.00
Yang, Ronnie,235243598.830.000.003598.830.00
Zhao, Randy, J,278741288.310.000.001288.310.00
Zhou, Stacey, L,213747.280.000.007.280.00
Ramos, Audrey,119768087.310.003374.992319.262393.06
Martinez, Brett,235323337.040.000.003337.040.00
Clark, Madison, A,140625647.920.000.003272.942374.98
Gill, Eddie, J,1271574.540.000.0064.979.57
Andersen, Nicolas, A,2759439.980.000.0039.980.00
Mehta, Edgar,117618149.490.003399.992356.442393.06
She, Melvin,165164733.753578.270.001155.480.00
Raje, Karla,289367.280.000.007.280.00
Huang, Alejandro,114648128.510.003374.994753.520.00
Carlson, Orlando, J,118938123.030.003374.992319.992428.05
Diaz, Tyrone,13116230.250.000.0032.27197.98
Butler, Katherine, F,267601322.980.000.001322.980.00
Shan, Eric, L,2677169.990.000.0069.990.00
Jimenez, Krista,18257115.950.000.00106.968.99

Generated 2026-07-22 10:27:52.269 UTC