AckeemK
asked on
Macro to group certain pivot tables after refreshed with data
I was looking to create a macro to group two of my pivot tables (by month, year) any time the data is refreshed. When I import the data, months are duplicated and I receive a error saying that I can't overlap pivot tables so if I am able to refresh the data and group through a macro, that would help with this issue. The main pivot tables that are affected are on the 'Open SR Pivots' tab as well as 'Closed SR Pivot'. The "Open/Closed SRs by Month" pivot table as well as "Open/Closed by Severity" will show the duplicates.
DSE-Carelog-Report.xlsm
DSE-Carelog-Report.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I'm not sure what you are doing here..Can you help me connect with what you are trying to do here...
As if you refresh the pivot tables in the file which i gave to you it works perfectly...
As if you refresh the pivot tables in the file which i gave to you it works perfectly...
ASKER
Yes, I seen the issue on my side. Lastly, for the Y values in my "Closed SRs by Severity" chart, I keep receiving this error as I am trying to capture the data in a dynamic range within the pivot table. Any help here?
Screen-Shot-2015-04-21-at-9.07.43-AM.png
Screen-Shot-2015-04-21-at-9.07.43-AM.png
ASKER
I am trying to capture the years and the month within the chart since I have 2014 and 2014 data but it seems like the offset function doesn't allow it.
Ackeemk,
I'm not sure what you are doing here..Can you post another question for this with an example of step by step what you are doing and what problem you are facing so that accordingly able to provide you a solution for the same...
Saurabh...
I'm not sure what you are doing here..Can you post another question for this with an example of step by step what you are doing and what problem you are facing so that accordingly able to provide you a solution for the same...
Saurabh...
ASKER
I keep receiving this error every time I try to refresh the data.
Screen-Shot-2015-04-21-at-8.13.34-AM.png