Sorting with nested pivot

AndreyPol

Being an Anaplan builder, I would like to be able to perform sorting with nested pivot (wich means pivot with several dimensions in rows).

 

Currently, sorting can be done on in case of one dimension represented in rows. However, I would be great to have an ability to do the same with several dimensions (nested pivot) in rows. Despite workarounds, it would be a pleasure to have a direct functionality in Anaplan.

 

Benefit of the enhancement: preparing of more detailed and useful in terms of pivot reports.

Miran

Status changed to: In Review

swoods93

So much this! I'm currently trying to sort a module that has an L2 level list as a dimension, but it shows the L1 parent. I can sort the L2 items within each parent block, but I can't just sort the parent block. This is annoying because as we add more L1 parents, it'll just get harder and harder to understand the list. Doing this alphabetically would be great. This seems like it should be a simple thing. 

Nicolas Cadier

I would really like to see this feature as well!

The current restriction must have something to do with the way that list items are grouped, as this type of sorting could lead to instances where list items are not drawn in the same repeating order.

Even if that is the case, this is pretty basic functionality that I feel should be within the platform.

CommunityMember128196_*4465

Hi, Indeed, we need this feature. There are a few reports which look far from ideal because of the non-availability of this feature.

rodolfo_hr

This feature would be quite useful, as it greatly limits the reporting capabilities of the tool 

Philippe

HI

I agree with all already said, would be very useful.

Thank you

yrignac

Hi,

 

Sort functionality doesn't work on nested dimension module.

 

Maybe sort might be based on a line item (same as we have for filtering).

Like that we could choose priority of the dimension and so on.

 

Thank you.

 

Regards,

Yohan

wwood

Another vote for this functionality, this would be extremely useful

sprender

Status changed to: In Review

awestphal

+1 for sorting on nested dimensions. I am running into this issue based on a user request, and the suggested workaround of ordering the list dimensions by the desired sort amount is not suitable