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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Fernandez, Donald, C,244623617.830.000.002443.351174.48
Zhu, Erica,252212143.900.000.001000.441143.46
Madan, Roy,157164467.060.000.002049.102417.96
Gomez, Naomi, E,243004144.340.000.002443.351700.99
Jimenez, Teresa, L,243723356.040.000.002181.561174.48
Raji, Damien, K,242823917.540.000.002181.561735.98
Goel, Gilbert,155964460.040.000.002049.102410.94
Sara, Tina,243074158.320.000.002443.351714.97
Jiménez, Brandi,243784173.320.000.002443.351729.97
Hill, Aaron,2581835.960.000.000.0035.96
Ashe, Jimmy, S,2895914.980.000.000.0014.98
Serrano, Dana, S,12678341.430.000.000.00341.43
Gomez, Erik, T,291802452.040.000.000.002452.04
Goel, Mario, J,123606750.480.002071.420.004679.06
Hu, Alvin, E,114498130.320.003374.992362.272393.06
Fernandez, Candace,111058095.990.003399.992294.992401.01
Liu, Jessie,111068079.050.003399.992294.992384.07
Gao, Todd, M,110618129.023374.990.002369.962384.07
Ramos, Marc,182126029.570.003578.272451.300.00
Lal, Tara, S,186975279.260.003578.271700.990.00
Gutierrez, Erika,1722783.970.000.000.0083.97
Romero, Deanna, K,2357021.980.000.000.0021.98
Suri, Stanley, J,2749642.280.000.000.0042.28
Chande, Ashlee, N,230967.280.000.000.007.28
Perez, Rachael, D,26762133.490.000.000.00133.49
Andersen, Deborah,19610118.940.000.000.00118.94
Liang, Tiffany,11068113.360.000.000.00113.36
Lu, Micah,221743007.830.000.002443.35564.48
Arun, Nancy, C,211694647.880.002181.560.002466.32
Foster, Madison,140386819.120.000.002049.104770.02
She, Nichole, M,119098105.310.003374.990.004730.32
Bailey, Savannah, J,2342839.980.000.000.0039.98
Gutierrez, Orlando,259201819.590.00699.100.001120.49
Kumar, Warren, A,240032806.530.000.002181.56624.97
Diaz, Marc,110588248.023399.990.002374.982473.05
Raman, Patricia, T,167026021.623578.270.002443.350.00
Sanchez, Levi, A,27745617.470.000.00617.470.00
Sharma, Kelvin, D,266551322.980.000.001322.980.00
Munoz, Deanna,110548223.023399.990.002403.972419.06
Chander, Bethany, K,114468237.010.003399.992354.982482.04
He, Aimee, A,110938180.000.003399.992360.952419.06
Navarro, Melinda,114548089.040.003374.992294.992419.06
Raji, Lindsey,182056056.610.003578.272478.340.00
Gonzalez, George, L,119424792.290.003399.99614.96777.34
Suarez, Jacquelyn, C,110108088.043399.990.002294.992393.06
Saunders, Micheal,175134260.240.003578.27681.970.00
Diaz, Cheryl, A,110928110.020.003374.992341.972393.06
Chande, Lindsay,182446021.620.003578.272443.350.00
Rubio, Erika, A,114528183.040.003374.992414.992393.06
Gill, Eddie, J,1271574.540.000.0064.979.57
Anand, Johnny,140585652.520.000.003355.242297.28
Huang, Mandy,1826672.260.000.000.0072.26
Suarez, Carolyn, B,182226044.590.003578.272466.320.00
Johnson, Logan, K,229313882.550.000.003882.550.00
Chande, Jaclyn, S,186985314.250.003578.271735.980.00
Martinez, Tyler, T,282012419.060.000.002419.060.00
Wang, Roger, P,246053627.810.000.003627.810.00
Hernandez, Mallory,29091756.330.000.000.00756.33
Yang, Lacey,1315089.240.000.000.0089.24
Pal, Derek,2459158.980.000.000.0058.98
Griffin, Noah, E,2911873.960.000.000.0073.96
Kumar, Yolanda, J,1819485.960.000.000.0085.96
Ms., Simon, Britta,259461873.580.00699.100.001174.48
Bradley, Emma,142115662.900.000.002049.103613.80
Raje, Grant, S,241623004.830.000.002443.35561.48
Sanz, Cheryl, G,140465645.240.000.003340.262304.98
Gonzalez, Phillip, N,182076089.590.003578.272511.320.00
Long, Angelica, C,282062398.050.000.002398.050.00
Pal, Christine, I,182426121.710.003578.272543.440.00
Harris, Eduardo, S,182386030.610.003578.272452.340.00
Carson, Kelvin, A,119958249.010.003399.990.004849.02
Alonso, Meredith, M,206216117.690.003578.270.002539.42
Guo, Micah, M,241632756.540.000.002181.56574.98
Dominguez, Kristine, A,140206831.760.000.002071.424760.34
Ms., Robinson, Dorothy, B.,119528169.000.003374.992395.962398.05
Munoz, Latasha,119678153.020.003374.990.004778.03
Zeng, Ernest, M,12992158.510.000.0036.27122.24
Prasad, Arthur,142755158.370.000.002800.442357.93
Navarro, Carolyn,110698104.050.003399.992319.992384.07
Muñoz, Ruben, L,114518249.490.003399.992366.942482.56
Mrs., Nara, Barbara,12704217.460.000.000.00217.46
Goel, Roger, A,236523907.540.000.002181.561725.98
Xu, Calvin, E,27583553.970.000.000.00553.97
Gomez, Sheila, J,211654673.880.002181.560.002492.32
Sun, Lacey, L,1513181.260.000.000.0081.26
Edwards, Carlos,16680104.860.000.000.00104.86
Alvarez, Marc, B,1822145.950.000.000.0045.95
Kumar, Luke,241612983.340.000.002443.35539.99
Yuan, Tamara, E,211664909.670.002443.350.002466.32
Jimenez, Melody, S,140663612.190.000.002853.57758.62
Luo, Dustin,172404385.033578.270.000.00806.76
Wood, Jacqueline,1670597.960.000.000.0097.96
Kapoor, Phillip,27581539.990.000.000.00539.99
Alvarez, Erik, M,14311138.450.000.0074.4863.97
Davis, Nicole,2295739.980.000.000.0039.98
Ma, Jorge, O,1405286.260.000.0027.2858.98
Fernandez, Ross, R,1176376.650.000.0024.4952.16
Hu, Aimee, R,2798139.980.000.0039.980.00
Deng, Kurt, D,13635215.740.000.0032.27183.47
Arun, Bryant, C,2045321.490.000.0021.490.00
Yang, Hunter, E,2023721.490.000.0021.490.00
Moreno, Jimmy, L,110296565.293399.990.000.003165.30
Navarro, Stacy, C,126886867.440.002071.420.004796.02
Vazquez, Marc, H,243623600.770.000.002443.351157.42
Wu, Lisa,2615894.480.000.000.0094.48
Sun, Jamie,213892770.520.002181.560.00588.96
He, Jessie,29094796.340.000.000.00796.34
Lee, Richard, I,239962744.520.000.002181.56562.96
Nara, Karl,15142138.460.000.000.00138.46
Schmidt, Monica,1201273.960.000.008.9964.97
Alonso, Ricky, S,140705618.930.000.002049.103569.83
Lin, Autumn, E,182726056.610.003578.272478.340.00
Lu, Sandra, N,135214514.770.000.004514.770.00
Serrano, Stacy,246132148.210.001000.441147.770.00
Sun, Clayton,285334.990.000.004.990.00
Zhao, Ernest, C,187005328.230.003578.271749.960.00
Zhou, Cedric,175144142.230.003578.27563.960.00
Nath, Michele, L,110568207.503374.990.002413.452419.06
Nara, Sharon,184826030.610.003578.272452.340.00
Foster, Luke,15137161.940.000.0097.9763.97
Martinez, Cynthia,221702745.330.000.002181.56563.77
Pal, Tamara,126896846.920.002071.420.004775.50
Chandra, Tina, S,139745237.730.000.002071.423166.31
Ashe, Barbara,1873424.270.000.000.0024.27
Fernandez, Arthur, J,223992785.050.000.002181.56603.49
Goel, Dawn,235354.990.000.000.004.99
Gao, Gilbert,241653046.840.000.002443.35603.49
Wang, Rosa, I,119938131.320.003374.990.004756.33
Ramos, Diane, L,1830064.880.000.000.0064.88
She, Derek,150363785.080.000.002049.101735.98
Yuan, Carl, P,241603046.840.000.002443.35603.49
Rana, Ross,252402120.930.000.001000.441120.49
White, Ashley, D,2188739.990.000.0039.990.00
Martin, Ethan, M,13998245.250.000.0097.97147.28
Huang, Jorge,1729186.270.000.0053.9932.28
Chander, Alison,182496044.590.003578.272466.320.00
Liang, Steve,1431781.260.000.0049.9931.27
She, Rafael, I,201524142.750.003578.27564.480.00
Ferrier, Leslie, M,285352433.040.000.002433.040.00
Beck, Cedric, L,2240369.990.000.000.0069.99
Blue, Richard,12006144.740.000.000.00144.74
Gray, Morgan,28307561.480.000.000.00561.48
Li, Marshall,126876805.470.002071.420.004734.05
Ashe, Misty, R,231294.990.000.000.004.99
Fernandez, Carolyn, S,2930222.930.000.000.0022.93
Guo, Autumn, A,1421386.260.000.000.0086.26
Ye, Steve,29087810.320.000.000.00810.32
Yang, Shannon,120018113.010.003374.990.004738.02
Alvarez, Desiree,13005223.970.000.000.00223.97
Navarro, Julio, M,258221819.590.00699.100.001120.49
Kumar, Alejandro,140555177.400.000.002049.103128.30
Blanco, Philip, M,1560339.970.000.000.0039.97
Sara, Donald, M,251142155.920.000.001000.441155.48
Clark, Madison, A,140625647.920.000.003272.942374.98
Dominguez, Darren, M,139666842.120.000.002049.104793.02
Xie, Wayne, S,183026029.570.003578.272451.300.00
Jai, Tasha, A,197714167.230.003578.27588.960.00
Van, Brenda, J,2489039.980.000.0039.980.00
Zhu, Ernest,201594167.230.003578.27588.960.00
Sun, Alvin,182526021.620.003578.272443.350.00
Sai, Kari, E,1423183.970.000.0024.9958.98
Martin, Ricky, C,16608101.570.000.0071.5829.99
Hernandez, Audrey,1829084.960.000.008.9975.97
Garcia, Harold, K,14087341.970.000.00159.00182.97
Subram, Troy, R,196076054.220.003578.270.002475.95
Hernandez, Ebony, S,235743337.040.000.002181.561155.48
Hu, Lacey,199486021.620.003578.270.002443.35
Hernandez, Jill, L,13003230.250.000.006.28223.97
Smith, Tina, K,197936056.610.003578.270.002478.34
Hill, Kaylee, L,119188204.990.003399.990.004805.00
Zeng, Alisha, A,15727134.460.000.000.00134.46
Sanz, Nelson, M,1405649.480.000.000.0049.48
Raji, Kathryn, C,2199537.290.000.000.0037.29
Cai, Shannon,2615678.980.000.000.0078.98
Pal, Willie, J,1175546.250.000.000.0046.25
Suarez, Ruben,140316964.420.000.002049.104915.32
Guo, Aimee,1707577.270.000.000.0077.27
Chander, Brad, K,2138269.990.000.0069.990.00
Coleman, Brittany,1557934.980.000.0034.980.00
Fernandez, Manuel, A,165144761.743578.270.001183.470.00
Zeng, Wesley,2046021.490.000.0021.490.00
Russell, Stephanie,2025575.480.000.0075.480.00
Black, Tonya, M,2125489.970.000.0089.970.00
Guo, Krystal, S,17381188.930.000.00188.930.00
Zeng, Brittney, K,13670178.450.000.0024.49153.96
Beck, Derek,1732285.480.000.000.0085.48
Hernandez, Ross,1467781.260.000.000.0081.26
Ramos, Michele, J,1957496.740.000.000.0096.74
Liang, Louis, M,127066851.410.000.002071.424779.99
Kumar, Karl, J,142185651.880.000.002049.103602.78
Vance, Jillian, D,15230148.980.000.000.00148.98
Blanco, Erik, J,2909328.480.000.000.0028.48
Ruiz, Melody,13621167.400.000.000.00167.40
Raje, Mario, S,204275314.250.003578.270.001735.98
Diaz, Gerald, M,251187.280.000.000.007.28
Raji, Jaime, L,150373856.380.000.002071.421784.96
Beck, Bonnie, A,29097548.980.000.000.00548.98
Romero, Latasha,142205696.190.000.002071.423624.77
Mehta, Heidi,142265656.240.000.002071.423584.82
Yang, Curtis,111108093.030.003399.992294.992398.05
Subram, Raymond,239942790.520.000.002181.56608.96
Suarez, Lance, C,1723083.980.000.000.0083.98
Huang, Margaret, H,17070123.960.000.00123.960.00
Jai, Derek, E,13613105.220.000.0027.2877.94
Lopez, Carla, G,283262442.540.000.002442.540.00
Zhou, Arturo, F,27910574.980.000.00574.980.00
Romero, Jacquelyn,2581539.980.000.0039.980.00
Moore, Nathan, N,283232384.070.000.002384.070.00
Simpson, Tara, K,28107810.320.000.00810.320.00
Jai, Ethan,1521741.260.000.0031.279.99
Chen, Claudia, R,1662764.880.000.0029.9934.89
Guo, Susan, A,2654314.230.000.0014.230.00
Serrano, Tabitha,283272407.040.000.002407.040.00
Andersen, Roger,2446964.470.000.0064.470.00
Rodriguez, Dylan, E,1661175.530.000.0042.9332.60
Suri, Holly, M,18286141.550.000.0069.9771.58
Ye, Amy,11073191.900.000.00103.9687.94
Deng, Peter, A,240062721.550.000.002181.56539.99
Lu, Willie,211914169.330.002443.350.001725.98
Zhang, Warren, L,252521893.05699.100.000.001193.95
Zhu, Suzanne, E,251122155.920.000.001000.441155.48
Wu, Micah,172464380.043578.270.000.00801.77
Carson, Bradley,239952983.340.000.002443.35539.99
Watson, Alexandra, H,252491868.56699.100.000.001169.46
Navarro, Theresa,206276044.590.003578.270.002466.32
Rana, Meagan, M,119148165.960.003374.992329.982460.99
Perez, Ross, E,14307196.260.000.00159.0037.26
Navarro, Mathew, A,1967337.290.000.000.0037.29
Sanchez, Olivia, J,14278177.460.000.000.00177.46
She, Marshall, D,18707122.760.000.00120.472.29
Sanchez, Manuel,1512686.260.000.0058.9827.28
Torres, Bailey,1825930.970.000.008.9921.98
Chande, Derek,267431371.950.000.001371.950.00
Johnson, Morgan, E,120114735.810.003374.99618.47742.35
Lal, Tommy,1451678.980.000.0024.9953.99
Lopez, George,150403807.400.000.002071.421735.98
Wang, Jaclyn, M,17063100.250.000.0037.2762.98
Mehta, Jay, S,150353772.410.000.002071.421700.99
Vazquez, Lawrence,1963256.980.000.0056.980.00
Ramos, Audrey,119768087.310.003374.992319.262393.06
Raman, Allen, R,2512960.470.000.0060.470.00
Suri, Marie,242813302.050.000.002181.561120.49
Long, Nicole, C,13624114.970.000.0059.9854.99
Kapoor, Bryant,229463911.530.000.003911.530.00
Mehta, Gerald,2023432.280.000.0032.280.00
Guo, Martha, A,2853613.980.000.0013.980.00
Cai, Vincent, L,1175758.050.000.0024.4933.56
Ma, Bianca,19798128.440.000.0060.4767.97
Alonso, Kathleen,2119634.980.000.000.0034.98
Price, Ian, J,224012983.340.000.002443.35539.99

Generated 2025-11-07 04:01:19.295 UTC