In Pivot, 'Show Row Totals' will not display anything if the first column only contains 1 value. Is there a workaround for this? I want the 'Grand Total' and not Aggregation of the first column, because its possible first column will contain multiple values.
Judging from your description, this was addressed in the 6.1 (latest version as of this posting) release. See excerpt from TDP 6.1 Release Notes below.
1 Like
Thanks Gary - this pointed me in the right direction.
Turning on 'Show Individual Sum' enabled the Grand Total - I only had to then disable the sub-totals for all the other columns.