Hello All,
In my text table, I have a field named "Annual Projection" (This field is calculated in my transformation process prior to being loaded into Tableau).
Question: I'd like to ONLY show the Annual Projection field as 'Grand Total'. Please refer to this screenshot to see what I mean. I do not want the field to display for each month's aggregation.
My packaged workbook is attached here as well, if that is helpful. I am stumped. Any help would be greatly appreciated!
Thanks in advance for any assistance!
6 answers
good morning -@Jason Jacobs
try this if SIZE()=1 then sum([Annual Projection]) else COUNT([Sheet1]) end
it will return this
jim