[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
Flores, Antonio, D,142593630.930.000.002888.58742.35
Coleman, Ethan, G,166936060.503578.270.002482.230.00
Patel, Marco, L,1957560.050.000.0023.7836.27
Guo, Jake, P,1996998.450.000.0098.450.00
Zeng, Claudia, M,166964506.763578.270.00928.490.00
Roberts, Jennifer,114478078.023374.990.004703.030.00
Reed, Kimberly, D,1731169.970.000.000.0069.97
Zhou, Jon, L,110608153.023399.990.004753.030.00
Suri, Gerald,13617116.920.000.0062.9453.98
Suri, Cesar,175124170.543578.270.00592.270.00
Deng, Colleen, S,2772867.490.000.000.0067.49
Ms., Sandidge, Mary, R.,14016121.060.000.000.00121.06
Ashe, Barbara,1873424.270.000.0021.982.29
Lopez, Mayra, E,273561336.960.000.001336.960.00
Zhu, Gilbert,1192163.240.000.000.0063.24
Mehta, Mayra,129985694.900.002049.101249.842395.96
Raji, Brendan,131036842.600.002049.102395.452398.05
Zhu, Christy,110038139.293399.990.004739.300.00
Carlson, Marie,29311603.960.000.000.00603.96
Yuan, Kelsey, D,1303494.710.000.0035.2359.48
Suarez, Hector, L,15034103.450.000.008.9994.46
West, James, M,1514890.750.000.0090.750.00
Edwards, Evan, L,218884925.580.002443.350.002482.23
Raje, Terrence,182466030.613578.270.002452.340.00
Dominguez, Ebony, R,17350127.470.000.0034.9992.48
Goel, Marshall, M,27691603.490.000.000.00603.49
Ramos, Eddie, T,13954128.460.000.0024.99103.47
Sharma, Kelvin, D,266551322.980.000.001322.980.00
Chande, Casey,2614978.980.000.000.0078.98
Sai, Cesar,182436058.213578.270.002479.940.00
Chander, Lindsay, R,1997249.700.000.000.0049.70
Malhotra, Joel, E,1634358.250.000.0036.2721.98
Vazquez, Francis, E,1728183.970.000.000.0083.97
Xylaras, Ioannis,202155279.260.003578.271700.990.00
Chander, Carl,14315109.710.000.0074.4835.23
Stone, Colin, K,126736768.140.002049.102334.972384.07
Blanco, Brandi, L,209867.280.000.000.007.28
Jimenez, Latasha, E,13121121.250.000.0054.9966.26
Patel, Arthur, B,2667169.990.000.000.0069.99
Blanco, Kristi,1546437.270.000.000.0037.27
Zhou, Brent,1543432.280.000.0029.992.29
Raje, Gilbert,110558168.013374.990.004793.020.00
Gill, Lawrence, J,2022444.460.000.000.0044.46
Huang, Jake,1958995.260.000.0062.9832.28
Sanz, Craig, M,2199374.980.000.0074.980.00
Navarro, Melinda,114548089.040.003374.994714.050.00
Chandra, Monica, H,1889874.980.000.0074.980.00
Smith, Arthur,182406098.583578.270.002520.310.00
Ruiz, Shannon,208224134.530.003578.27556.260.00
Xu, Kathryn,2521023.780.000.0023.780.00
Perez, Johnathan, D,204264139.750.003578.27561.480.00
Chandra, Ann,182096056.613578.270.002478.340.00
Lewis, Kayla,120133949.970.003399.99549.980.00
Kumar, Alison,212003932.540.002181.560.001750.98
Serrano, Natasha,255631239.09699.100.000.00539.99
She, Jerry, C,142775196.740.000.002876.752319.99
Sanchez, Andre,155954369.090.000.002049.102319.99
Luo, Casey,110728194.003399.990.004794.010.00
Perez, Henry,267521917.460.000.00782.991134.47
Vazquez, Andy,196205279.260.003578.271700.990.00
Gutierrez, Philip, M,219793936.540.002181.560.001754.98
Gonzalez, George, L,119424792.290.003399.99614.96777.34
Gutierrez, Jill, N,260241952.450.00782.990.001169.46
Alonso, Stacy,28315556.930.000.00556.930.00
Huang, Rosa, P,151814448.380.000.002071.422376.96
Nara, Tara,211943911.530.002181.560.001729.97
Carlson, Jonathon, N,1707378.970.000.000.0078.97
Liang, Darryl,266581390.950.000.001390.950.00
Luo, Priscilla, R,1790727.770.000.000.0027.77
Allen, Luis, C,260191957.470.00782.990.001174.48
Suri, Mayra, M,157294393.700.000.002071.422322.28
Kapoor, Ruben, D,111098245.013374.990.004870.020.00
Xu, Kristen,157514446.400.000.002071.422374.98
Munoz, Anne,1579898.960.000.0098.960.00
Chavez, Clayton,219494659.900.002181.560.002478.34
Suarez, Jacquelyn, C,110108088.043399.990.004688.050.00
Nara, Calvin, J,1136786.260.000.0058.9827.28
Diaz, Cheryl, A,110928110.023374.990.004735.030.00
Raji, Dale,1926542.280.000.000.0042.28
Johnson, Emma, M,1513662.270.000.0034.9927.28
Becker, Gregory, M,131046894.440.002071.422394.972428.05
Carlson, Audrey, A,2526360.470.000.000.0060.47
Hill, Kaylee, L,119188204.990.003399.992411.942393.06
Munoz, Felicia, D,2040659.980.000.000.0059.98
Yang, Warren, F,1790835.720.000.0035.720.00
Flores, Brianna,27706553.970.000.000.00553.97
Lopez, Francisco, L,1871424.270.000.0024.270.00
Liu, Glenn,188994118.263578.270.00539.990.00
Ruiz, Frank, M,142603716.230.000.002964.89751.34
Blanco, Monique, W,141033612.220.000.002855.89756.33
Ramos, Audrey,119768087.310.003374.992319.262393.06
She, Lindsay,29456765.320.000.000.00765.32
Raman, Veronica, R,1235995.740.000.000.0095.74
Martinez, Emma,16734128.970.000.00128.970.00
Raji, Lacey, E,1634188.250.000.000.0088.25
Chen, Louis, J,17059123.960.000.0069.9753.99
Lopez, Patricia,2830529.480.000.000.0029.48
Ruiz, Melody,13621167.400.000.000.00167.40
Martinez, Virginia,1313662.270.000.0027.2834.99
Alexander, Alyssa, M,1728237.270.000.000.0037.27
Martinez, Anna, J,129946855.440.002071.422364.962419.06
Gao, Stacey,166624355.713578.270.00777.440.00
Xu, Kelvin,18305160.550.000.0036.59123.96
Alonso, Jonathon, A,1523898.960.000.0034.9963.97
Zhou, Steve, C,2026321.490.000.000.0021.49
Martin, Jay,1959733.980.000.0033.980.00
Shen, Katrina,158014381.380.000.002049.102332.28
Gomez, Felicia, J,182196038.563578.270.002460.290.00
Luo, Mario, L,257111274.080.00699.100.00574.98
Sun, Franklin,196155279.260.003578.271700.990.00
Serrano, Marvin, E,1731697.450.000.000.0097.45
Johnson, Logan, K,229313882.550.002181.561700.990.00
Clark, Sydney,1661067.580.000.0067.580.00
Chander, Edwin, T,173704742.743578.270.001164.470.00
Ramos, Mary, B,1501972.960.000.008.9963.97
Rodriguez, Kristi,143453639.920.000.002897.57742.35
Mehta, Edgar,117618149.490.003399.992356.442393.06
Thomas, Sydney,143225111.440.000.002049.103062.34
Gutierrez, Meredith, T,111118137.003399.990.002318.962418.05
Kumar, Katie, P,123416840.620.002049.102294.992496.53
Tang, Leonard, L,28109778.620.000.00778.620.00
Sun, Todd,2201876.970.000.0076.970.00
Sai, Cassandra, R,28110845.310.000.00845.310.00
Sanz, Jimmy,25810114.460.000.00114.460.00
Gutierrez, Jay, C,13155226.950.000.00217.968.99
Beck, Alejandro,110256576.803374.990.002405.47796.34
Lu, Ramon, B,1673844.950.000.0044.950.00
Kapoor, Troy, E,2461039.980.000.000.0039.98
Alexander, Hailey, C,1966635.000.000.000.0035.00
Carlson, Shannon, C,110098091.333374.990.004716.340.00
Wood, Fernando, K,242539.990.000.000.009.99
Sanz, Cheryl, G,140465645.240.000.003340.262304.98
Romero, Wendy, H,113724965.813374.990.000.001590.82
Alexander, Elizabeth,130896800.450.002071.422309.972419.06
Sun, Edwin, O,2117074.980.000.000.0074.98
Ye, Leah,110778169.033374.990.004794.040.00
Gao, Lisa, A,197534.990.000.000.004.99
Torres, Mathew, L,189004132.240.003578.27553.970.00
Zhu, Damien, M,1582243.210.000.0014.2328.98
Alvarez, Tyrone, K,27693539.990.000.000.00539.99
Zhu, Tiffany,264371953.470.00782.990.001170.48
Suarez, Billy, M,1728795.260.000.0032.2862.98
Ramos, Dana, D,259191248.080.00699.100.00548.98
Rana, Johnathan, R,2749737.290.000.0037.290.00
Navarro, Renee,157934369.090.000.002049.102319.99
Gonzalez, Phillip, N,182076089.593578.270.002511.320.00
Rai, Willie,146735117.750.000.002071.423046.33
Gill, Jay,2797583.470.000.000.0083.47
He, Brent, R,257121262.060.00699.100.00562.96
Johnson, Elizabeth,110048196.013399.990.004796.020.00
Martin, Reginald,14054210.770.000.000.00210.77
Navarro, Janet, J,28320539.990.000.00539.990.00
Gill, Theodore,1114941.260.000.007.2833.98
Gonzalez, Francisco, L,122453967.260.003399.99567.270.00
Lin, Dennis,161694404.080.000.002049.102354.98
Rodriguez, Pamela,29065777.340.000.00777.340.00
Tang, Nina,274851354.710.000.00782.99571.72
Ruiz, Julio,110058121.333374.990.004746.340.00
Carlson, Orlando, J,118938123.030.003374.992319.992428.05
Navarro, Kathleen, J,192694118.260.003578.27539.990.00
Gonzalez, Donald,1107932.960.000.009.9922.97
Wu, Aimee,16690165.070.000.000.00165.07
Rodriguez, Geoffrey,208174118.260.003578.27539.990.00
Butler, Carson, T,12672381.970.000.00381.970.00
Jimenez, Krista,18257115.950.000.00106.968.99
Washington, Julian, C,2333031.970.000.0031.970.00
Garcia, Frederick, J,16489112.730.000.00112.730.00
Shan, Connor, C,1890135.000.000.0035.000.00
Sanders, Charles, E,21967123.960.000.000.00123.96
Lin, Karen,2424348.970.000.0048.970.00
Li, Alejandro, A,2751978.980.000.000.0078.98
Suarez, Erika,151205217.700.000.002049.103168.60
Hernandez, Frank, G,221984661.500.002181.560.002479.94
Sanders, Kaylee, C,202216035.600.003578.272457.330.00
She, Katie, B,11965118.740.000.0094.2524.49
Mehta, Arthur, A,199576035.600.003578.272457.330.00
Chen, Aimee,265911957.470.000.00782.991174.48
Vazquez, Jimmy, D,123486906.090.002049.102423.952433.04
Moreno, Marc,130242665.060.002049.100.00615.96
Liu, Jessie,111068079.053399.990.004679.060.00
Gomez, Ricky,187376021.620.003578.272443.350.00
Sara, Ruben, A,19566164.910.000.00164.910.00
Kapoor, Regina,1581067.170.000.0034.8932.28
Liang, Vincent,204024.990.000.004.990.00
Suri, Molly,1750398.960.000.000.0098.96
Rana, Raymond,251152155.920.000.002155.920.00
Ferrier, Mathew,2342639.980.000.000.0039.98
Vazquez, Rodney, M,13047241.930.000.000.00241.93
Lopez, Kristi,281377.280.000.000.007.28
Butler, Austin, W,1829374.240.000.0074.240.00
Subram, Evelyn, S,212574144.340.002443.350.001700.99
Torres, Sebastian, V,258311882.570.00699.100.001183.47
Perez, Evelyn,143463583.260.000.002071.421511.84
Hernandez, Bruce,179194733.753578.270.000.001155.48
Shen, Lindsey,265601396.440.00782.990.00613.45
Sanz, Mathew, L,1455763.970.000.0063.970.00
Zeng, Brittney, K,13670178.450.000.0054.47123.98
Nara, Michele, R,2284286.460.000.0086.460.00
Green, Kyle,283284.990.000.000.004.99
Jai, Tommy, C,150272853.570.000.002049.10804.47
Suri, Adriana,184634726.043578.270.000.001147.77
Malhotra, Ross, R,2930714.980.000.0014.980.00
Madan, Carla, D,28135548.980.000.000.00548.98
Luo, Colleen, E,152082951.560.000.002049.10902.46
Ms., Robinson, Rebecca, A.,1191341.260.000.000.0041.26
Rowe, Jacquelyn, I,13615146.910.000.0086.9359.98
Serrano, Audrey,183376021.623578.270.000.002443.35
Wu, Mandy,183096090.593578.270.002512.320.00
Chandra, Troy,2140674.980.000.0074.980.00
Moreno, Tanya,1113983.970.000.000.0083.97
Subram, Ann, M,186936021.623578.270.002443.350.00
Arun, Candace, J,213934925.170.002443.350.002481.82
She, Colin, M,1513959.980.000.0059.980.00
Lin, Mandy, C,250352183.910.000.002183.910.00
Moore, Lucas, J,1502138.980.000.0029.998.99
Vazquez, Juan, P,225782735.530.002181.56553.970.00
Sanz, Linda, P,2294512.940.000.0012.940.00
Travers, Reginald,28488742.350.000.00742.350.00
Goel, Peter, L,1526438.980.000.008.9929.99
Lopez, Kristopher, L,215604702.390.002181.560.002520.83
Xu, Alan,167416056.613578.270.002478.340.00
Gao, Erica, R,1908747.200.000.0047.200.00
Malhotra, Brett, E,187316054.060.003578.272475.790.00
Xie, Casey,212174659.900.002181.560.002478.34
Sai, Lydia, L,139685181.700.000.002862.742318.96
Chander, Cassie, M,1825845.950.000.0036.968.99
Serrano, Mallory, E,267511903.480.000.00782.991120.49
Lin, Suzanne,292874.990.000.004.990.00
Ashe, Orlando, I,118978203.020.003399.992329.982473.05
Hu, Aimee, R,2798139.980.000.0039.980.00
Alvarez, Philip, A,1112345.880.000.0037.937.95
Gutierrez, Victor, J,2735769.990.000.000.0069.99
Alvarez, Randall,267501938.470.000.00782.991155.48
Ma, Colin,2642869.990.000.000.0069.99
Wilson, Edward, L,265621925.410.00782.990.001142.42
Deng, Kurt, D,13635215.740.000.0032.27183.47
Martin, Diane,139586838.640.002049.100.004789.54
Raman, Ruth, L,211994144.340.002443.350.001700.99
Powell, Trevor, C,269221322.980.000.00782.99539.99
Watson, Nathaniel, H,258261854.580.00699.100.001155.48
Vazquez, Jonathon,1790621.490.000.000.0021.49
Raji, Brad, C,234093917.540.002181.561735.980.00
Zheng, Alisha,222034624.910.002181.560.002443.35
Andersen, Kelvin, C,2136639.980.000.0039.980.00
Tang, Julie,265891966.460.000.00782.991183.47
Liu, Krystal, D,135264549.760.000.004549.760.00
Perez, Kyle, J,161804386.370.000.002049.102337.27
Gutierrez, Jonathon, R,165294752.753578.270.001174.480.00
Prasad, Jarrod,113594960.073374.990.000.001585.08
Zhou, Clayton,273481382.460.000.001382.460.00

Generated 2026-07-21 07:48:50.468 UTC