8 Replies Latest reply: Jan 23, 2017 8:32 AM by paolo Deregibus RSS

    Show bar chart with sales where stores achieve at least 90% of target

    Mohammad Adnan Ansari

      I have made a bar chart before where I have to show Top 10 Stores for sales. The formula I used is as below:

       

      Sum({<Store = {"=Rank(Sum(Sales))<=10"}>} Sales)


      Now I am trying to find those stores which have achieved 90% of their targets and show there sales. I am trying the below formula which is not working:


      Sum({<Store = {"=Sum(Sales)/Sum(Target) >=0.9"}>} Sales)


      Pls. help what mistake I am making here.