I got several pivot tabels that hold rows where all values are 0 or empty.
By default I always get a row with "-" in the dimensions of the pivot tabele.
How can I get rid of them so I don't see them anymore?
Make sure the option Suppress Zero-Values is enabled on the Presentation tab. And that Show All Values is not enabled for the dimensions of your pivot table
So somehow that dosn't work here, I still got rows in the pivot where all values are 0. Can it cause of the dimensions, so I got QuarterYear and inside the Month, where for example two months have only 0 values.
Would it be possible to provide us with a small data sample where you are experiencing the issue?
Okay, so my problem was that I didn't tick the "don't show NULL' not for all dimensions
use isnull function.
Retrieving data ...