[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
Martin, Pedro, B,281031214.850.000.000.001214.85
Zhao, Heather,245964168.830.000.002443.351725.48
Deng, Kenneth,2023534.980.000.000.0034.98
Gonzales, Hunter,265701957.470.00782.990.001174.48
Rodriguez, Evelyn,131176831.420.002049.102344.262438.06
Dominguez, Jerome, F,229873942.030.002181.560.001760.47
Li, Krystal, A,249122120.930.001000.441120.490.00
Thompson, Justin,229544179.330.002443.351735.980.00
Suri, Lydia,131266815.080.002049.100.004765.98
Vazquez, Casey, S,131326880.620.002049.102369.972461.55
Chen, Crystal, M,265662016.950.00782.990.001233.96
Yuan, Julie,229593917.540.002181.560.001735.98
Ortega, Eddie,229084661.500.002181.560.002479.94
Johnson, Logan, K,229313882.550.002181.561700.990.00
Parker, Timothy, C,229434144.340.002443.350.001700.99
Guo, Jaclyn,131196829.450.002071.420.004758.03
Fernandez, Brandy, B,229584208.310.002443.350.001764.96
Lal, Barbara, W,231012795.010.002181.560.00613.45
Nelson, Carol,135204551.360.002071.422479.940.00
Ramos, Joy,131296823.150.002049.100.004774.05
Ramos, Kristine,17479163.400.000.00163.400.00
Lu, Glenn,12692156.260.000.006.28149.98
Vance, Kristi, T,2833847.970.000.0047.970.00
Gonzalez, Tina,196535314.250.003578.271735.980.00
Madan, Candace,224092746.040.002181.56564.480.00
Guo, Jake, P,1996998.450.000.0098.450.00
Navarro, Cheryl,131095682.900.002049.100.003633.80
Jai, Carly,229862756.540.002181.560.00574.98
Cook, Sydney, D,131185669.900.002049.100.003620.80
Cox, Nicole, V,229503917.540.002181.561735.980.00
Chapman, Jodi, L,229663917.540.002181.561735.980.00
Miller, Dalton, D,131306797.150.002049.102354.992393.06
Patel, Stanley, L,249152145.920.001000.441145.480.00
She, Keith, L,265631957.470.00782.990.001174.48
Moreno, Kristi,234153588.830.002443.351145.480.00
Subram, Joe,136316817.120.002049.100.004768.02
Yuan, Willie,234214208.310.002443.350.001764.96
Ramos, Danny,231214144.340.002443.351700.990.00
Wu, Brittney,234183400.020.002181.561218.460.00
Carlson, Ebony,139596858.420.002049.100.004809.32
Raji, Brad, C,234093917.540.002181.561735.980.00
Ye, Damien, M,136206848.070.002049.100.004798.97
Sai, Ronald, B,136436799.450.002071.420.004728.03
Moreno, Bruce, F,266521938.470.00782.990.001155.48
Raman, Ruben,155802910.900.000.002071.42839.48
Huang, Dawn, E,119434734.290.003374.99539.99819.31
Sun, Suzanne, P,245873882.550.000.002181.561700.99
Zhang, Dawn, A,1422282.260.000.000.0082.26
Blanco, Kristi,1546437.270.000.000.0037.27
Rai, Shaun,2643123.780.000.000.0023.78
Alonso, Krista, P,20212100.740.000.0023.7876.96
Anderson, Richard, G,249242143.900.001000.441143.460.00
Andersen, Tonya, N,135274529.040.002049.100.002479.94
Jimenez, Naomi,249222145.920.001000.441145.480.00
Pal, Dustin,265881938.470.00782.990.001155.48
Deng, Deborah,233242730.540.002181.56548.980.00
Raman, Jay, M,136186763.150.000.004344.092419.06
She, Jessie, A,136506768.140.000.004384.072384.07
Lal, Corey, H,233132906.030.000.002181.56724.47
Madan, Johnathan, D,136266909.090.000.004436.042473.05
Coleman, Dalton, M,234123586.810.000.003586.810.00
Ramirez, Cole, E,136166872.060.000.002049.104822.96
Alvarez, Diana,136386832.120.000.002049.104783.02
Liang, Darryl,266581390.950.000.001390.950.00
Lopez, Mayra, E,273561336.960.000.001336.960.00
Liu, Krystal, D,135264549.760.000.004549.760.00
Shan, Bethany, L,139735185.680.000.002835.702349.98
Yuan, Kelsey, D,1303494.710.000.0035.2359.48
West, James, M,1514890.750.000.0090.750.00
Xu, Arturo,136196808.100.000.002049.104759.00
Malhotra, Joel, E,1634358.250.000.0036.2721.98
Chen, Tiffany, A,233484167.310.000.004167.310.00
Sharma, Kelvin, D,266551322.980.000.001322.980.00
Xylaras, Ioannis,202155279.260.003578.271700.990.00
Zhu, Dawn,266611912.470.000.00782.991129.48
Zimmerman, Tiffany, E,233252997.320.000.002443.35553.97
Moyer, Mario,234204144.340.000.004144.340.00
Raje, Gilbert,110558168.013374.990.004793.020.00
Gray, Jeremiah,233314144.340.000.004144.340.00
Xu, Kathryn,2521023.780.000.0023.780.00
Hernandez, Gina,140495290.680.000.002947.752342.93
Yuan, Mitchell,267441938.470.000.00782.991155.48
Martinez, Monica, A,141293750.090.000.003750.090.00
Patel, Jillian,266671390.950.000.001390.950.00
Blanco, Monique, W,141033612.220.000.002855.89756.33
Roberts, Jordan,234324179.330.000.002443.351735.98
Powell, Alexis, M,235313337.280.000.003337.280.00
Suarez, Dana, M,235413337.040.000.003337.040.00
Chandra, Arthur, L,140326859.430.000.002071.424788.01
Sharma, Edwin, K,250211554.410.000.001000.44553.97
Lin, Mandy, C,250352183.910.000.002183.910.00
Diaz, Samuel,140655608.550.000.003286.272322.28
Yang, Ronnie,235243598.830.000.003598.830.00
Sanz, Cheryl, G,140465645.240.000.003340.262304.98
Foster, Madison,140386819.120.000.002049.104770.02
Romero, Latasha,142205696.190.000.002071.423624.77
Moore, Thomas,140103861.390.000.003861.390.00
Li, Jack, J,140715617.920.000.003297.932319.99
Harris, Ian, W,141283836.380.000.003836.380.00
Ross, Brandon,141323804.080.000.003804.080.00
Serrano, Francis, R,235473598.830.000.003598.830.00
Jai, Kathryn,235463337.040.000.003337.040.00
Serrano, Joanna, J,266631976.940.000.00782.991193.95
Chen, Rosa,234353917.540.000.002181.561735.98
Chander, Karla,236484144.340.000.002443.351700.99
Vazquez, Eddie, T,140125249.920.000.002826.442423.48
Raje, Misty, A,235443971.010.000.002181.561789.45
Kumar, Warren, A,240032806.530.000.002181.56624.97
Rodriguez, Kristi,143453639.920.000.002897.57742.35
Thomas, Sydney,143225111.440.000.002049.103062.34
Guo, Cedric, R,274871322.980.000.00782.99539.99
Munoz, Sheila,274881322.980.000.00782.99539.99
Johnson, Morgan, E,120114735.810.003374.99618.47742.35
Dominguez, Raquel, A,274701371.950.000.00782.99588.96
Anand, Jodi,2612921.490.000.000.0021.49
Simmons, Jordyn,164945961.203578.270.000.002382.93
Nara, Jaclyn, M,119305035.810.003399.990.001635.82
Sai, Francisco, W,187664752.750.003578.270.001174.48
Gonzalez, Virginia,119294965.780.003374.990.001590.79
Vazquez, Andy,196205279.260.003578.271700.990.00
Alonso, Stacy,28315556.930.000.00556.930.00
Munoz, Anne,1579898.960.000.0098.960.00
Jimenez, Julio,240052756.540.000.002181.56574.98
Andersen, Colin,250532183.910.000.002183.910.00
Alvarez, Marvin,236513917.540.000.002181.561735.98
Suarez, Melody, H,142765259.360.000.002864.912394.45
Gill, Leslie,146702919.890.000.002919.890.00
She, Tamara, M,142245621.220.000.002049.103572.12
Shen, Grant, B,267631957.470.000.00782.991174.48
Munoz, Monique,240082730.540.000.002181.56548.98
He, Colin, B,143005322.730.000.002071.423251.31
Wang, Micah, C,146765188.410.000.002049.103139.31
Dominguez, Neil, K,236633882.550.000.002181.561700.99
Huang, Randy,240073042.820.000.002443.35599.47
Gomez, Jerome, J,250572120.930.000.002120.930.00
Ross, Arianna, E,267741331.970.000.001331.970.00
Wu, Jamie, S,2759564.470.000.000.0064.47
Mehta, Ebony, J,228544659.900.002181.560.002478.34
Sun, Louis, E,1618283.970.000.0058.9824.99
Garcia, Levi, G,2123239.980.000.000.0039.98
She, Jerry, C,142775196.740.000.002876.752319.99
Richardson, Abigail, S,142365710.230.000.002071.423638.81
Alexander, Olivia, L,146675295.410.000.002049.103246.31
Subram, Raymond,239942790.520.000.002181.56608.96
Li, Gilbert,239992730.540.000.002181.56548.98
Diaz, Josue,152074446.400.000.002071.422374.98
Jones, Destiny,151714392.020.000.002049.102342.92
Lopez, Virginia, J,273381339.920.000.001339.920.00
Chander, Melvin, L,242662749.320.000.002181.56567.76
King, Mackenzie, M,269161322.980.000.00782.99539.99
Serrano, Deanna, W,151444344.090.000.002049.102294.99
Zhao, Colin, D,242412997.320.000.002443.35553.97
Howard, Jesse, D,242492756.540.000.002181.56574.98
Weber, Cynthia,269211336.960.000.00782.99553.97
Luo, Colleen, E,152082951.560.000.002049.10902.46
Luo, Kenneth, S,152112910.900.000.002071.42839.48
Lin, Jake,242482770.520.000.002181.56588.96
Jai, Tommy, C,150272853.570.000.002049.10804.47
Martinez, Emma,16734128.970.000.00128.970.00
Chen, Louis, J,17059123.960.000.0069.9753.99
Alonso, Jonathon, A,1523898.960.000.0034.9963.97
Martin, Jay,1959733.980.000.0033.980.00
Sun, Franklin,196155279.260.003578.271700.990.00
Chander, Edwin, T,173704742.743578.270.001164.470.00
Sun, Todd,2201876.970.000.0076.970.00
Sanz, Jimmy,25810114.460.000.00114.460.00
Rubio, Jay,151794444.890.000.002071.422373.47
Rana, Raymond,251152155.920.000.002155.920.00
Suarez, Erika,151205217.700.000.002049.103168.60
Chandra, Jarrod,241713006.310.000.002443.35562.96
Wang, Martha, D,242722735.530.000.002181.56553.97
Patterson, Jennifer, M,151295177.730.000.002071.423106.31
Ortega, Latasha,242702844.510.000.002181.56662.95
Shen, Leonard, J,242712745.330.000.002181.56563.77
Hu, Valerie, M,150443803.560.000.002049.101754.46
Chander, Keith, A,241742983.340.000.002443.35539.99
Suri, Carmen, E,242502738.490.000.002181.56556.93
Lopez, George,150403807.400.000.002071.421735.98
Romero, Frank, M,152092916.560.000.002049.10867.46
Raman, Meagan, J,151345151.710.000.002071.423080.29
Li, Edwin,269671336.960.000.001336.960.00
Yang, Cedric,150383750.090.000.002049.101700.99
Romero, Renee, E,166395908.253578.270.000.002329.98
Gonzalez, George, L,119424792.290.003399.99614.96777.34
Martinez, Frederick,119918128.020.003374.992319.992433.04
Hu, Alejandro,13125138.540.000.00104.9833.56
Rodriguez, Rachael, M,119444776.270.003374.99609.96791.32
Gao, Gilbert,241653046.840.000.002443.35603.49
Gonzalez, Edgar, A,156483807.400.000.002071.421735.98
Ye, Alvin, B,155752910.900.000.002071.42839.48
Sai, Ann,273391336.960.000.001336.960.00
Shan, Shaun,242743018.330.000.002443.35574.98
Rai, Tasha, L,243014144.340.000.002443.351700.99
Gill, Javier,156453785.080.000.002049.101735.98
Kapoor, Cesar, J,243023882.550.000.002181.561700.99
Gonzalez, Natalie,252152155.920.000.002155.920.00
Deng, Priscilla, M,251272174.920.000.002174.920.00
Subram, Douglas,273521357.970.000.001357.970.00
Zhou, Clayton,273481382.460.000.001382.460.00
Russell, Seth,251382120.930.000.001000.441120.49
Patel, Deanna, H,273541322.980.000.001322.980.00
Alexander, Elizabeth,130896800.450.002071.422309.972419.06
Ye, Leah,110778169.033374.990.004794.040.00
Suarez, Billy, M,1728795.260.000.0032.2862.98
Rana, Johnathan, R,2749737.290.000.0037.290.00
Navarro, Janet, J,28320539.990.000.00539.990.00
Gonzalez, Francisco, L,122453967.260.003399.99567.270.00
Rodriguez, Pamela,29065777.340.000.00777.340.00
Butler, Carson, T,12672381.970.000.00381.970.00
Washington, Julian, C,2333031.970.000.0031.970.00
Gutierrez, Cheryl, O,252132184.900.000.002184.900.00
Sun, Christy,252182184.900.000.001000.441184.46
Jenkins, Amanda,152144490.880.000.002071.422419.46
Carlson, Francis,273401350.750.000.001350.750.00
Wood, Richard, W,243773945.530.000.002181.561763.97
Jenkins, Angela,157224448.570.000.002049.102399.47
Madan, Roy,157164467.060.000.002049.102417.96
Davis, Morgan, J,273591344.470.000.001344.470.00
Gomez, Naomi, E,243004144.340.000.002443.351700.99
Moreno, Naomi, C,156014429.570.000.002049.102380.47
Goel, Gilbert,155964460.040.000.002049.102410.94
Gill, Anne,274691331.970.000.00782.99548.98
Serrano, Beth,243043946.520.000.002181.561764.96
Luo, Melvin,243664144.340.000.002443.351700.99
Johnsen, Willie,152184399.080.000.002049.102349.98
He, Gilbert,155894416.380.000.002071.422344.96
Jiménez, Brandi,243784173.320.000.002443.351729.97
Andersen, Tara, L,244653356.040.000.003356.040.00
Bryant, Madison, J,16481194.910.000.000.00194.91
Martin, Hector,27860615.470.000.000.00615.47
Alonso, Joanna, M,27862548.980.000.000.00548.98
Lu, Randy,2644178.980.000.000.0078.98
Xie, Kurt, A,14344126.950.000.0063.9762.98
Hall, Haley,274891383.450.000.00782.99600.46
Zhou, Ernest, P,157922645.400.000.002645.400.00
Blanco, Natasha,158084424.080.000.002049.102374.98
Allen, Ian, A,160313750.090.000.002049.101700.99
Guo, Rosa, M,244743882.550.000.002181.561700.99
Guo, Louis, D,157644413.390.000.002071.422341.97
Dominguez, Lee, R,245974009.500.000.002181.561827.94
Rodriguez, Bobby,157524408.690.000.002071.422337.27
Hernandez, Erika,161602644.070.000.002644.070.00
Muñoz, Jaime, C,245063563.840.000.002443.351120.49
Luo, Jerry, M,245864144.340.000.002443.351700.99
Xu, Colin,157902668.380.000.002668.380.00
Hu, Susan,252422120.930.000.001000.441120.49
Shan, Connor, C,1890135.000.000.0035.000.00
Lin, Karen,2424348.970.000.0048.970.00
Sanders, Kaylee, C,202216035.600.003578.272457.330.00
Mehta, Arthur, A,199576035.600.003578.272457.330.00

Generated 2026-07-21 22:31:50.474 UTC