Fetch max month value with respective to multiple quarters

[siddharthsoam]

Hi All,

I want to fetch  max values from the months filter with respective of quarters I select. So for example I select quarter 1 it should show me max month of quarter 1 i.e. june, if I select multiple quarters ex Q1,Q2 it should return june,sep

Quarter       Month

1               Apr,May,Jun

2               Jul,Aug,Sep

3               Oct,Nov,Dec

4               Jan,Feb,Mar

[shraddha_g]

is it what you required?

PFA

[agigliotti]

you can get it using Max(Month) expression.