10 Replies Latest reply: Apr 20, 2016 10:44 AM by Saran De RSS

    Bar Chart - Suppress Dimension if Expression is NULL

    Saran De

      I have a situation here.

      Capture.PNG

      Dimensions : Strategic Direction & Site

      Expression : Count(Name)

       

      I want to suppress the Sites which didn't turn any value. I'm getting perfect output in Pivot Table.

       

      But if I change it to Bar chart, I'm getting the above.

       

      Suppress Null and other related options didn't work here.

       

      Any suggestions here please? Thanks..