Thread: How to create multiple pivot charts with different metrics from the same pivot chart?
View Single Post
 
Old 01-23-2023, 03:20 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
The pivot tables/charts need to have their own pivotcaches. See https://www.contextures.com/xlpivot11.html#newcache
Also: Stop all the pivot tables applying the same grouping method •

You could try Ashish Mathur's suggestion here: Redirecting

also: Unshare a data cache between PivotTable reports - Microsoft Support
Reply With Quote