Set Expression

[upaliwije]

I have in my QV Doc the following Pivot Table

	Nos	Nos	Nos
MONTH	Jan	Feb	Mar
NET_RANGE1	1	2	3
<=10000	3,048	2,900	3,433
10,001-25,000	3,426	3,186	3,313
25,001-50,000	2,218	1,940	2,389
50,001-500,000	1,723	1,422	2,030
Above 500,001	89	82	78
Total	10,504	9,530	11,243

I want to make Figures in March Column to be red if total of (Jan Feb Mar )/3 is less than Mar Figure. Accordingly I have written the following expression in text colour

=if(match(MONTH,'Mar') and SUM(NOs)>(SUM(NOs)/3), lightRed(),black())

But It does no not work . Pls help me

[kamielrajaram]

Hi Upali,

Try this

if(SUM({<Month={'Mar'}>} NOs) > (SUM(Total NOs)/3), lightRed(),black())

Regards

Kamiel

[upaliwije]

Thanks Kamiel

It is not working

[Anil_Babu_Samineni]

Would you provide sample and expected result for your data set

[kamielrajaram]

Hi,

would you be able to share a sample?

Regards

Kamiel