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!!
Attached a new QVW as the previous one wasn't opening due to section access.