Hi,
Every month I update a pivot table with the new monthly sales I import from a data base. I categorize the sales into four categories- actual, forecast, plan, and forecast prior. So these four categories are imported easily into a pivot table template after I hit refresh. Now, I create calculated fields to show the variances between forecast and actual, etc.
So, when I hit refresh in pivot table all my data updates by the month except the calculated fields. They are still the same as last month's numbers. I know you can manually update the the formula in the calculated field. But that takes way too much time, because I need to find the field I want to change and I have so many fields that need to change.
I am wondering if there is another way to for me to update the fields formulas,( instead of me going to the calculated fields tab, and finding the field and modifying it). Is there a more efficient method?
Thanks
Bookmarks