Expression

[#1]

hi,

I am using pivot table. in image column if count of green arrow is greater than 2 is shoul show green in status and if count of red is greater than 2 it should show red. how to apply expression in status column.

[#2]

Hi,

I am sending image for clarification.

[rustyfishbones]

you are missing the braces around green

it should be {'Green'}

[#4]

Hi,

After using Braces it is showing error at first braces.

Regards,

Piyush

[CELAMBARASAN]

Please change you expression to

If(Count(Total<Week123> {<Trend={'Green'}>} Dt) >= 2, 'Green')

[rajni_batra]

can u display that error screen?

[CELAMBARASAN]

Hi,

It looks like Trend is not a Field Name its a Expression?

Could you please tell me what expression you are using?

[#8]

Hi Celam,

Ya Trend is calculated dimention.

regards,

piyush

[CELAMBARASAN]

Could you post that expression?

[#10]

hi,

If(status1='Red',R

if(status1='Green,'G'

if(status1='Amber','A')))

this is calculated dimension.

Regards,

Piyush

[#11]

Hi,

Its there on same page above.

Regards,

Piyush jain