I have a pivot table and I deactivated the Null-values in my second dimension. and my expression is sum(profit) and I would have 4 values in my first dimension and the first and second value do have some values that are connected to the second dimension. because the third and fourth vaue of dimension1 do not have data in dimension2 I cant see the last two datasets because of the deactivated null-values even though the expression does have a result.
does anyone know how I can hide all the 0 or Null values in the expression and not in the dimension?
