Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
In a three different text box i need to show First, Second, Third max year and Quarter
Data is in below format
According to the above data F'19Q2, F'19Q1, F'18Q4 should be shown each value in each text box
i tried multiple functions such as Max, Firstsortedvalue etc but nothing is working
Any suggestions Plz
Thanks
Try using the following:
=only(if(aggr(Rank(Sum(FYQU)),FYearQuarter)=1,FYearQuarter))
=only(if(aggr(Rank(Sum(FYQU)),FYearQuarter)=2,FYearQuarter))
=only(if(aggr(Rank(Sum(FYQU)),FYearQuarter)=3,FYearQuarter))
etc.
May be you can try something like this -
You actually don't even need to create the date. Check the updated one.
from what i can tell he is wanting to show "FYearQuater" in the text box, not "FYQU"