Subtotal instead of Total

[TomBond77]

Hi experts

I need to calculate the subtotal of the following example:

Currently I have the logic for Total but I need to subtotal:

Sum({<Year={'2021'}, [Goods Receipt]={'X'}>} TOTAL <[Vendor Key]> [Sales])

Any ideas?

Thank you, Tom.

[Or]

See e.g.

https://community.qlik.com/t5/QlikView-App-Dev/Running-Total-in-Table/td-p/1303901

https://community.qlik.com/t5/QlikView-App-Dev/Running-total-cummulative/td-p/377166

https://community.qlik.com/t5/QlikView-App-Dev/Cumulative-SUM-in-Qlik-Expression/td-p/1399466

[TomBond77]

Thank you 

I don't need a running total, I need a subtotal on (distinct) vendor. But I tried your proposals, it is not giving any results:

Aggr(RangeSum(Above(TOTAL Sum([Sales]), 0,RowNo())), <[Vendor Key]>)

Any further ideas?

Many thanks

Tom

[Or]

I think your formula for the total by vendor is already correct, though that one would repeat for each line rather than showing up once. You might be able to use Below() to only show it once, but this may cause erratic behavior if you also have suppress 0 / null enabled due to the way Qlik handles the combination thereof. It'd look something like:

If(Only(Vendor) <> Below(Only(Vendor)),Sum({<Year={'2021'}, [Goods Receipt]={'X'}>} TOTAL <[Vendor Key]> [Sales]))