How to get the total from the below chart ?

[suvechha_b]

Hi All,

Please have a look of my chart :

The RO expression is  :

=if(SUM(recommended_order_qty)=0 , sum(scheduled_receipts_yielded_unit) , Sum(recommended_order_qty))

Thus , when are doing total is not reflecting.

The Total should be : 7,628,457

Sample Qlikview attached.

[sunny_talwar · Accepted solution]

Try this expression:

=Sum(Aggr(if(SUM(recommended_order_qty)=0 , sum(scheduled_receipts_yielded_unit) , Sum(recommended_order_qty)), [Planning Month]))

[Gysbert_Wassenaar]

Something like:

=sum(aggr(if(SUM(recommended_order_qty)=0 , sum(scheduled_receipts_yielded_unit) , Sum(recommended_order_qty)), [Planning Month]))

If the name of the field you use as dimension is not [Planning Month] then replace it with the actual name.

Note, if you use a straight table instead of a pivot table you can simply set the Total Mode of that expression to Sum of Rows. Much easier.