Hey All..
can anyone help me to know how two or more pivot tables can be connected through one slicer.
I have four differnt tables ( Table1, Table2, Table3 and table4) having the same kinds of data source and column heading and also pivot tables extracted from it.
Now, i have made a pivot chart from pivot table 1 but can i insert a slicer (REGION field) with connection that if i choose "ASIA" from slicer it would display all "ASIA" details from table 1,2,3 and 4..
Also it would be great if i can connect timeline just like slicer.. I would be able to choose year from timeline like 2013 or 14 or 15 or 16 and the charts would change according to that..
Any help would be appreciated thanks
Bookmarks