Hi

I am looking to create what I think should be a simple report but I cannot seem to get it right. I have a table filled with Expenses spanning multiples months. I want to create a Pivot report (or something that works) where each month is displayed as a column, each expense is displayed as rows and the data is a SUM of each expenses for that month. However in the summary column I would like to display the AVERAGE of each expense across all the months. The standard PIVOT table SUMS all the months in the summary columns where I am looking to add an AVERAGE of the months in that column. This way we can see the TOTAL value for each expense per month and the AVERAGE per month for that expense in the summary.

I tried adding an Aggregate Formula using fixed_groupby and sum, but it is not working. Can somebody guide me in what would be the best way to accomplish the above report.

Thanks

Andrew