Line Total Divided by Sub Total

[pkelly]

Have a pivot table and want to achieve the above i.e. Take the line total and divide by the sub total - see red square.

Have tried :

=sum(rcv_CostQuantity) / SUM(ALL rcv_CostQuantity)

and also...
 =sum(rcv_CostQuantity) / SUM(TOTAL rcv_CostQuantity)

Not sure if I should be doing some form of AGGR() or using the Dimensionality() function.

As usual, any assistance greatly appreciated.

Thanks

Paul

[jyothish8807 · Accepted solution]

Hi Pkelly,

Can you try this:

 =sum(rcv_CostQuantity) / SUM(TOTAL<ven_Code> rcv_CostQuantity)

[sunny_talwar]

I believe this is what you might be looking for

=Sum(rcv_CostQuantity)/Sum(TOTAL <pro_Rpt01Description, pro_Rpt02Description, pro_Rpt03Description, Type, Code> rcv_CostQuantity)

[pkelly]

Thanks, you are spot on...

jyothish8807 pointed me in the right direction.

[sunny_talwar]

Make sense... Glad he was able to help 🙂