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 Jul 1, 2012 11:27 PM

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

HD - Adv Table Calcs.twbx.zip 24.7 KB

1. Re: How to make table calculations independent of filters being applied on the table?

Vladislav Grigorov Jul 2, 2012 3:09 AM (in response to Archana Amarnath)
Hello Archana,

How about using a "proxy" table calc to filter on? I defined a [filter] field to be something like WINDOW_MAX(MIN([SKU])), put it on the filter shelf, set the Calculate property to be "Cell", and then showed the quick filter control. Now when you filter by this field your results remain constant. I also played a bit with your calcs to calculate along SKU, not pane down. For more info on table calcs I suggest you see this great resource: http://www.theinformationlab.co.uk/2011/12/07/making-table-calculations-work-in-tableau/ (all credits go to Tom Brown for creating it in such a wonderful way)

Hope this helps!

Vladi

HD - Adv Table Calcs.twbx.zip 25.4 KB
Like Show 0 Likes(0)

Actions
2. Re: How to make table calculations independent of filters being applied on the table?

Archana Amarnath Jul 2, 2012 11:17 PM (in response to Vladislav Grigorov)

Thanks a lot Vladi . This definately helps!
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

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

1. Re: How to make table calculations independent of filters being applied on the table?

2. Re: How to make table calculations independent of filters being applied on the table?

Actions

More Like This