I'm trying to calculate the grand total for the data set and I need this unaffected by any filters.
I'm calculating the total sales for all the order dates using table calc but when I filter out the dates it changes. Is there a way we can have it unchanged even when the filters are applied?
You can instead use a LOD calc which is a fixed sum of sales regardless of filter changes:
Thank you Pooja
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...