Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Here I am creating a bar chart ,which got a drill down dimension ,in this hierarchy middle one got unspecified values ,description given below
zone A
Zone B
Div1
Div2
Div3
Div4
Div5
-----
Sub_Div1
Sub_Div2
Sub_Div3
-------------
how to handle this issue...PFA
Thanks,
JK
That is actually not NULL, rather a space. Try to use calculated dimension in group like:
=If(Len(Trim(Division))>0,Division) // similarly for sub-division as well
PFA
Try, enabling 'Supress When Value is Null' in the dimension tab.
Hi Janaki
Two ways to handle it
1) You can check "Suppress When Value is Null".
2) Enter "Unknown" in Null records.
See the attached example
Thanks
Priyal
Hi ,
I tried it ,but no use, problem here with data. Data as follows
Zone Division Sub-Division Arrears
1 Div1 SD1 10
1 Div1 SD2 20
2 Div4 SD3 30
1 SD3 10
3 Div5 40
Those null values i have shown in the above data causes problem,here Zone,Division,Sub-Division are my dimensions.
can you help me on this issue.
Thanks,
JK
Thank you very much Priyal...
That is actually not NULL, rather a space. Try to use calculated dimension in group like:
=If(Len(Trim(Division))>0,Division) // similarly for sub-division as well
PFA
Can you explain that 2nd point Enter "Unknown" in Null records.do you want me change in entire actual data?,I didn't get that.
thanks,
JK
Thank you it is working for me.