I am using Summarize Data By...% Difference From to calculate % Change from one period to another, ie, Jan, Feb, Mar, using rows. I find that the Pivot does displays the values well but at then shows a blank Grand Total. In other words it does not show the total % Change from Jan through Mar.
1. Do I need to create a calculated field and if so how do I do that?
2. The first instance of % Change, ie, Jan, shows blank...is my only option to hide the column or can I suppress blanks somehow?
Thanks in advance for the help.
1. Do I need to create a calculated field and if so how do I do that?
2. The first instance of % Change, ie, Jan, shows blank...is my only option to hide the column or can I suppress blanks somehow?
Thanks in advance for the help.