Help with Set analysis expression

Thu, 20 Nov 2014 19:03:37 GMT

Hi Guys,

I have the following table:

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?

Re: Help with Set analysis expression

MK_QSL — Thu, 20 Nov 2014 19:44:56 GMT

You can simple use

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