Forum Discussion
Refer to multiple data sheets to return cell content
I have 3 separate pivot tables (fed by 3 data sources) on 3 separate worksheets within a single workbook that are all linked to 1 slicer. Based on the slicer selection there can only be data populate...
Can you please post an example file with non-sensitive data It's often easier to address the issue with a sample file or a more concrete example of the data representation. This will make it easier for other community members to answer your inquiry.
It's hard to tell without an example but you may try a combination of IF() and GETPIVOTDATA()