How to write the expression

[suvechha_b]

I got a chart like below :

By default , I don't want to show Precessed . so thus , I used the expression fo 'Sales Value'

sum({$<TranType = {$(vAmountType)},[Fiscal_Year]=,[Month]=,category_of_sales={'*'}-{'Processed'}>} Amount)

Then getting the above chart, which is my requirement.

But , when I am trying to select 'Unprocessed' and 'Unspecified' then it is not selecting.

How can I select 'Unprocessed' and 'Unspecified' ?

[Peter_Cammaert · Accepted solution]

With this?

sum({$<TranType = {$(vAmountType)},[Fiscal_Year]=,[Month]=,category_of_sales -= {'Processed'}>} Amount)

[Kushal_Chawda]

would you be able to share the sample?

[Anonymous]

Just Click on 'Unprocessed'...see whether selection is happening.

Also make it fully compressed either by clicking on + sign or

Properties - > Presentation - > Always Fully Compressed(Left Bottom)