How to complete a value mentionned in the expression and not in selection of a dimension

[#1]

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)

[vijay_iitkgp]

Hi ,

You can do it by unchecking Supress Zero Values and Checking Populate missing in ---> Properties-->Presentation

[#3]

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?