2 Replies Latest reply on Jul 2, 2012 11:17 PM by Archana Amarnath

    How to make table calculations independent of filters being applied on the table?

    Archana Amarnath

      Hi,

      In the Tableu file that i have attached, the Subclass Return Rate (highlighted in red) and return index (purple) are table calculations that change depending on the number of SKUs that are selected in the filter. I dont want them to change based on filters applied.  Is there anyway i can fix the numbers to show calculations based on all the records instead of what is just in the filter? eg. for SKU aa1, i need the return index to be 1.2 irrespective of how many SKUs are selected.

       

      Thanks,

      Archana