how to get previous Quarter

[#1]

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

[#2]

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.