broncotundra
New Member
- Joined
- Nov 28, 2018
- Messages
- 1
I have recently converted a project to use the Data Model and Power Pivots. This project has numerous Pivots on a template. The Pivots need to set the value of a PivotField to change the view between various departments.
When I recorded the actions, I got a line that looks like this:
ActiveSheet.PivotTables("Majors_Prog").PivotFields("[Plans].[Program].[Program]").CurrentPage = "[Plans].[Program].&[ACCT]"
where [ACCT] is our Accounting department.
I have a department variable. I've tried permutations of the follow to no success:
ActiveSheet.PivotTables("Majors_Prog").PivotFields("[Plans].[Program].[Program]").CurrentPage = "[Plans].[Program].&[" & Program & "]"
I'm stuck and can't figure out how this line of code show work.
When I recorded the actions, I got a line that looks like this:
ActiveSheet.PivotTables("Majors_Prog").PivotFields("[Plans].[Program].[Program]").CurrentPage = "[Plans].[Program].&[ACCT]"
where [ACCT] is our Accounting department.
I have a department variable. I've tried permutations of the follow to no success:
ActiveSheet.PivotTables("Majors_Prog").PivotFields("[Plans].[Program].[Program]").CurrentPage = "[Plans].[Program].&[" & Program & "]"
I'm stuck and can't figure out how this line of code show work.