Calculated dimension not returning all values

[whalenem]

So, I have a need to show all values for a Division of a Category, regardless of sales. Say my data set looks like the below...

Category	Division	Sales
A	1	100
B	1
C	1	100
D	2	100
E	2

If my dimension in the cyclic is "Category", I get all five. Perfect.

If try to show all Division=1, I only show A and C - likewise with Division=2, I only get D. This is because the table is accumulating sales from items and there are no items sold. Expression: =if("Division"='1',"Category")

I want to show A, B, and C if I select Division=1 and D and E when selecting Division=2.

[aarkay29]

Try this

Go to the chart properties and include null values

[whalenem]

That only drops the Division=2 (and Division=1 without sales) values into a [null] category, it doesn't display Category B.

[aarkay29]

If you attach the qvw with sample data would be helpful to understand