Calculating Table Advanced
There is an Excel file that teaches how to perform the Calculating Table Advanced operation.
Excel Calculating Table Advanced
This workbook demonstrates calculating table advanced using VBA macros on a 14-row data layout.
Hope it is useful.