Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
is it what you required?
PFA
you can get it using Max(Month) expression.