Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have field billing
billing
accounts
payment
tenders
dues section
fines section
I am using billing field as dimenstion, now i dont want to display tenders and dues section columns in my chart?
Can anyone please help me ASAP.
Thanks,
Durga
no it is clearly showing syntax error under { beside tenders. but expression is ok. I am not get output as required.
it is a well known bug in the syntax highlighter/checker that has been there for years...
Try like this in your calculated dimension
if( billing <> 'tenders' and billing <> 'dues section' ,billing)
bars are displaying still now.
Please advice me to display bars whatever i required?
Can you post sample app
I have no access to post sample app, I just want to hide the particular bars (unnecassary which is not required to client) in bar chart
Otherwise if I am able to display particular bars also fine.
I am trying to write calicualted dimension but not get output.
Thanks,
Durga
check this
Hi Anbu,
Please give me the screenshot, i have no access to download and upload in office.
Waiting for your reply!
Durga
Load * Inline [
billing,payment
tenders,100
dues section,200
aaa,50
bbb,60 ];
In Chart,
Calculated dimension: =Aggr(Only({<billing -= {'tenders', 'dues section'}>} billing), billing)
Expr: sum(payment)
Check "Suppress When Value is NUll" in chart