8 Replies Latest reply: Mar 10, 2017 3:59 AM by Karthik Srinivasan RSS

    How to hide expression calculation...in master item..

    Kavita Vishwakarma

      Hi Everyone,

       

      I want to hide this expression from master Item... It should show only State as a label not the whole expression...

       

      Aggr(If(Sum({<Link_Date={'>=$(vCalMinDate)<=$(vCalCurrentDate)'}>}[Dealer Outstanding]) <> 0,State),State)

       

      I want to show bottom 5

      Drill down Dimension :

      State-> Area-> Location -> Dealer  created in master item.. with the above expression..


      Expression in Chart :


      If(Rank(-(sum({<Link_Date={'>=$(vCalMinDate)<=$(vCalCurrentDate)'}>} [Dealer Outstanding])/100000

      )) <= [_Top/Bot],

      (sum({<Link_Date={'>=$(vCalMinDate)<=$(vCalCurrentDate)'}>} [Dealer Outstanding])/100000

      ))

       

      Regards,

      Kavita