Hello,
I have a data that consists of months, forecast and actual.
I've created a pivot table where;
months is on the row,
forecast and actual is on the values
I wanted to know the percentages between forecast and actual (forecast / actual) to see how it perform each month.
How do I go about inserting a pre-defined named called "percentages" on pivot table with calculated field or calculated item on pivot table itself?
Bookmarks