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 tried below logic but this doesn't work it is not considering the the set analysis or may be I am failing somewhere
Aggr(if(PGT=PT and count({<sev-={'5'}>}ID)>0,'G','R'),Product)
