need code from Value>=Min and Value <=Max

[Sxbbb]

I want to create a table like this

Where 'With in spec' comes from Value>=Min and Value <=Max.

Example 1 work order

I can do it but then the Data  is wrong.

used code of  'With in spec'.

(Count(Aggr(if(Value>=Min and Value <= Max,Count(WorkOrder),0),Line,WorkOrder,SampleNo,Point))).

[#2]

I want to create a table like this

Where 'With in spec' comes from Value>=Min and Value <=Max.

Example 1 work order

I can do it but then the Data  is wrong.

used code of  'With in spec'.

(Count(Aggr(if(Value>=Min and Value <= Max,Count(WorkOrder),0),Line,WorkOrder,SampleNo,Point))).

[#3]

I want to create a table like this

Where 'With in spec' comes from Value>=Min and Value <=Max.

Example 1 work order

I can do it but then the Data  is wrong.

used code of  'With in spec'.

(Count(Aggr(if(Value>=Min and Value <= Max,Count(WorkOrder),0),Line,WorkOrder,SampleNo,Point))).