In my PivotTable, I have two calculated fields that show the % difference from the previous year. In both of these calculated fields, several cells are blank since there wasn't data from the previous year to calculate from.
However, for the years there wasn't a growth %...it's plotting those years as "0.00%". I would like the PivotChart to ONLY show data points with non-zero values.
I've already tried adjusting both "For error values show:" & "For empty cells show:" in the PivotTable options...no luck
Any suggestions?
Thank!
DJ
Bookmarks