3 Months Average in Straight Table ?

[raju_insights]

Hi Techies,

I need to find average of 3 months in a  straight table. Here Month_Yr is dimension. I have measure field day wise from source table.

Example:

For Month_Yr "Mar-2015", calculate average for values from 01-Jan-2015 to 31-Mar-2015.

For Month_Yr "Apr-2015", calculate average for values from 01-Feb-2015 to 30-Apr-2015 and so on.

Here I have attached Test files for your reference.

[raju_insights]

Hi Anil,

It should be constant.

[raju_insights]

Awesome Sunny! This is what I want. Thanks .

[sunny_talwar]

Great

[vinieme12]

Without making changes to your load script you can use expression as below

rangesum(above(sum(Measure),0,3))

/

rangesum(above(Count(DateIS),0,3))

[raju_insights]

Extraordinary Vineeth ... Perfect...