Calculating Sub-Total in a Straight Chart Table with Component

[#1]

Hi 

I have a straight table with sub-totals , however I am stuggling to calculate the sub-totals for all the columns in the table

I have posted a similar discussion recently , but only this time each field is multiplied  by a component quantity.

Please can you assist calculating the sub-total.

kind regards

Nayan

[Clever_Anjos · Accepted solution]

Please put your last parenthesis after Componet Qty for each expression

=SUM({<[MonthIndex]={'$(vMaxMIMinus4)'}>}[Sales Quantity]*[Component Qty])

[#3]

Thank you Clever.  Much appreciated.

kind regards

Nayan