J
Joe
I have calculated fields in my pivot table that work great.
But if one of those calculated fields have nothing to calculate within the
pivot table, the Grand Total does not display a viewable result. The Grand
Total for that calculated field returns a 'blank'.
As soon as I enter data in the source data to compliment the calculation...
the Grand Total for that calcucaltion works perfect.
Is there a switch or setting I can set in Table Options to make this work or
are there any trick workarounds?
Thanks in advance,
Joe
But if one of those calculated fields have nothing to calculate within the
pivot table, the Grand Total does not display a viewable result. The Grand
Total for that calculated field returns a 'blank'.
As soon as I enter data in the source data to compliment the calculation...
the Grand Total for that calcucaltion works perfect.
Is there a switch or setting I can set in Table Options to make this work or
are there any trick workarounds?
Thanks in advance,
Joe