Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try sum(Value)+sum({<TimeMonth=>}0) and disable the option Suppress Zero-Values.
See attached qvw. Is that what you need?
Sorry, I wrote simple table but I need do this on pivot table
Try sum(Value)+sum({<TimeMonth=>}0) and disable the option Suppress Zero-Values.