
Re: 10 top values and sorting in pivot table
Prashanth Reddy Jul 25, 2016 7:51 AM (in response to Aleksandra Siwierska)Hi ,
1.For the first problem, will be having direct option to show both top and bottom values. Just click on Dimensions>Limitation
2.For the second problem, for the first dimension it will be correct and for the second dimension the sorting will be for the individual key fields of the first dimension.
Thank you

Re: 10 top values and sorting in pivot table
Ruben Marin Jul 25, 2016 8:06 AM (in response to Aleksandra Siwierska)Hi Aleksandra,
For the first one it can happen than two of the top in sales has a password<>'sheep', so they accomplishes the first 'If' but returns false on the 2nd', can you try with:
if(Aggr(rank(sum({<password={'sheep'}>} value)), human)<=12, human)
For the 2nd note that is sorted by dimension, so it first sorts the first dimension, if you expand the 2nd dimension, the sort of the first dimension is kept, ie:
Dim1 Dim2 Expr1 (SUM) A Z 4 A Y 1 B X 3 It's sorted correctly, 'A' its higher than 'B', then it's sorted by the 2nd dimension, if you want to mix values of the first dimension (Showing 'A', 'B', 'A') you may change to straight table.