Extracting Grand total from Pivot Table

[flupsie]

I have sample data from a Pivot Table (A7:G15)


I am looking for a formula to extract the Grand total for each of the branches. The Pivot table data will change each month


Your assistance is most appreciated

[FDibbins]

Try this, copied across...
=INDEX(B$9:B$100,MATCH($A$3,$A$9:$A$100,0))

[flupsie]

Thanks for the help. Formula works perfectly

[FDibbins]

Happy to help an thanks for the feedback