Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Any Help!
Thanks!!
If you are refering to expressions you can try something like len(FIELD)>0 in the condition
Thanks for your reply,
I solve the problem using Isnull, And then with Where Condition.