Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.