If condtion in Set analysis KPI

[kunkumnaveen]

Hello All,

i have to apply two filters in my set analysis  and need to show the value in KPI,

1)NOD<15

2)Sum(M_Count)<10

In the below Straight table

Dimensions:

Stock,Model,Material,Vendor, Nod

Expression :

Sum(M_Count)

so i need to show count of distinct vendor whose NOD<15 and Sum(M_Count)<10,

So in KPi i need to count of vendors as :3

Kindly suggestion me how to write a expression with two filters in KPI

[kunkumnaveen]

I tried below exp in KPI

count({<NOD={"<20"},Stock={'Vendor'},M_Count={'=sum(M_Count)<10'}>}distinct total <Stock,model,Material>vendor)

But its not working.

[kunkumnaveen]

Any Suggestion on my above requirement plz

[alex00321]

I'm not sure if you could use M_Count={'=sum(M_Count)<10'} in your expression. Maybe you could share sample data? 

[kunkumnaveen · Accepted solution]

I have sorted this by creating a Flag at scripting