sum subtotal

[spikenaylor1]

Hi there

Below is my table

Bactch, Package ID, Inspected, Failed are all brought in from source data

I need to calculate for each batch the batch total

I cannot work out how to acheive this

any help or guidance would be gratefully appreciated

Batch	Package ID	Inspected	Failed	Batch Total
ABC123	A24	8011	223	23673 (=sum(Inspected for Batch))
ABC123	A25	6897	135	23673
ABC123	A26	8765	198	23673
ABC124	Z22	2056	22	6711
ABC124	Y677	3057	23	6711
ABC124	T567	1598	98	6711

[sunny_talwar · Accepted solution]

May be this

Sum(TOTAL <Batch> Inspected)

[spikenaylor1]

Thanks

very easy and simple

regards