What I have attached shows the weeks by row and the FY by column. The weeks display the total number of distinct count giving units (households who have made a contribution to the church) on a weekly basis. I have then used the "Analytics" option to show the average by year. What I would like to display is the weekly average without having to show every single week. The idea is to be able to show increase/decrease of this metric on an annual basis.
I'm sure there is a simple resolution to this, but I have been wrestling with this for too long.
Amber Smart you were a significant help with my last data visualization quandary. If you have time to review this issue I'd appreciate it.