Pivot table operation - color code ----- > (SOS)

[#1]

Hi,

I need to color the concepts in green which have green background for two consecutive columns (Ex: Headlamps)

and need to color the concepts in red which have red color font for two consecutive columns. (Ex: shutter speed, disk partitioning)

IF(Previous(Concept)=Concept, 'NO', 'YES') as NewConcept

This is how a new concept is defined.

Basically I want to study/identify which concepts have sustained over time/ which concepts have died out based on the difference in the counts of those counts.

The data is historic - period 1990

(quarterly data)

I have attached the pivot table, the dimensions, the expression used and the visual cues used.

Thanks in advance!