Good afternoon,
I have a structure which has two breaks, then I add the percentual value for a specific value field. What I would like to do, is to sort not just based on the value field - which it does via sort function - but also sort the members of the second break based on the footer's percentual value.
Fact is, I don't really need it to sort based on the value, but rather on its sub-total only. Sorting the value within each break is convenient, but not critical.
How can I achieve this?
-
Former Member Jyothirmayee A
I tried it, both yours and the version on the link, can't seem to get it working.
I even aded a cumulative sum column, and applied the ranking to it with two breaks, nothing seems to work.
-
Former Member Former Member
Solved the issue by: computing the 2nd-order break total percentage on each cell. Removed all breaks. Sorted by the mentioned field. Then re-added all the breaks.
-
Glad it worked!!! :)
Thanks,
Jothi
Add comment