avg a pivot chart data

[#1]

I have a field called month and i need to avg the last two months data and the last two months data and next month data and so on how can i do this

[tresesco]

You could try something like:

=rangeavg (above(Sum(x),0,1))

[#3]

hi,

but i am not getting the exact answer

PFA

[tresesco]

Small correction:

=rangeavg (above( Sum(MARC_FinMonth),0,2))

[#5]

there is no difference between both the statements, the data for both the statements are same

there is any error in the above expression that calculates the sum of monthend inventories 

[tresesco]

PFA. Isn't this what you want?

[#7]

hi that works well but i have a another question to u

question is that i have three fields LABST, UMLME, 3pl stock i need the monthend closing stock for this fileds and i have a condition for 3pl stock i.e

RecieveDate <= MonthEnd & GRDate = “ ” or > MonthEnd