Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Upali,
Try this
if(SUM({<Month={'Mar'}>} NOs) > (SUM(Total NOs)/3), lightRed(),black())
Regards
Kamiel
Thanks Kamiel
It is not working
Would you provide sample and expected result for your data set
Hi,
would you be able to share a sample?
Regards
Kamiel