Chart expression that returns the fieldB value of record with the MaxString(fieldA)?

[#1]

Hi

I'm on qv 9 and I need help with defining the expresssion for a straight table chart.

Sample Data

recId	category	attribute1	fieldA	fieldB
1	A	Y	AAA	YYY
2	A	Y	ZZZ	BBB
3	A	Y	CCC	WWW
4	A	Y	EEE	FFF
5	A	N	GGG	HHH

Desired Output

Cateogry	attribute1	maxString(fieldA)	fieldB value on maxString(fieldA) row
A	Y	ZZZ	BBB
A	N	GGG	HHH

cateogry and attribute1 are dimensions and maxString(fieldA), fieldB value opf maxString(fieldA) row are expressions.

Thanks

Tony

[#2 · Accepted solution]

Hi,

Pls. see the attached file, I hope it helps.

Best regards,

http://quickdevtips.blogspot.com/