Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Your expression must be:
Sum({<ITEM={'AOP'}>} Value) - Sum({<ITEM={'ACT'}>} Value)
Hope this help you. Regards.-
Your expression must be:
Sum({<ITEM={'AOP'}>} Value) - Sum({<ITEM={'ACT'}>} Value)
Hope this help you. Regards.-
great. you went too fast
Thanks very much !!