Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi QV Guys,
is there any possible ways to use a set analysis in dimension?
Regards
Hemanth
Hi Hemanth,
Yes,
example,
=aggr(rank(sum({<StoreName=,MaterialHuddleGrpDesc={'SLG'}>} SoldQty)),ArticleNo)
share your requirement/ sample app then it's easy us to help you. tks
Hi Hemanth,
In general you have to use Aggr() function ,something like below:
=Aggr( Only({<Plant=,ID=>} ID), ID)
But would be great if you can share your requirement.
Thanks,
AS
Hi Hemanth,
Yes you can use set analysis in dimension as add calculated dimension with aggregate (aggr()) function.
Thanks,
Pooja
Hi Deva,
i think u said to in expression.
i need a requirement that is i need to use a set analysis in calculated dimension which would apper as dimension
Hi Hemanth,
Please refer the sample app (refer last sunny reply with calculatd dimension)
Thanks, deva
Hi Hermanth
Please see attached example. (Just a quick one)
If we know your exact requirement we can assist you better.
Kind Regards
Hi,
I have a similar requirement, and I tried writing an expression analogous to your solution:
aggr(Only({<Month=,Month_date=,[Media Coverage]={'Yes'}>}[Description of the Incident]),[Description of the Incident])
but the data still changes with the month filter. Any suggestions on how to make Month inactive here?