MAX COUNT

[PARK_JY]

Hi,

LINE	TOTAL COUNT	OVER COUNT	OVER COUNT RATIO
A	800	190	23.8%
	741	236	31.8%
	726	224	30.9%
	731	261	35.7%
	723	217	30.0%
	716	22	3.1%

I want to add the "MAX COUNT CHECK" item to the above table.

LINE	TOTAL COUNT	OVER COUNT	OVER COUNT RATIO	MAX COUNT CHECK
A	800	190	23.8%
	741	236	31.8%
	726	224	30.9%
	731	261	35.7%	V
	723	217	30.0%
	716	22	3.1%

This is the table I want.

So i wrote this but it didn't work.

=if(LINE='A' AND MAX(COUNT(OVER COUNT)/COUNT(TOTAL COUNT)), V,  NULL()) as MAX COUNT CHECK

Please let me know how to solve it.

Thank you.

[Mark_Little]

Hi 

You will need to look at the AGGR Function. What is the Dimensional split of that table? then you will want something like this

IF ( MAX(AGGR(COUNT(OVER COUNT)/COUNT(TOTAL COUNT)),Dimension) = COUNT(OVER COUNT)/COUNT(TOTAL COUNT), 'V')