1 Reply Latest reply on Jun 6, 2016 5:51 PM by swaroop.gantela

    Filtering using Table Calculations

    Manish Chitnis

      Hi,

       

      I'm trying to filter a dataset using a table calculation viz. I have a setup a pivot where different versions of the data (say X, Y, Z) are presented in columnar format and the differences against X are listed next.  

       

      Now, I wish to put in a filter where I only see the line items where the difference is greater than a set threshold.   Unfortunately, even though I see the difference correctly, I'm not sure where I'm misunderstanding the filter logic but it does not filter properly.

       

      Attaching the workbook.