Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I used rank() in expression defination for calculating top 10...and i got that but in front of dimension other than top 10 showing " - " this symbol .....how i can suppress them in chart...
below is my expression :-
=if(Rank(Count( {<SUB_VERTICAL_DESC={'AUTO'} >} SI_NO)) <=10,Count( {<SUB_VERTICAL_DESC={'AUTO'} >} SI_NO))
Kindly help !!!!
Regards
Sarfaraz
hi try this
=if(replace(Rank(Count( {<SUB_VERTICAL_DESC={'AUTO'} >} SI_NO)) <=10,Count( {<SUB_VERTICAL_DESC={'AUTO'} >} SI_NO),'-',''))
Hi,
Did you try Suppress when value is Null option to check.
Regards
Anand
yes.......and i am using pivot table ........
Sarfaraz
Hi Arul,
Showing error in expression .........
Sarfaraz
Hi,
Instead of using rank in expression, use it in calculated dimension aggr(if(Count( {<SUB_VERTICAL_DESC={'AUTO'} >} SI_NO)) <=10,Your_dim),Your_dim) and check suppress nulls values for dimension.
Use normal expression in expression.
cheers,
amay
Dear Amay,
I have done the same what u r saying to do me...by doing so i am not getting the expected result .......in expression i am getting expected result .....i just want to suppress the null value ...thats it
Sarfaraz
Hi,
I have attached a sample application. I am getting it in this application.
Hope this help. If this doesn't help, kindly post your app.
Amay
Dear All,
Please find my attached QVW for your reference....kindly check and help me.
Sarfaraz
i missed a ) have tried with this?