Display data of last month loaded in fiscal quarter year

[ruma_barman]

Hi All,

I want to show revenue in fiscal quarter wise where each quarter should show the data of maximum month loaded for that quarter.

Eg: For Q4 2017,we have three months Jan,Feb,Mar 2017.If all the three months data are loaded then we should show data of only March2017 in Q4 2017,if Jan & Feb are loaded,it should show Feb data and if only Jan is loaded then it should show only Jan 2017 data in Q4 2017.

Attached one sample qvf file.

Thanks and Regards,

Ruma

[ruma_barman]

stalwar1‌

[sunny_talwar]

Try this

Sum(Aggr(If(Max(total <[Fiscal Quarter Year]> MonthName) = MonthName, Revenue), MonthName, [Fiscal Quarter Year]))