Hi everyone
Dimmension is customer
Measures other field
I' ve got a problem with bar chart. It gives me a bar multiplicates sum of a column qty (950) and sum of a cost (2,87). The reslut is 2776,5. I would like to multiplicate each row (qty*price) and then sum te results and show on te bar chart. The propper result should be 1345,5. How to get it on a bar chart.
Probably is the simpliest you ever done, but i am brand new to qlik sense
| customer | qty | price | cost |
| A | 100 | 0.31 | 31.00 |
| A | 700 | 1.78 | 1246.00 |
| A | 100 | 0.53 | 53.00 |
| A | 50 | 0.25 | 12.50 |
| total | 950 | 2.87 | 2726.50 |
