tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,197
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
I have two pivot tables
the first is "PivotTable2"
the other is "PivotTable3"
Now "PivotTable2" gives me result for salespeople according to a number of slicers i use
one of the columns is called "Sales Week"
And has a list o weeks like this
2020-W01
2020-W02
2020-W07
etc.
now "PivotTable3" has the same header "Sales Week"
but list different weeks because the critiors are different, so it show more weeks
like this:
2020-W01
2020-W02
2020-W03
2020-W04
2020-W05
2020-W07
etc.
now i know the pivot tales have filters and i can manually filter to only show in "PivotTable3" ,"Sales Week"
the same weeks as "PivotTable2" ,"Sales Week"
but i can't do it with a macro which i need?
now if its easier i can create a list of the weeks i want to show in Column A so instead of going to pivot table 2 you just filter "PivotTable3" ,"Sales Week" to show only the weeks in column A but i still need help on how to do this
any ideas or help would be greatly appreciated
Thank you
Tony
I have two pivot tables
the first is "PivotTable2"
the other is "PivotTable3"
Now "PivotTable2" gives me result for salespeople according to a number of slicers i use
one of the columns is called "Sales Week"
And has a list o weeks like this
2020-W01
2020-W02
2020-W07
etc.
now "PivotTable3" has the same header "Sales Week"
but list different weeks because the critiors are different, so it show more weeks
like this:
2020-W01
2020-W02
2020-W03
2020-W04
2020-W05
2020-W07
etc.
now i know the pivot tales have filters and i can manually filter to only show in "PivotTable3" ,"Sales Week"
the same weeks as "PivotTable2" ,"Sales Week"
but i can't do it with a macro which i need?
now if its easier i can create a list of the weeks i want to show in Column A so instead of going to pivot table 2 you just filter "PivotTable3" ,"Sales Week" to show only the weeks in column A but i still need help on how to do this
any ideas or help would be greatly appreciated
Thank you
Tony