Help with Set analysis expression

[#1]

Hi Guys,

I have the following table:

Type	RCAT	Area	City	BUSINESS_DAY	AC_R.H
Input	ILO	ASIA	Delhi	BD1	2
Output	ILO	ASIA	Delhi	BD4	2
Output	PLO	UK	London	BD4	3
Output	PLO	UK	London	BD5	2
Input	ILO	UK	London	BD6	6

And the following formula used in my expression.

=

if(rank(aggr(sum(max({<Date={$(vRM)},

Category={'$(vCP)'}>}

AC_R.H)),

RCAT)=1),

AC_R.H)

My aim is to aggregate the values and be able to drill down by all the different fields.

So headline figure should be 15. When filtering on to PLO (RCAT) the figure should output 5 (but i get 3). Asia = 4 (but i get 2). etc etc.

Would appreciate the help?

[MK_QSL]

You can simple use

=SUM({<Date={$(vRM)},Category={'$(vCP)'}>}AC_R.H)