2 Replies Latest reply on Dec 17, 2015 8:49 AM by ming.ticchione

    Using Table Calculation Results as filter while retain certain data

    ming.ticchione

      Hello,

       

      I have a set of data which contains 2 different month end data.  I want to build up a comparison view between the 2-month data.  I would like to filter out dataset based on certain threshold on the difference of the 2-month values.

      Here is the example.

       

      Here is how the worksheet looks like before I apply any filter.  The MoM_Balance is the difference between Feb and Jan revenue. Please note that Jan difference is null as there is no prior revenue to calculate the difference.

       

       

       

      Say if I want to only look at the stores which has revenue difference more than 500K.  I do this by using the abs(MoM_Balance) field.    After applying the filter, now it only shows the Feb data.

       

       

      My question is if there is another way to calculate the difference ( or do these kinds of comparison) while retaining the records from both months ?

       

      Thanks in advance for your help!