Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
Hi,
I tried, didn't work.
Yes, its a calculated dimension.
Hi, then I have to join Sunny in the request of a sample.
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