totals per salesfamily not based on expression but on numbers calculated

[chriscools]

Hello,

i have a calcuation in qlikview where a forecaste number of pieces per salesfamily is divided by the desired MOQ, to have an idea of the ideal number of references per sales family.

The calculation on the row of the salesfamily is correct, but  the last column in the example below gives me a problem when counting the totals.

I don't want 307 which is the calculation based on the 2 columns on the left, but i want it to give the sum of the numbers below in the yellow part.

Is this even possible?

thanx!

Chris

[Kushal_Chawda · Accepted solution]

@chriscools  What is the expression you are using for the last column?

Try below

=sum(aggr( Expression1/Expression2, salesfam,[sab salesfam]))

Write full expressions in Expression1 & Expression2. Also if there are any other dimension in pivot, include that as well in Aggr

[chriscools]

ah yes, that solved it! thank you very much!!!

Chris

[JacobMay1]

I'm happy to see the issue is now solved. Thank you for updating us with the outcome.

paycheckrecords