Home > Forum Home > Presenting and Reporting Data > Excel 2007 - Pivot Tables - Combination "Show Items with no data" / "Grouping - Group By Date Range" > Only one filter allowed Share

Only one filter allowed

Excel Help for Only One Filter Allowed in Presenting and Reporting Data


Forum TopicLogin

Only One Filter Allowed

Rate this:
(3/5 from 1 vote)
OopsI see the problem.  As only one filter is allowed on the dates, we can either remove the < and > extremes or eliminate a month, but not both.  The solution is to create separate fields first in the source data for month and year.  This simplifies the filtering and provides more flexibility on custom date selection in the resulting pivot report and chart.

To do this, create a new column Month and a new column Year.  Use the formulas =MONTH(date) and =YEAR(date) on the date field and then include these two columns in the pivot report.
 Excel Business Forums Administrator
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for Only one filter allowed in the