Instead of 59912490.12 (1*277.32*216041) how to bring 31500460.345588 as Total
The above table has one material and three different vendors...
Is it possible to do ? can we have control on Total calculation because currently qlik give total
Go to Measure Section.
Select Particular Measure.
There is an Option to Show Total.
There is a dropdown to show total as.
Select "SUM" as Option from Drop Down
By Default it will be showing Auto. Change it to Sum
Are you trying this in qliksense?
Yes ,i am doing it in qliksense
Check total function under Measure Tab and choose "SUM" from the dropdown.
instead of column(1)*column(2)*column(3).. use actual expression enclosed in Aggr
= sum(aggr(Expression1 * Expression2 * Expression3 , Material, Vendor))
Retrieving data ...