Include Non Existing/Missing Dimension Values

[gizzel123]

Dear Friends,

I have a very different requirement. I have some fields namely Plant_ID, Product,and Geography (State/City) etc etc.

Requirement is a table of :State vs Count(Plant_id)  with filters like Product etc..

But in my case even if we select any specific Product for which some states doesnt have plant should up show in the table . Thouh they will appear with zero plant_id .

For example . US has 51 states in this scenario. and if I select Product=2, then data gets reduced to 33 rows . Which is correct. But the requirement is to show the rest of the 22 States with zero count(plant_id).

I am attaching  a sample QVW for reference.

Your Help is much appreciated!!

Thank you.

Attached a new QVW as the previous one wasn't opening due to section access.

[sunny_talwar]

Attached qvw seems to have section access... can you repost without section access

[sunny_talwar]

Also, did you try to uncheck 'Suppress Zero Values' on the presentation tab?

[gizzel123]

I have reattached. Please check.

[sunny_talwar]

Try this expression

=Count(DISTINCT plant_id) + Avg({1} 0)

and uncheck 'Suppress Zero Values' on the presentation tab