Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please put your last parenthesis after Componet Qty for each expression
=SUM({<[MonthIndex]={'$(vMaxMIMinus4)'}>}[Sales Quantity]*[Component Qty])
Please put your last parenthesis after Componet Qty for each expression
=SUM({<[MonthIndex]={'$(vMaxMIMinus4)'}>}[Sales Quantity]*[Component Qty])
Thank you Clever. Much appreciated.
kind regards
Nayan