3 Month Prior Sales in set-analysis/Scripting

[abhaytrip]

Hi folks,

I'm stuck in a problem where I need to present the 3 Month prior sales (including the 3rd Month) in a straight table , but im unable to do so.

here im attaching the image where you can find the sample example of the problem stated above.

any sort of help is appreciate.

Thanks,

Abhay

[sunny_talwar]

Or you can try this

Above(Sum({<[Month-Year]>}Sales), 3) * Avg(1)