Delete Null Without Dimension

[pgalvezt]

Hello,

When I have a pivot table I check (Delete Nulls). I have one dimension cc1, Show many option and values (this is my expression Sum({<Año={'2014'}>}pp1_01)*-1 The pivot show all values when I check Delete Values the information is correct. But I have another sheet with many charts those charts doesn´t have dimenssion. So How I can delete the same nulls?

Thanks,

[pgalvezt]

Any Help!

Thanks!!

[Anonymous]

If you are refering to expressions you can try something like len(FIELD)>0 in the condition

[pgalvezt]

Thanks for your reply,

I solve the problem using Isnull, And then with Where Condition.