How to get the Average for multiple months data.

Question

I have a workbook to calculate average for monthly allocation. It is working fine for single month calculation, but I am not get the average data for selected months are greater than one month.

My expectation to get the average based on number of months.

Attached the workbook for quick reference.

TestWorkbook.dva

Description.

Data showing for Jan month.

Data showing for Feb month:

Data showing for Jan & Feb Month:

My expectation if I select Jan & Feb Month:

Calculation for Capacity Avg:

Rajakumar Burra · Answer

@GayathriAnand-Oracle  It is not working. Also there is no way to do in workbook. I have created a Dataflow to achieve my results.

GayathriAnand-Oracle · Answer

Does this output look correct?

Thanks

Gayathri

Rajakumar Burra · Answer

@KhaderBelgoud-Oracle  I have already used "Sum" so ,it can't be re-used .