Forum Discussion
Kadir_erken
Jul 29, 2023Copper Contributor
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...
- Jul 29, 2023
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.
Kadir_erken
Jul 29, 2023Copper Contributor
Thanks i check the pivot tables and change all data sources to one table it solves my problem
SergeiBaklan
Jul 29, 2023Diamond Contributor
Kadir_erken , you are welcome, thank you for the feedback