Using visual cues in pivot table

[#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)

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

Thanks in advance!

[#2]

(Sum(Count_Concepts))-(Before(Sum(Count_Concepts)))

This is the expression for those values. (operation based on pivot table columns)

For more clarity u can have a look at the screenshot that I posted in the beginning. It has the dimensions, expression used.

[saumyashah90]

make two variables

vCurMonth= Date(Today(),'MMM-YYYY')

vPrevMonth=Month(Addmonths(Today(),-1))&'-'&Date(Today(),'YYYY')

[#4]

Dosth,

All this is historical data. Curmonth , previous month ka kuch upyog nahi.

How to get the last month of the data and the last previous month of the data ??

[#5]

FYI

And also it is not monthly data.

It is quarterly data