4 Replies Latest reply: May 29, 2015 10:20 AM by Ashley Navin RSS

    Add row of zeroes where dimension doesn't exist

    Matt Maino

      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?