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

pivot table - label filter in a date format

A

akuku

New Member
Hi!


I have a problem with label filter in Pivot table. I want to create such a filter for date formatted cells and it's not working fine. I want to filter all dates that are between two dates and it does not work.

Please find the link to file attached.

http://www.speedyshare.com/tVA2D/pivot.xlsx


Thanks for help!
 
Good day akuku


How do you filter on a date that does not exist.?? If you use dates in your data then the filter works.
 
http://www.speedyshare.com/2QD4Y/pivot.xlsx


I changed the dates and apply date format. Pivot table reads the data as a text string obviously. Why? And I found that there is such an option as 'date filter' instead of 'label filter' in pivot tables options (as in this video in 1:40 http://www.youtube.com/watch?v=zQMA9lw4EyU ) Do I need to set any format to get such an option?
 
Hi, akuku!

The issue isn't in the pivot table but in your data. Column B of worksheet Sheet1 contains text strings and not dates. Try changing any date in column B and you'll get a long formatted date (when you widen the column), so change column B data contents and not just formatting only.

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