help in expression

[ali_hijazi]

Hello

please check attached file

I have a pivot table with Dimensions MonthYear and TPK (test package)

the first expression is a variable that shows a ration; this value is correct

Look at 2013-08 I got two TPKs PAR.TPK.0000347|SDKDISTRIBUTION and got a ratio of 0.75

and PAR.TPK.0001928|DEFAULT and got a ratio of 0.25

the second expression I'm trying to show the TPKs that got a ratio > 0.5

if you click on 2013-08 then sure only the first TPK appears whereas if nothing selected both TPKs appear in 2013-08

so please help here (check the expression)

what I actually want is to count the TPKs by MonthYear that got the ratio that is >0.5 so for 2013-08 that count should be 1

Have a look at the attached document and please help (the chart that you have to look at is the pivot table at the bottom of the sheet)

Regards,

Message was edited by: Ali Hijazi

[rohit214 · Accepted solution]

hi,

use below set in 2nd expression

Aggr(If($(vWasteRatioRelativeThreshold)>0.5,TPK),MonthYear,TPK)

hope it helps u

Regards

Rohit