Get instant live expert help on I need help with pivot table date filter
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Filter the values by date - more recent to the the oldest date in a pivot table.
Solved by S. J. in 18 mins
Filter two columns in pivot table from largest to smallest
Solved by G. D. in 24 mins
I have a line chart created with 3 series (data sources) total, from 3 pivot tables. I also have 3 filters for each pivot table (the same filter for each table). My issue is that my date ranges on tables #2 & #3 are not showing blank data and keeping the date list the same when I filter the pivot tables. I have selected the Pivot table Display Option to 'Display item labels when no fields are in the values area' and it is doing that for the first pivot table, not for the others. The setting is greyed out for tables #2 & #3 and still checked (although not displayed).
Solved by D. B. in 16 mins
I would like to create a pivot table for Doccount, Data Entry & Shipped, but per pivot table we need to filter the India site only
Solved by T. E. in 26 mins
Using VBA to update pivot table filter from multiple values in a list
Solved by I. Y. in 22 mins