I am using a pivot table with two dimensions. The second dimension is a calculated dimension that is grouping the data into 3 categories. The problem I am having is that for some of the top dimension values there aren't always all 3 categories in the second dimension. I would like to display all 3 possible second dimension values for each first dimension value regardless of whether there are any rows in my data set that have that first dimension and second dimension combo - just put zeroes where this is the case. Is this possible?
If this is the if-statement I am using, how do I get the dimension 'ment' to appear even when it doesn't satisfy the if-statement... I would like 'ment' to be displayed with all zeroes if it does not satisfy the if-statement