Filter missing values in pivot table

[kprotrka]

As you can see on the screenshot i have one pivot table. For some IDs we dont have values till the end of the year. I need to filter those data(where '-' in pivot table is).

its not a null value and sure how to filter it.

[G3S]

you don't want null values?  or anything '-' ? 

if only the null to be excluded, you can untick the 'include null values" for the field or put in an expression. otherwise if it is '-', then 

if(not isnull(YOURVALUEFIELD) or YOURVALUEFIELD<>'-', YOURVALUEFIELD)

then untick the 'include null values' option.