This is the sample data. What I want to calculate the average collection per vehicle for June and July together.
And want to compare it with August month in the same graph.
This could then be averaged across another dimension (eg. venue then car type then model) when dragged into the view.
So, what is the formula?