Need to highlight cells in Pivot Table (set analysis)

[#1]

Hi,

I need help with set analysis for my pivot table, please. 

I have Effective Months = EFF_YYYYMM   which is a dimension in pivot table above

ARCHIVE_DATE is also dimension in Pivot table

SUM(Bin_Distribution) is an expression with calculated numbers

I need to create set analysis inside "Visual Cues" for Bin Distribution

where number for Bin Distribution is compared to previous ARCHIVE_DATE (within the same EFF_YYYYMM) and it highlights if this number is less than original in yellow/red.

I enclosed excel file with some snapshots.

I appreciate your help very much.

[#2]

Dear Gennady,

You had better to introduced a conditional expression in the "Visual Cues" which will identifies the "True"  or "False" of the condition. Then you can set the color accordingly. 

Regards,

Priyantha.

[#3]

Dear Priyantha,

Thank you.

This is exactly what I am asking - I need to write set analysis formula into "Visual Cues", but not sure how to do it....