Average for Last 12 months

[raviityou]

30

Hi ALL,

I am trying to calculated the last 12 month average sales

With the following expression =

RangeSum( Before( Sum({<FKART = {'ZC07', 'ZS1'}, Flag = {'2'}, KPI = {'SalesDomesticAnalysis'},Fiscal_Year=>} MENGE),0,13))/12

With this expression values get reflected but I want to show only when last 12 values is available, suppose I have data from jan 2014 to march 2015 then the output value should get reflect only onward from jan 2015.

Values should not reflect for jan 2014 to dec 2014.

Please find attached sample data and expected result.

[Chanty4u]

chk dis

Calculating rolling n-period totals, averages or other aggregations

[Anonymous]

First Use Cross Load to transform this excel table, see this?

The Crosstable Load

Then this would help you?

Calculating rolling n-period totals, averages or other aggregations

N-period rolling data, moving average, easy solution.

[raviityou]

Thanks for response,

But how can i show value only onward Jan 2015.

I have min Date is Jan 2014 and i want to show only last 12 month average  mean Sum( form Jan 2014 to Jan 2015 )/12

into Jan 2015 column before it all column should be empty.

978n is

[Anonymous]

Could you share a sample data?

[raviityou]

Hi Balraj

I have attached sample excel data with expected result. once again i am attached sample data.

1380

1382