I have a raw data which will be updated each week by other department and I can only use it but I cannot edit the original. So, I call the Pivot table to connect it as external source.
The raw data consists every month revenue figure (numeric) from last year Jan to current month.
e.g. Field:
Jan2011, Feb2011, Mar2011, ... , Dec2011
Jan2012, Feb2012, Mar2012, ... , Current_Month2012
The raw data file already pre-set Jan2012 to Dec2012 fields but no figure until the month is past.
I need to calculate Sum of Year-to-month figure, so I use Calculated Field.
e.g. Now is Nov 2012 and thus I have the figure up to Oct.
Sum of year-to-month (last year) = Jan2011 + Feb2011 + ... + Oct2011
Sum of year-to-month (this year) = Jan2012 + Feb2012 + ... + Oct2012
My problem is:
I need to modified the Calculated Field every month by adding the current month field to the formula.
Any automation I can do?
The raw data consists every month revenue figure (numeric) from last year Jan to current month.
e.g. Field:
Jan2011, Feb2011, Mar2011, ... , Dec2011
Jan2012, Feb2012, Mar2012, ... , Current_Month2012
The raw data file already pre-set Jan2012 to Dec2012 fields but no figure until the month is past.
I need to calculate Sum of Year-to-month figure, so I use Calculated Field.
e.g. Now is Nov 2012 and thus I have the figure up to Oct.
Sum of year-to-month (last year) = Jan2011 + Feb2011 + ... + Oct2011
Sum of year-to-month (this year) = Jan2012 + Feb2012 + ... + Oct2012
My problem is:
I need to modified the Calculated Field every month by adding the current month field to the formula.
Any automation I can do?