How to get the Average for multiple months data.

Rajakumar Burra

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:

KhaderBelgoud-Oracle

You may try the aggregate by option on the workbook properties.

Refer attachment for an example

Sample app.png

Rajakumar Burra

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

GayathriAnand-Oracle

Does this output look correct?

Thanks

Gayathri

Rajakumar Burra

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