Forum Discussion
Solved
Pivot tables not exist in report connection menu
I'm trying to control multiple pivot tables in Excel with a single slicer, but in the Report Connections section, only up to 3 tables appear at a time. How can I make the other tables visible in repo...
Slicer is applied to the PivotTables where is used the field from the same source. If you have one-to-many relationships, hide related field on many side and use in PivotTable such field only from one side.
Slicer is applied to the PivotTables where is used the field from the same source. If you have one-to-many relationships, hide related field on many side and use in PivotTable such field only from one side.
Thanks i check the pivot tables and change all data sources to one table it solves my problem
Kadir_erken , you are welcome, thank you for the feedback