• 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.

Slicer Q

C

cyberx1

New Member
I have a worksheet with many slicers and everything appears to work just fine, until...I try to drilldown on the total value for any record - I get all of the records for that ID - why is this as I ony want the number actions listed in the total cell, not ALL o fthe actions for that person? FYI that I'm using a connection to get the data from Access.


M
 
...can you upload a sample file for someone to look at.... it will solely depend on how your data is organized.
 
Thank you for the reply.


Unfortunately, I can't due to the nature of the material. Now on a regular Pivot Table without use of slicers gives one the exact numebr of records, however, when using slicers, and one selects a specific date, for example, more records are returned than are assinged to that date on the slicer (the total value syas 10, for example but many more records are shown in the drilldown worksheet from other dates).


M
 
You must log in or register to reply here.
Back
Top