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

Please help me with this Pivot Table Filtering Question

A

ahnkee

New Member
I am having a world of trouble getting this to filter the way I want.. please help!


I am trying to figure out when my sales team is most effective. I have each day broken down into 2 parts: my AM campaign and my PM campaign. I used a Pivot table to total up the deals closed by day. 4 deals closed Monday morning and 6 in the afternoon puts me at 10 for the day. I want to see what factors are at play on the days my team closes more, so I am trying to filter by the sub-total of deals for the day. But instead of letting me filter by 10, it is wanting me to filter by either 6 or 4.


I have my pivot table constructed as follows:

- As my Row Labels, I am using Date. I am using a 2nd Row Label (AM/PM).

- I have about 30 columns currently. The column important to me is the ClosedDeals column and the sub-total for that column.

- In the data sheet for my pivot table, each day/date is broken down into two Rows. Monday-AM and Monday-PM for example.


Thanks for your help
 
Hi ahnkee,


Firstly welcome to the forums!! It will be easier for any one to try to solve your issue if you upload a sample file. Please Read third green post on the forums homepage...


Regards,

Faseeh
 
Thanks, I was very impressed by some of the videos I watched on YouTube and found my way over here.


Anyways, here's the link to the file:

https://docs.google.com/open?id=0B6tIVm3iJGiRTFgxZGdqa1QxNms


I am definitely not smart enough to figure it out on my own so hopefully someone can help me!


Thanks
 
Ahnkee


In the Pivot table Field List, Drag the AM?PM Row label to the top of the Row Labels list
 
You must log in or register to reply here.
Back
Top