previous 3 months avg

[#1]

Hi All,

please help to calculate last 3 months of avg. in pivot table.

thanks,

Raja

[arulsettu]

for example calculating last 3 month sales average

avg({<month={$(=max(month)-3)}>}sales)

[arulsettu]

or

=avg({<month={">=$(=max(month))<=$(=max(month)-3)"}>}sales)

[manideep78]

Avg({<month={">=$(=max(month)-3)<$(=max(month))"}>}Sales)