2 Replies Latest reply on Nov 19, 2019 8:13 AM by Naren R Branched from an earlier discussion.

    Re: Force Blanks to Show.

    Naren R

      I have similar requirement but I use date parameter as each sheet in my dashboard is connected to different datasources. I have added calculation1 to the sheet attached

       

       

      if datetrunc('month',[Date Parm]) = [Month]

      then 'SHOW'

      else 'HIDE'

      END

       

       

      But when 'calculation1' is added to filter shelf, it doesnt have the value 'SHOW' resulting in blank for the month