Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I am designing an accounting dashboard.
I would like to now if it was possible to display a line when a value is missing and complete line with Null or 0.
Thank you for your anwer.
olivier
Example:
Is it possible to have 3 lines: Dog 5 Cat 0 and Dear Null/0
where
Dimension is Animal = {Dog, Cat, Fish}
Expression is Animal_Population = sum({<Animal= {Dog, Cat, Dear} >} Animal_Count)
Hi ,
You can do it by unchecking Supress Zero Values and Checking Populate missing in ---> Properties-->Presentation
this shows all Animals with this option:
Dog 5 Cat 0 and Fish 0 but no line about Dear.
Is it possible to stretch dimension showed?