Fowmy
Well-known Member
- Joined
- Jul 10, 2008
- Messages
- 516
- Office Version
- 365
- Platform
- Windows
I have two Pivot Tables that share the same datasource.
There is a date field in both pivot tables. I want to group the date field on Monthly basis in one Pivot Table and group on Week basis on the other. But, It does not work and the both pivot tables insist on having the same grouping.
Can anyboy suggest a solution ?
There is a date field in both pivot tables. I want to group the date field on Monthly basis in one Pivot Table and group on Week basis on the other. But, It does not work and the both pivot tables insist on having the same grouping.
Can anyboy suggest a solution ?