0 Replies Latest reply: Aug 17, 2017 12:13 PM by Liam Hanninen RSS

    Above and Below functions break with selection

    Liam Hanninen

      I'm hoping there is a common fix for this since I'm sure others have run into this. But I have not found a solution online yet.

       

      I am using above() in a chart to sum 4 trailing weeks into a single week value. But when I select  a few weeks the last most weeks appear artificially low because there are no values 'above' them; they have been filtered out. If I manually exclude week from the selection like Weekending=, I then prevent the user from selecting these weeks (for this chart). How can I maintain the above() calculation when the dimension has been filtered?