R
rivers99
I would like to add a column for projected sales into a pivot table.
Formula would be Grand Total/(month sales are through)*12.
I am running into problems because when I try to add the column on top
because I have the MONTH column on top already the pivot table wants
to expand beyond 255 columns. Here is what I want it to look like:
MONTH
SALES REP NAME Projected Sales Jan Feb
March..... Grand Total
John Smith $5,600 $200
$500 $700 $1,400
Bruce Jones
Steve Johnson
Any Suggestions? Also, the pivot table format I am using is the
default one.
Formula would be Grand Total/(month sales are through)*12.
I am running into problems because when I try to add the column on top
because I have the MONTH column on top already the pivot table wants
to expand beyond 255 columns. Here is what I want it to look like:
MONTH
SALES REP NAME Projected Sales Jan Feb
March..... Grand Total
John Smith $5,600 $200
$500 $700 $1,400
Bruce Jones
Steve Johnson
Any Suggestions? Also, the pivot table format I am using is the
default one.