Hello,
I have about 26 pivots which are reports by 26 Areas. There is a Data tab that is refreshed monthly and a new column of data for the current month is populated. The challenge is I have to go into each pivot after I refresh all and add the new column of data to every single pivot (also when I add the new column of data it Counts rather than Sums so I need to go into Field Value Settings to select Sum).
Anyway to automate this? I am thinking if there's a way to select the desired month (003.2018 for example for March 2018) that each pivot can automatically add that new field into the Values area of the Pivot rather than going into each one and dragging the new month's Field into Values then Select Field Value Settings and change to Sum....
Thanks!
Gary
I have about 26 pivots which are reports by 26 Areas. There is a Data tab that is refreshed monthly and a new column of data for the current month is populated. The challenge is I have to go into each pivot after I refresh all and add the new column of data to every single pivot (also when I add the new column of data it Counts rather than Sums so I need to go into Field Value Settings to select Sum).
Anyway to automate this? I am thinking if there's a way to select the desired month (003.2018 for example for March 2018) that each pivot can automatically add that new field into the Values area of the Pivot rather than going into each one and dragging the new month's Field into Values then Select Field Value Settings and change to Sum....
Thanks!
Gary