Simple question - PivotTable showing all values

[m4u]

Hello

I have a simple pivot table - products on the Y axis, months(1-12) on the X axis and SUM(Sales) as the expression.

When displayed fully, no problem. Problem begings when user selects item(s) with no sales in a certain month - for instance, with sales only in 3 months. The pivot will show those 3 months only, while I want it to show all 12 months always, with zero. Supress zero values is not marked.

How can this be acheived?

[lironbaram · Accepted solution]

hi

what you need to do is very simple

in the dimiensons tab you check the boxes 1.how all values , 2.supress when value is null , for the desired dimension

attach is an example

[m4u]

Thanks alot