Matrix shouldn't show +/- values if it category doesn't have subcategory values

[ashuaswinireddy]

Hi,

I have two tables

Table A

ID	Category
1	A
2	B
3	C

Table B

ID	Sub Category
1	aa
1	bb
1	cc
2	dd

We have Category for ID 3 but do not have sub category for ID 3. In this case I do not want to see +/- for Category C. How can I achieve that.

Please let me know if there is a way to do this.

If I uncheck "Show items with no data" it is completely removing the category values.

Thank you!

I am creating Matrix using above two tables category and subcategory

[Ritaf1983 · Accepted solution]

Hi @ashuaswinireddy , it is not possible to display +/- conditionally. When you have defined a hierarchical matrix and want the design to be with +/-, the sign will appear
Independent of the values in the subgroup.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.