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: 744
p45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud of
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