Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I used the following formula to get the quarter selected
= 'Q' & ceil(Month(max(MonthName))) / 3 &', '& Year((max(MonthName)))
so when i select a month it give me the quarter as Q4,1012
now if i want to get the previos quarter how can i do that. For the month its easy but for quarter no idea at all
PLEASSEEEEEEE HELPPP
Hi,
U have this('Q' & ceil(Month(max(MonthName))) / 3 &', '& Year((max(MonthName)))) as field ryt?
if yes U can use previous function to get previous Quarter like below
=previous(Quarter)
~Kabilan K.