Pivot 'Show Row Totals' not working

Toad Data Point & Toad Intelligence Central
1

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.

2

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.

image
image708×450 58.6 KB

3

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.