Any ideas as to why this calculated field won't work in my Excel pivot

[LJacobs]

In this pivot, I'm trying to calculate a "Avg by Week by Month" result. The challenge has been some months have 4 weeks & other have 5. I thought this formula would work >> =IF(WeeksInMonth=5, SUM(Counter)/5, SUM(Counter)/4). Unfortunately, Excel is miscalculating where WeeksInMonth = 5. I'm not committed to using this method, but my report has to be displayed as a pivot. Any assistance would be very much appreciated! Thanks!

 

[rahulshewale1]

hi @LJacobs ,

See if is it okey ?
i used helper columns

 

[LJacobs]

Thanks for the assistance! I'll give your suggestion a try.