A pivot table has months at columns and expenditures at rows,
Jan Feb Mar
Forecast Exp <blank> 210 230
Effected Exp 20 74 356
% #DIV/0! 35% 155%
The row % is a calculated field which formula is ='Effected Exp'/'Forecast Exp'.
The problem is I dont want #DIV/0! to be shown. Instead it, blank or -.
Any solution would be appreciated!
Bookmarks