1 Reply Latest reply on Dec 12, 2016 8:50 PM by koushik.neelakantha

    Top 10 sales WRT Account

    koushik.neelakantha

      Hello Everyone,

       

      Please find the attached workbook.

       

      I just want top 10 sales WRT Account name. I have tried using below logic but unable to get the desired output. Please help me out.

       

      if [Parameters].[Top 10] = 'Top 10' then rank(AVG([Last 12 Months Sales]), 'desc') < 11

      END

       

      Regards,

      Koushik.