Please assist me to get reports for Last 12 months from Max Month ?

[suvechha_b]

Hi All.

How can I make the field [Claims Captured Month] dynamic.

Say for example , Pick the Max([Claims Captured Month]) then , I have to show report for Last 12 months.

say for eg,

And a Pie chart - Count(Distinct [Claims Captured Claim Number]) for last 12 months.

sample model attached.

Thanks,

Suvechha

[AdiPai]

use Today() as a reference and build expressions based on it to find the last X months - years ..