Doubt about jerarquic dimension and null in a value
Hi i have this for example
ID adress Date1 Date2
1 233232 10/10/12 10/10/12
2 2312312 10/11/14 10/6/12
3 12312123 25/10/12 5/10/12
4 44444
5 1231233
my expression is a sum of id (number of propertys)
I have "status". This is Date 2 - Date 1 with and if (i do this in the code) and because the number they have different names like "ok", "expired", etc.
And adress
My dimmension is a jerarquic dimmension Status - Adress
The problem is that when i have null values in the data in the graph i have this "-"
I'm thinking about a isnot null or something similar but how i do this in the jerarquic dimmension?