3 Replies Latest reply on Jul 1, 2016 1:11 AM by Mahfooj Khan

    Percentage Diff and Date filter issue

    Patrick Myles

      Hey All - I have the following issue:

       

      I want to display percentage growth values in a table filtered to a specific month, however when applying the date filter the values disappear.  I realise it's because they needed previous month value in the pane to calculate the percentage difference. 

       

      I've attached the example workbook.  You'll see on the second worksheet that once I apply a filter to show APRIL 2016 values, they are gone because table needs to have the MAR 2016 values to calculate. 

       

      Is there a way around this?

       

      Thanks!

      Patrick