MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
View: 215|Reply: 1

Pivot table dropping months when filtering

[Copy link]

3

Topics

3

Posts

17

Integral

Member

Rank: 2

Integral
17
Post on 2-7-2017 11:15:03 | All posts |Read mode
I have a pivot table set up with Rows = Years and Columns = Months. When filtering on product, some month columns for the set of years (i.e., all junes for 2011-2015) do not have any data and the pivot table does not show those particular month columns. However, I have both Show items with no data on rows and Show items with no data on columns checked for the pivot table. I have all of the data in the data model. Is there a workaround for this?
Thanks!
Reply

Props Report

34

Topics

1969

Posts

4182

Integral

Forum Legend

Rank: 8Rank: 8

Integral
4182
Post on 2-8-2017 13:55:00 | All posts



Pivot table issues are difficult to diagnose without also seeing the source data. Please attach a workbook with non-sensitive, sample data that illustrates the issue.
Reply Support Opposition

Props Report

Points policy of this forum

Archiver|Mobile|Small dark house|Contact us|Excel Bar

GMT-5, 11-18-2017 05:11 , Processed in 0.196324 second(s), 20 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

!fastreply! Top !return_list!