• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Clearing filter on a Slicer field removes Top 10 filter on the same field too

V

Vivek D

Member
As part of a Sales Dashboard, I am showing the top 10 clients by Total Contract Value(TCV), Sales by Quarter, Sales by Market offering etc.
I also have a slicer for the Client field on the dashboard to enable users to choose a client and see data specific to it i.e. Sales by Quarter, Sales by market offering etc.

When I choose a single client in the Client Slicer, the Top 10 Clients pivot shows the one client that has been selected which is how I want it.

However, when I clear the filter (reset) on the Client slicer, the top 10 filter goes away too and the pivot ends up showing all the clients.

Is this a bug or am I doing something wrong?
 
Hi Vivek..

Click on "Clear filter from Client" & Clear Filter in Slicer section are same thing..

upload_2014-7-11_0-38-49.png

You cant set Clear filter in Slicer.. but not in Actual Pivot Table..
 
Vivek D said:
As part of a Sales Dashboard, I am showing the top 10 clients by Total Contract Value(TCV), Sales by Quarter, Sales by Market offering etc.
I also have a slicer for the Client field on the dashboard to enable users to choose a client and see data specific to it i.e. Sales by Quarter, Sales by market offering etc.

When I choose a single client in the Client Slicer, the Top 10 Clients pivot shows the one client that has been selected which is how I want it.

However, when I clear the filter (reset) on the Client slicer, the top 10 filter goes away too and the pivot ends up showing all the clients.

Is this a bug or am I doing something wrong?
Click to expand...
Hi, I'm new here but I was having the same issue and I found a solution to it so i want to share it with you, go to the pivot table you want to filter, right click, 'pivot table options', under the 'totals & filters' tab check 'allow multiple filters per field'. work beautiful now.
 
You must log in or register to reply here.
Back
Top