Show variables without data

Abrein

New member
Joined
Nov 29, 2016
Messages
1
Reaction score
0
Points
0
[FONT=&quot]Dear All, I can't show categories, variables without data in pivot table inserted from data modell. For example I would like to see sales data/every month in a chart, but there is no sales is some of the month.. In "normal" pivot I can choose to see empty cells with no data, but in data model pivots this option is not available. Is there any solution for this? Thank you,[/FONT]
 

royUK

New member
Joined
Mar 22, 2011
Messages
155
Reaction score
0
Points
0
Location
Derbyshire, UK
Website
www.excel-it.com
Excel Version(s)
most versions
Please don't try to use clour tags on your posts. They don't seem to be working and would be of no benefit.

I suggest that you attach an example workbook
 
Top