How to fetch multiple values from the filter using max function

[siddharthsoam]

Hi

I want to fetch multiple values from month filter where the month is the maximum in a quarter

for ex it should show me data of the maximum month for quarter 2 i.e. Sep, when I select Q1 and Q2 it should show me data for Sep month and June month summed up

[siddharthsoam]

I don't have a date field , I have quarter filter and month filter where months are derived for their respective quarters

[shraddha_g]

Do you have Year Field?

[siddharthsoam]

Yes I have a year field as well named Fiscal Year

[shraddha_g]

is it possible for you to share sample app?

[siddharthsoam]

Hi Shradha,

PFA of the sample qvf file

[shraddha_g · Accepted solution]

PFA as required

[siddharthsoam]

Thanks shraddha

[siddharthsoam]

Shraddha if I have my year format as FY17 , how do I use it in date# function

[shraddha_g]

Date#(mon & ' ' & purgechar(Year,'FY'),'MMM-YY')