Hey everyone,
i have a question that sounds not that difficult but still i haven't figured it out yet.
Instead of using the grand totals of the analysis function in the tableau worksheet i want to add a calculated field to get the grand total of a collumn.
My goal is to have one total that doesnt change when using certain filters.
If anyone has an idea im happy to hear it!
Thnks!
Sophie
Sophie,
Apologies for late reply.
I'm not sure that I caught the gist, but I made an attempt.
I made an overall grand total that is not affected by Sub-Category selection or Month selection:
{ FIXED :SUM([Sales])}
I think made one that is fixed to a region irrespective of Sub-Category or Month:
{ FIXED [Region]:SUM([Sales])}
Please see attached workbook.
Apologies if that's not what you were looking for.
