Hi,
I have created some Pivot Tables and charts(Excel 2010) using data that has some headers like 2012-Jan, 2012-Feb....2012-Dec. In my Pivot table, I have created calculated fields like Q1 which is a summation of 2012-Jan, 2012-Feb and 2012-March. All this works fine. But, If this template is used next year, my source data will have different headers like 2013-Jan, 2013-Feb and so on. Just to test, I changed my 2012-Jan header to 2013-Jan and on refreshing the pivot tables and charts, the new header and it's values do not show up automatically in place of the old header. I have to select it manually which I do not want to do. Also the calculated field as I described above show an error value. Any help in this regard would be much appreciated.
Thanks,
Sanit
I have created some Pivot Tables and charts(Excel 2010) using data that has some headers like 2012-Jan, 2012-Feb....2012-Dec. In my Pivot table, I have created calculated fields like Q1 which is a summation of 2012-Jan, 2012-Feb and 2012-March. All this works fine. But, If this template is used next year, my source data will have different headers like 2013-Jan, 2013-Feb and so on. Just to test, I changed my 2012-Jan header to 2013-Jan and on refreshing the pivot tables and charts, the new header and it's values do not show up automatically in place of the old header. I have to select it manually which I do not want to do. Also the calculated field as I described above show an error value. Any help in this regard would be much appreciated.
Thanks,
Sanit
