Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have one list box and have sorting expression then i will get top 10 values from there.
but issue is when i going selection one value all other values become hide.
the below screenshot is list box having top 10 divi
and this is after selecting any one i am getting below values all values get hide.
Thanks
Hi swuehl,
Below expression also works
=aggr(if(rank(sum({1}Amount),4)<=10, only({1}Division)),Division)
It technically works, but semantically it's different, it will show always the top 10 customers disregarding any selections, like on time dimensions, product dimensions etc.
Using
=aggr(if(rank(sum({<Division>}Amount),4)<=10, only({<Division>}Division)),Division)
is hence closer to the original list box, just showing all Division values even when there is a selection in that field.
Hi,
There is a Front End work around by:
create a Straight table with
1.1. Dimension = Division
1.2 check show all values
1.3 in division background colour make the expression:
=if(sum({1<Division = p(Division)>}Amount)>1,$(ActiveColour),$(InactiveColour))
2. In Expressions Tab
2.1 Make Expression:
=sum({<Division=>}Amount)
3. in Presentations Tab
3.1 Select the expression
3.2 click on Hide Column Radio button
4. In the Dimension Limits Tab
4.1 check restrict values which are shown
4.2 select show largest 10 values
4.3 deselect show others
This will now allow you to have list of the top 10 divisions based on Amount which will change based on any selection and will allow you to choose a division to view the rest of the data with the chosen division. it will not auto hide the unselected divisions.
Hope this helped
Gareth