Row wise comparison in Pivot table

[rkspareek1992]

Hi,

I have three tables A, B & C. In tables A, B & C I have Total target, MTD target and Actual data respectively. I have concatenated all three tables to show the data in below-mentioned form.

MTD Production	Location	Totals	Plant1	Plant2	Plant3
Month Target (A)		3,236	2,259	620	357
MTD Target (B)		939	656	180	104
Total Actual (C)		1,096	619	304	174

Expression of A, B & C is Sum(Total target), Sum(MTD Target) and Sum(Actual) respectively.

Now I want to compare B and C, if Sum(Actual) <Sum(MTD Target), Red, Green.

and output should be like as:

MTD Production	Location	Totals	Plant1	Plant2	Plant3
Month Target (A)		3,236	2,259	620	357
MTD Target (B)		939	656	180	104
Total Actual (C)		1,096	619	304	174

Kindly suggest the expression for color.

[karthikoffi27se]

Hi Rakesh,

Under the expression you have color by text (Text Color). Use the expression if (Sum(Actual) <Sum(MTD Target), Red(), Green()).

This should work

Many Thanks

Karthik.

[rkspareek1992]

I have tried, but its only working for Totals, not for all plants (which are used as columns).

I have also tried as:

if(Sum(<Total Plant>Actual) <Sum(<Total Plant>MTD Target), Red(), Green())