Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Sales Projections column
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting a Pivot Table Column that is not the first column... | Excel Worksheet Functions | |||
pivot table, how to add 1 column only | Excel Discussion (Misc queries) | |||
Add Sales Goals to Sales Report in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot table for reporting sales performance | Excel Discussion (Misc queries) | |||
Pivot Table - report product that have sales above defined level | Excel Discussion (Misc queries) |