Dimension is shwon even Measure is null

[berndjaegle]

Hi guys, 

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?

BR,

Bernd

[GaryGiles]

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.