I have 4 data tables which all have a field "Name" in common. I made a 5th table with just the names and no duplicates and connected the other 4 to it in relationships. I then created pivot tables for each data table and tried to create one slicer that works to filter all but, when I go to report connections on the slicer only 2 options are there. What could be the possible reasons and fixes for this issue?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
One slicer for multiple data sets, created relationships to one table from 4 others but, when I go into Report Connections only 2 tables of 4 show
- Thread starter jb00976
- Start date
Excel Facts
Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Similar threads
- Replies
- 4
- Views
- 222
- Replies
- 0
- Views
- 735
- Question
- Replies
- 2
- Views
- 1K
