I have a pivot table with YTD information by month for about 8 different KPI's. I want to show some of the KPI's by month to provide trend data. The others I just want the current month to save space on the worksheet. Can I filter the data on KPI's 1 thru 5 to show January thru November and filter KPI's 6 thru 8 to show December only? The rows provide region and office detail. Thanks.