Fixed dimension on pivot table

[#1]

Guys, I have a model where I own a grouping of products by area. I need to create a table that shows me the summation of these areas when I filter dates. however to filter a date that does not have record for all areas is necessary that a line appears for this area with zero value. The column description of the area can not be reduced by the filter.

[Gysbert_Wassenaar]

See attached qvw. Is that what you need?

[#3]

Sorry, I wrote simple table but I need do this on pivot table

[Gysbert_Wassenaar · Accepted solution]

Try sum(Value)+sum({<TimeMonth=>}0) and disable the option Suppress Zero-Values.