if, count, max..

[PARK_JY]

Product Name	Line Name	Quantity	Good Quality
BOLT	A	100	98
	B	95	92
	C	90	79
	D	90	86
	E	94	90
	F	95	90
	G	91	84

Quantity = if("Product Name"='Bolt' and "Line Name"='VALUE', Count("Product"))

Good Quality = if("Product Name"='Bolt' and "Line Name"='AVALUE, Count("Good Quality"))

Hi, 

I want to draw a graph based on the above data.

The conditions are as follows.

=If (PRODUCT NAME='BOLT' and MAX(COUNT(Good Quality)/COUNT(Quantity)),  "Line Name")

but, this function doesn't work...

Please let me know how to solve it.

Thank you.

[rubenmarin]

Hi, it's not clear what you want, how would be the final chart? It's a line/bar chart? a KPI?

When you do a count of quantity you really want a count or use a value stored in the Quantity field?