Calculated Field

[#1]

Hi

I want to create a calculated field [Count] in a pivot table depending on the value or the backgroundcolor of a numeric field.

Thanks in advance

Marc

[#2]

Can you attach the sample

[#3]

Hi.. Try This hope it will help

[qlikoqlik]

Hi

I think you can use the set analysis for the value

sum({<[Prog Amount]={'>200'}>}[Prog Amount])

thanks and regards

Padma