I have Pivot table, with 2 dimensions and 1 measure. And only for one Dimension value, there only one value for measure. How can I prevent to show all dimensions with no measure?
I thought that is default, but I have big table with 0 and only one value?
It should be only one record shown (yellow). Yes I know I can to it with set analysis in the measure or an if in the dimension. But isn't there a smarter way?
There are a number of ways you could get rid of the 0 rows. The quickest and easiest is to deselect "Include zero values" under "Add-Ons - Data Handling" in the properties panel of the table object.
