This content has been marked as final.
Show 2 replies
-
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
-
-
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!