PDA

View Full Version : Interconnected Slicers Filtering Issue



jpc.pablo.1995
2016-07-22, 08:56 AM
Hi,

I actually have a report where there are three pivot charts.

Here are the details:

First Chart- Shows the daily progress of a user
Second Chart- Shows the weekly progress of a user
Third Chart- Shows the breakdown of the user's progress (points)

I made four slicers which are connected right now:

Week
Date
User ID
Evaluation

My problem is this, whenever I click the week in the slicer together with the date it's automatically filtered, the data that is only shown is the data that I selected.

How can I do it that each slicers are still connected and here what I want to do:

On the first chart, I want to show the data for the entire week (I already used the Week in the filed list as an axis field)
On the second chart, Ill be able to show the weekly data
On the third chart, to show the data for the entire week (I already used the Week in the filed list as an axis field)

Thanks.

Pecoflyer
2016-07-22, 09:33 AM
cross posted without links:

For your information, you should always provide links to your cross posts.
This is a requirement, not just a request.
If you have cross posted at other places, please add links to them too.
Why? Have a read of http://www.excelguru.ca/content.php?184

ps. The same applies to your other recently started thread here too.

Members are invited to not answer this thread as long as links have not been added - Thx

jpc.pablo.1995
2016-07-23, 12:09 AM
Hi,

I do apologize for what happened. This is the link:

http://www.excelforum.com/showthread.php?t=1148730&p=4438945&highlight=#post4438945

Thanks.

Please I greatly need help from you guys.

Pecoflyer
2016-07-23, 08:36 AM
Thanks for adding the link

Could you please post a real sheet instead of a picture?