Sum with condition in expression of the bar chart.

[#1]

Dear,
I need some help in expression chart.

My case:
I need to do a sum with condition on the bar chart.
For example:
I need to do the sum of the ITEM AOP and subtract the sum of ITEM ACT.
In this example the results must be 1.

ITEM	Value
ACT	100
ACT	20
ACT	40
AOP	110
AOP	21
AOP	30

Tks Regards

[#2 · Accepted solution]

Your expression must be:

Sum({<ITEM={'AOP'}>} Value) - Sum({<ITEM={'ACT'}>} Value)

Hope this help you. Regards.-

[#3]

great. you went too fast

Thanks very much !!