Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
dinicholls
Creator II
Creator II

Aggr Argh!!!!

Hi All,

I have the following calculated dimension:

=if(Aggr(Rank(sum({<[Group No] -= { 'GR-000000','GR-A0000' }>}[>60days])),[Group No])<=15,[Group No],Null())

I need to add in the following:

ME={'ME1610'}

I've tried this:

=if(Aggr(Rank(sum({<[Group No] -= { 'GR-000000','GR-A0000' },{$<ME={'ME1610'}>}[>60days])),[Group No])<=15,[Group No],Null())

But it just bring back rubbish. Where an I going wrong?

Thank you

Di

13 Replies
rubenmarin

Hi Diane, have you tried what I posted before?:

=Aggr(if(Rank(sum({<[Group No] -= { 'GR-000000','GR-A0000' }, [ME]={'ME1610'}>}[>60days]))<=15,[Group No]),[Group No])


I supose this is a calculated dimension, isn't it?

dinicholls
Creator II
Creator II
Author

Hi,

I tried, didn't work.

Yes, its a calculated dimension.

rubenmarin

Hi, then I have to join Sunny in the request of a sample.

dinicholls
Creator II
Creator II
Author

Hi All,

Thanks for trying to fix this, I actually so of 'fudged' it, and pulled the info I need via a resident load, pulling only data for ME = 'ME1610', and used the ranking formula, minus the ME bit.

Thanks for all your help!

If you ever come across something like this again, please tag me in it so I can have a look!!

Di