How to find out last 6 months sales average?

[Akina0929]

Hi all,

  I want to find out the last 6 months sales avg , how can we find please help me.

best Regards

Anji

[Anil_Babu_Samineni]

Bulk thread are there in community, If you just start from your end.

For your question - May be this?

Avg({<DateField = {">=$(=AddMonths(Max(DateField),-6)) <=$(=Max(DateField))"}>} Sales)