help me in writing expression?

[durgabhavani]

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

[durgabhavani]

no it is clearly showing syntax error under { beside tenders. but expression is ok. I am not get output as required.

[petter]

it is a well known bug in the syntax highlighter/checker that has been there for years...

[sunilkumarqv]

Try like this in your calculated dimension

if( billing <> 'tenders' and billing <> 'dues section' ,billing)

[durgabhavani]

bars are displaying still now.

[durgabhavani]

Please advice me to display bars whatever i required?

[anbu1984]

Can you post sample app

[durgabhavani]

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

[anbu1984]

check this

[durgabhavani]

Hi Anbu,

Please give me the screenshot, i have no access to download and upload in office.

Waiting for your reply!

Durga

[anbu1984 · Accepted solution]

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