Y
YMTEO
Currently I am in the process of doing up a Qtr 3 forecast template for the
sales man.
I use pivot table to churn out the results of the past months and the to go
months into a nice table.
Before I pass the pivot table to the salesman for their input, I need to
convert the pivot table into a static table and change all the sub total with
@sum formulars.
As the "static" pivot table has many sub total, inserting the sub total
formulars for each product groups are very tedious, not to say I have about
200+ sub products and 10 different tables.
Wondering is there a faster way to carry out this task?
It would be great if
1) I can add or change information within a Pivot table and have it stay
within the table and left the data source unchange?
2) A quick way to replace the pivot table sub total into @sum formular so
that when the figures within the "static" pivot table is changed, the sub
total will change accordingly too?
Can someone advise and help?
sales man.
I use pivot table to churn out the results of the past months and the to go
months into a nice table.
Before I pass the pivot table to the salesman for their input, I need to
convert the pivot table into a static table and change all the sub total with
@sum formulars.
As the "static" pivot table has many sub total, inserting the sub total
formulars for each product groups are very tedious, not to say I have about
200+ sub products and 10 different tables.
Wondering is there a faster way to carry out this task?
It would be great if
1) I can add or change information within a Pivot table and have it stay
within the table and left the data source unchange?
2) A quick way to replace the pivot table sub total into @sum formular so
that when the figures within the "static" pivot table is changed, the sub
total will change accordingly too?
Can someone advise and help?