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

    Filtering using Table Calculations

    Manish Chitnis



      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.