Attached is a sample workbook based on the data provided in the Excel sheet. I created new calculated fields called "AOP vs. Actuals" and "PY vs. Actuals" and listed those in the table. I total each column using Grand Totals and then changed the Total from Automatic to Average. Let me know if you have any questions!
Book5_REVISED.twbx 59.0 KB