3 Replies Latest reply: Nov 17, 2016 8:38 AM by Sunny Talwar RSS

    Hide row if specified month sales are greater then zero

    Farrukh Shaikh

      Hi Guys,


      Could you please help me how to hide the row if specify month sale is greater then zero. I have other column in dimension like "Region, District and Company Name".


      I put below condition in Dimension Limits to hide the row where the specified month sale is greater than zero. I only want to display where the last three month sales are zero.


      But its not hiding the rows.

       

       

      =
      Sum({$<Year={$(=Year)},Month={$(=Month)}>} Sales)=0

       


      kind regards,


      Farrukh