Data sort

Highlighted
Contributor

Data sort

Hi, 

I am trying to sort the data for hierarchy and it works fine if I select the immediate parent in the page selector. When I select the total company level the sorting does looks like in the hierarchical order( sorting the siblings of parent and maintaining hierarchy)but coming in the sort order with different order. Can anyone pls help with options. 

 

Thanks, 

Nisha. S

 

1 REPLY 1
Highlighted
Regular Contributor

Re: Data sort

Hi @NishaS 

Assuming your data is Sales history.

1. Rank the sales history data sequentially. The formula for line item, Rank sales history would be RANK(Sales History, DESCENDING, SEQUENTIAL)

2. Cumulate the above rank sales history in another line item. Formula: RANKCUMULATE(Total Sales History, Rank Sales History, ASCENDING) 

3. Use the lineitem to sort.

 

Edit Rank and Rankcumulate formula based on you requirements.

For more details on these functions:  https://help.anaplan.com/en/4f94f2e7-e7d9-4bae-ba6f-2b872e8d9189

 

Hope this helps

~Abhi