Hi Friends,
I have one problem.
I have pivot table with 3 sheets and data in each of them.
I want to relate those data so that when I call one element that all 3 sheets contains in that pivot table, it shows data related to that element from all 3 sheets.
I made 3 pivot tables 1 table = 1 sheet, but it would be great if I would get the idea how to have only 1 pivot table.
If not possible in my case, I would like to know how to call the same element in all 3 pivot tables by 1 click on the slicer, and not to call it separately in each pivot table.
To be more clear, I'm sending file attached with explanation in it.
Thanks,
Stevan
Bookmarks