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



      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 ?