Count value based on Condition in front end

[#1]

Hi All,

I have 4 Fields like Cust Id,Sale,Target,Month

then i calculated the percentage of (sale/target)*100 for each month

Now i need the Cust Id's with count of months those are having Percentage more than 60%.

output like:

Custid	>60
C01	8
C02	9
C03	10
C04	7
C05	4
C06	8
C07	10
C08	7
C09	7
C10	5

sample Data:

[sundarakumar]

PFA the application with the requirement completed on the attached sample. (Straight table as mentioned)

Thanks

Sundar

[maxgro · Accepted solution]

in a straight table chart with custid as dim use the expression

count(distinct

if(aggr(sum(Sale)/sum(Target), Month,Custid)>0.6,Month)

)