Before function and conditional formatting with Pivot

[viraj007]

Hi Experts

i have a pivot table. The columns are grouped as Year, Quarter and months. I have applied conditional formatting to apply color for the pivot cells, by comparing previous cell value (using Before() ). 
When the pivot is grouped, the conditional formating works good for 2nd and 3rd month in a quarter. For the 1st month in the quarter, no formatting is applied.

ideally i would like the formatting to apply while retaining grouping as well

will be great if you can guide.

[Chanty4u]

Try something below 

if(Quarter = Before(Quarter), 

    if(Month > Before(Month), lightgreen(), lightcoral()),

    if(Month > Before(Month) or (Month = 1 and Before(Month) = 12 and Year = Before(Year)), lightgreen(), lightcoral())

)