Passing expression in aggr

[smilingjohn]

Hi All,

Basically I am trying to show a column in pivot table with color indication as 'G' and 'R' to do so I am using below calculated formula  . and this formula works good for me .

 Aggr(If(PTG=PT,'G','R'),Product)

But I am stuck in including a expression  within the above calculated logic   .   Count({<sev-={'5'}>}ID) 

I am attaching my file if you look at the color table it shows 'R' actually it should 'G'  . 

Thanks

Thanks in Advance

[smilingjohn]

Hi Expertise any help on my above post 

Thanks 

[smilingjohn]

Hi All,

I tried everything that I can but this is not helping 

Waiting for some suggestions from any one 

[smilingjohn]

Still waiting for some luck.....

[smilingjohn]

No Luck for me .....