Is there a possibility I can find the average per month (30 days) of a count sum column in a pivot table? If I use the average as summing value I get number one only
What I get is this:
Month Transfers Average June 1 1 July 2 1 August 1 1
Whereas it should be something like
Month Transfers Average June 1 0.333 July 2 0.667 August 1 0.333
Is there an easy way to do this?