2 Replies Latest reply on Mar 20, 2018 9:49 AM by Impashree Shetty

    Include null value in sheet but exclude from filter

    Impashree Shetty

      Hello,

       

      I am trying to do a price waterfall chart (based on logic given in this thread Waterfall chart Plotted Against Aggregated Measures  ). To achieve this i have added a row with no values. Now I need to have this data(row with null value) in the sheet no matter what filter i select.

       

      Basically, i am looking for something like this below. Highlighted null should be somehow selected at the back end and it should not show up in the filter drop down. Is it possible ? Then only the waterfall logic will work in this case.

       

      Can anyone please help ?

       

      Thanks,

      Impashree