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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2023202420252026
Lu, Curtis,110118133.043399.990.004733.050.00
Watson, Alexandra, H,252491868.56699.100.000.001169.46
Raji, Misty,165204727.743578.270.001149.470.00
Pal, Casey,165224698.763578.270.001120.490.00
Arun, Cory, O,165274752.753578.270.001174.480.00
Arthur, Tabitha, E,164824783.743578.270.001205.470.00
Wang, Shannon,110176434.313374.990.002316.97742.35
Fernandez, Brenda, L,164934197.253578.270.000.00618.98
Ashe, Ebony, E,166125898.263578.270.000.002319.99
Perez, Arthur, L,165264758.243578.270.001179.970.00
Zhao, Jessie, R,110276591.573399.990.002412.96778.62
Rai, Clarence, D,110186533.283399.990.002341.97791.32
Lal, Dustin, A,164844175.533578.270.000.00597.26
Lal, Andres, L,166235973.243578.270.000.002394.97
Moreno, Jimmy, L,110296565.293399.990.002408.97756.33
Thompson, Fernando,163505903.193578.270.000.002324.92
Sai, Harold,110266575.793399.990.002399.47776.33
Stewart, Ariana,167436070.593578.270.002492.320.00
Gonzalez, Ebony,110346491.323399.990.000.003091.33
Ortega, Jessie, J,170516060.503578.270.002482.230.00
Arthur, Kristi, W,166754385.033578.270.00806.760.00
Romero, Lawrence, C,166876070.593578.270.002492.320.00
Lu, Jaclyn, D,110476582.333399.990.000.003182.34
Raje, Ashlee, E,166585873.263578.270.000.002294.99
Martin, Marc, J,110396636.583399.990.000.003236.59
She, Alvin, E,166575900.553578.270.000.002322.28
Nelson, Sophia,166644377.753578.270.00799.480.00
Ye, Dennis, M,166385974.233578.270.000.002395.96
Scott, Savannah, E,169294733.753578.270.001155.480.00
Lopez, Heidi,110528131.323374.990.004756.330.00
Stone, Denise,110326525.563374.990.000.003150.57
Gutierrez, Natasha,170484382.753578.270.00804.480.00
Raman, Patricia, T,167026021.623578.270.002443.350.00
Sai, Preston, D,170464467.743578.270.00889.470.00
Andersen, Carl, J,110578088.043374.990.004713.050.00
Nara, Tony, L,167136090.593578.270.002512.320.00
Jimenez, Gary, E,16609344.040.000.00344.040.00
Gray, Faith,2291459.980.000.0059.980.00
Chapman, Kathryn,119888078.020.003374.992309.972393.06
Wilson, Zachary,255581307.06699.100.000.00607.96
Kumar, Deborah, K,173086021.623578.270.002443.350.00
Watson, Maria,172294471.743578.270.000.00893.47
Wu, Micah,172464380.043578.270.000.00801.77
Ferrier, Jaclyn, D,172994382.753578.270.000.00804.48
Zheng, Christy,170694426.743578.270.00848.470.00
Gao, Todd, M,110618129.023374.990.004754.030.00
Beck, Alicia, L,172484382.753578.270.000.00804.48
Deng, Clayton, G,172856093.203578.270.002514.930.00
Green, Fernando,172584347.763578.270.000.00769.49
Chander, Omar, W,172414382.753578.270.000.00804.48
Lopez, Luis, P,173344347.763578.270.000.00769.49
Lal, Shaun, H,170564417.753578.270.00839.480.00
Martin, Joan, R,255561253.07699.100.000.00553.97
Sanchez, Troy, H,255591253.07699.100.000.00553.97
Flores, Noah,172564362.743578.270.000.00784.47
Goel, Nichole, A,172774426.743578.270.000.00848.47
Mr., Shakespear, Paul, J.,173264467.763578.270.000.00889.49
Butler, Jason,175104369.743578.270.000.00791.47
Mehta, Nancy,181894118.263578.270.00539.990.00
Yuan, Bradley,179204733.753578.270.000.001155.48
Rodriguez, Pedro, L,179114698.763578.270.000.001120.49
Subram, Tabitha, C,175114150.533578.270.00572.260.00
Yuan, Louis, C,181934145.543578.270.000.00567.27
Li, Aimee,179154792.733578.270.000.001214.46
Lal, Shawna,179244733.753578.270.000.001155.48
Li, Lacey,175154143.263578.270.00564.990.00
Chande, Cassie,111038182.503374.990.004807.510.00
Goel, Drew,173526021.623578.270.000.002443.35
Xu, Tracy, L,179164787.743578.270.000.001209.47
Williams, Anna, R,175044362.743578.270.000.00784.47
Patel, Douglas,179274726.043578.270.000.001147.77
Jimenez, Felicia, L,110758068.033374.990.004693.040.00
Lin, Bianca,111078171.013374.990.004796.020.00
Yang, Curtis,111108093.033399.990.002294.992398.05
Sara, Edgar, A,111048173.033399.990.004773.040.00
Lin, Autumn, E,182726056.613578.270.002478.340.00
Kumar, Louis, A,182034172.253578.270.000.00593.98
Griffin, Rachel,182556067.203578.270.000.002488.93
Ramos, Marc,182126029.573578.270.002451.300.00
Nelson, Fernando, G,255641253.07699.100.000.00553.97
Chapman, Preston, O,182686102.193578.270.000.002523.92
Chande, Lindsay,182446021.623578.270.002443.350.00
Torres, Wendy, A,182696113.203578.270.000.002534.93
Sharma, Jodi, N,182606035.603578.270.002457.330.00
Sun, Alvin,182526021.623578.270.002443.350.00
Gill, Erika, A,182024143.263578.270.000.00564.99
Sun, Brittney,113655024.793374.990.000.001649.80
Xu, Clayton,184886056.613578.270.002478.340.00
Suri, Roy, M,1725353.990.000.0053.990.00
Xu, Barbara,291952419.060.000.002419.060.00
Li, Stacey,140645694.210.000.003375.252318.96
Andersen, Kate,1423790.250.000.0031.2758.98
Yang, Jamie, S,184654752.753578.270.000.001174.48
Diaz, Ricky, E,183356035.603578.270.000.002457.33
Ye, Edwin,183344698.763578.270.000.001120.49
Kim, Kari, S,114458098.033399.990.004698.040.00
Zhao, Ernest, C,187005328.233578.270.001749.960.00
Zheng, Vincent,184966121.713578.270.002543.440.00
Huang, Vincent, A,187035314.253578.270.001735.980.00
Chen, Erica, P,183086037.893578.270.002459.620.00
Black, Mindy, W,186966149.573578.270.002571.300.00
Deng, Carl,182846029.573578.270.002451.300.00
Lal, Terry,182776070.593578.270.000.002492.32
Madan, Francisco, S,257061239.09699.100.000.00539.99
Raje, Louis, M,257071262.06699.100.000.00562.96
Rubio, Robyn, A,184696021.623578.270.002443.350.00
Zhu, Clarence, A,184624752.753578.270.000.001174.48
Chande, Jaclyn, S,186985314.253578.270.001735.980.00
Prasad, Levi,257051274.08699.100.000.00574.98
Serrano, Tyrone,113605025.803399.990.000.001625.81
Zheng, Claudia,186916070.593578.270.002492.320.00
Malhotra, Emmanuel,183324752.753578.270.000.001174.48
Chavez, Jodi, A,189096035.603578.270.002457.330.00
Gutierrez, Adrienne,189064217.223578.270.00638.950.00
Navarro, Jonathon,187225333.253578.270.001754.980.00
Kapoor, Denise, M,187256044.593578.270.002466.320.00
Luo, Louis,114658158.040.003399.992319.992438.06
Malhotra, Stanley, H,114538176.980.003374.994801.990.00
Luo, Tamara,187386089.590.003578.272511.320.00
Ortega, Janet, L,117548163.530.003399.992319.992443.55
Gutierrez, Jaime, C,114578211.480.003374.994836.490.00
Chande, Melvin, R,114608137.520.003399.994737.530.00
Fernandez, Denise, A,187246056.510.003578.272478.240.00
Sun, Krystal,189086090.590.003578.272512.320.00
Patterson, Ashley, R,187366035.600.003578.272457.330.00
Deng, Tasha,114598141.330.003399.994741.340.00
Fernandez, Kristopher, O,192714153.250.003578.27574.980.00
Powell, Kaitlyn,195985310.530.003578.271732.260.00
Sanz, Marvin,196126029.570.003578.272451.300.00
Gonzalez, Kristopher, C,192644132.240.003578.27553.970.00
Ortega, Gloria, R,195586029.570.003578.272451.300.00
Martinez, Terrance,257181274.080.00699.100.00574.98
Jai, Alvin,195995279.260.003578.271700.990.00
Xu, Tara,195925377.230.003578.271798.960.00
Williams, Wyatt, E,196146217.210.003578.272638.940.00
Deng, Sheena,190996038.560.003578.272460.290.00
Martinez, Kari,196096093.200.003578.272514.930.00
Rana, Carla, K,195935306.540.003578.271728.270.00
Rana, Stefanie, K,196165279.260.003578.271700.990.00
Dominguez, Diana, L,292922393.060.000.002393.060.00
Serrano, Darren,291962438.060.000.002438.060.00
She, Bridget, M,195575358.240.003578.271779.970.00
Ramirez, Isaiah,119058155.980.003374.994780.990.00
Ortega, Danny, K,197946098.580.003578.272520.310.00
Deng, Devon, H,199676029.570.003578.272451.300.00
Hill, Alex, C,197876054.220.003578.272475.950.00
Ramos, Jessie, R,117648129.020.003399.994729.030.00
Sanders, Gabriella,119068151.000.003374.992391.942384.07
Wu, Amy,197906089.590.003578.272511.320.00
Gutierrez, Ricky,197736056.610.003578.272478.340.00
Smith, Tina, K,197936056.610.003578.272478.340.00
Madan, Meagan,117678319.510.003399.992475.972443.55
Raman, Candace, M,117668280.480.003399.994880.490.00
Mr., Spencer, Phil,199606120.110.003578.272541.840.00
Carlson, Byron,119008257.010.003399.992374.982482.04
Rodriguez, Douglas, W,196525314.250.003578.271735.980.00
Malhotra, Darren, L,202456085.590.003578.270.002507.32
Dominguez, Gina, L,202136029.570.003578.272451.300.00
Wang, Valerie,202176089.590.003578.272511.320.00
Zhu, Ernest,201594167.230.003578.27588.960.00
Rai, Sharon,202256056.610.003578.272478.340.00
Gutierrez, Orlando,259201819.590.00699.100.001120.49
Rana, Meagan, M,119148165.960.003374.992329.982460.99
Watson, Anna,202386021.620.003578.272443.350.00
Arthur, Raymond, S,202286093.200.003578.272514.930.00
Sullivan, Carla, A,206116021.620.003578.270.002443.35
Mehta, Evelyn, S,204204132.240.003578.27553.970.00
Sharma, Mario, J,259281316.050.00699.100.00616.95
Schmidt, Deanna, H,259361248.080.00699.100.00548.98
Serrano, Javier, R,202566029.570.003578.270.002451.30
Martinez, Ethan, C,202605314.250.003578.271735.980.00
Shan, Johnny,119997043.270.003399.991308.312334.97
Gao, Curtis, D,204295377.750.003578.270.001799.48
Anand, Kelli, A,204516054.220.003578.270.002475.95
Deng, Barbara,204456078.710.003578.270.002500.44
Wu, Laura,206156060.500.003578.272482.230.00
Liang, Colin,13639188.960.000.00188.960.00
Nara, Leonard, G,11045114.960.000.0064.9749.99
Chapman, Patricia,120377107.100.003374.991249.842482.27
Madan, Terrance,249102183.910.001000.441183.470.00
Madan, Brenda,13043175.930.000.0088.9886.95
Gao, Rafael, R,1873324.270.000.0024.270.00
Perez, Ross, E,14307196.260.000.00163.9932.27
Shen, Gilbert, C,120056984.810.003399.991214.852369.97
Ward, Katelyn,202586029.570.003578.270.002451.30
Alvarez, Max, M,119868245.230.003399.992392.202453.04
Raje, Mario, S,204275314.250.003578.270.001735.98
Bryant, Fernando, M,206096117.690.003578.272539.420.00
Suarez, Danny,209954127.250.003578.27548.980.00
Serrano, Kristi,206166093.200.003578.272514.930.00
Martin, Anna, L,209884118.260.003578.27539.990.00
Yuan, Deborah,120214043.460.003399.99643.470.00
Raje, Bonnie,206296060.500.003578.270.002482.23
Sai, Frederick,209914118.260.003578.27539.990.00
Collins, Andrea,122503964.980.003399.99564.990.00
Morcos, Hany,208214118.260.003578.27539.990.00
Perez, Ronald,259441274.080.00699.100.00574.98
Sandberg, Kristine,122413989.460.003399.99589.470.00
Liang, Gilbert,122423948.970.003374.99573.980.00
Arun, Gerald,259401277.560.00699.100.00578.46
Andersen, Tracy,208154118.260.003578.27539.990.00
Green, Jennifer,125712641.390.002071.420.00569.97
Yuan, Tamara, E,211664909.670.002443.350.002466.32
Moreno, Roberto, R,212063882.550.002181.560.001700.99
Goel, Ricardo, T,259611938.470.00782.990.001155.48
Garcia, Carolyn,209992735.530.002181.56553.970.00
Henderson, Marcus, D,1521268.960.000.004.9963.97
Rodriguez, Carolyn,210022992.330.002443.35548.980.00
Munoz, Jacquelyn,291152407.040.000.002407.040.00
Gao, Wesley,123466864.460.002071.422354.982438.06
Hernandez, Logan,123506791.750.002071.422319.992400.34
Huang, Crystal, L,260231917.460.00782.990.001134.47
Martin, Alyssa,1958721.490.000.0021.490.00
Rai, Grant, R,125732668.080.002049.100.00618.98
Wood, Julia, L,123566810.130.002049.102341.972419.06
Pal, Sheena, D,211973917.540.002181.560.001735.98
Rogers, Anna,212014921.690.002443.350.002478.34
Xu, Rafael, N,211954144.340.002443.350.001700.99
He, Louis, E,212114900.680.002443.350.002457.33
Nara, Katrina, Z,246082120.930.001000.441120.490.00
Raje, Derek,125742626.390.002071.420.00554.97
She, Corey, T,212144659.900.002181.560.002478.34
Becker, Kara,211674657.510.002181.560.002475.95
Vance, Denise, L,212054886.700.002443.350.002443.35
Rubio, Desiree, D,211894208.310.002443.350.001764.96
Gao, Jamie,260221938.470.00782.990.001155.48
Arun, Nancy, C,211694647.880.002181.560.002466.32
Wood, Maria,126676813.120.002049.102344.962419.06
Diaz, Nelson, C,213872745.330.002181.56563.770.00
Serrano, Gloria, G,215564930.680.002443.350.002487.33
Liu, Cedric,126776785.470.002071.422294.992419.06
Shen, Shaun,126846893.080.002049.102410.942433.04
Cai, Curtis,212593907.540.002181.560.001725.98
Chapman, Alicia, A,214184659.900.002181.560.002478.34
Luo, Johnny,213593032.310.002443.35588.960.00
Xu, Kelvin, K,212223936.540.002181.560.001754.98
Romero, Ricky,213612997.320.002443.35553.970.00
Lin, Ronnie, D,213842921.020.002181.56739.460.00
Travers, Jimmy, V,126746829.470.002071.422319.992438.06
Sanz, Julio, H,214044684.390.002181.560.002502.83
Coleman, Nicole, A,215584919.300.002443.350.002475.95
Ortega, Tyrone, H,125832646.400.002071.420.00574.98
Martinez, Ian,125852629.070.002049.100.00579.97
Hernandez, Brandi, C,218934663.790.002181.560.002482.23
Gonzalez, Ruth,126936820.470.002071.422329.992419.06
Hernandez, Jacquelyn, J,215684659.800.002181.560.002478.24
Gonzalez, Kaylee, L,218954657.510.002181.560.002475.95
Hernandez, Orlando, C,219514923.290.002443.350.002479.94
Navarro, Stacy, C,126886867.440.002071.422376.962419.06
Deng, Michele,219464659.800.002181.560.002478.24

Generated 2026-07-21 14:53:49.551 UTC