This content has been marked as final. Show 4 replies
I have a need to create a bar chart which will display the past 12 months including the current month with some calculations.
Rolling 12 months formula is available in plenty across the community, but my problem is calculating the average of a particular column from previous year. I have attached an excel which covers all the details, let me know if you need more information.