Sorting only child items in grid based on line item values.

kevinsanghoi · 2024-01-17T06:13:21+00:00

There was an error rendering this rich post.

I am using the the sort functionality to sort the list items in the grid but the Parent of the child item is being placed as per the sorting. I want the sort to apply only on the child items and the parent item to be displayed on the bottom. In the below screenshot Oscar Ramos RVP must be in the bottom of the grid and not top.

Accepted answers

kevinsanghoi

The 4 digit number items you see in the bottom as children of Oscar Ramos RVP.

The hierarchy is somewhat like this :

L1: Fernando Masini

L2: The items ending with 'RVP Region'

L3: The items ending with 'RVP'

L4: The items having 4 digit numbers.

The end result that I want is the order of Composite Lists remain as it as but the Child List (L4) be sorted as per the conditions. L4 (Sorted) followed by L3, L2, L1.

nvilkko

Thanks. I find it weird that I cannot mimic the issue. However, I would try these:

Recreate the grid in the UX, only apply the sorting and make sure that you don't apply any other settings (Show / Hide, Filter etc.)
Try creating a separate line item for sorting. Something like this: RANK(Relative Variance, DESCENDING, SEQUENTIAL, TRUE, Parent)

kevinsanghoi

Thanks. The first solution by recreating the grid didn't work so as you suggested the workaround using RANK function worked.

All comments

nvilkko

Hi @kevinsanghoi,

Could you post a screenshot of the line item you are using for sorting?

Thanks,

Niko

kevinsanghoi

I use this line item for sorting. In the above screenshot the Relative Variance for Oscar Ramos RVP is -1.2m hence it's place at the top but I want to Parent to be always in the bottom

nvilkko

For some reason, I can't mimic the issue.

Based on my understanding, you have a list hierarchy where Oscar Ramos RVP is a parent and 7298, 7246 etc. are children in the hierarchy. Is this correct?
Have you amended the totals position? (Image)

kevinsanghoi

Yes I did that but there are multiple levels to the list hierarchy so if I group them at end it doesn't work when I select a higher level on the context selector.

nvilkko

What if you select 'After'?

kevinsanghoi

The grouping is select as After and for reference I have selected a higher level in the hierarchy. The list items without a 4 digit number in the start belong to 3 different lists. All belonging to the same hierarchy at different level. As seen above the sorting didn't help with them being located in the middle

nvilkko

I am not 100% sure what is the wanted end result. If you don't want the parents after the children, could you please explain why isn't 'Group at the end' working? Or are the 4 digit number items in the bottom also children of Oscar Ramos RVP?

kevinsanghoi

The 4 digit number items you see in the bottom as children of Oscar Ramos RVP.

The hierarchy is somewhat like this :

L1: Fernando Masini

L2: The items ending with 'RVP Region'

L3: The items ending with 'RVP'

L4: The items having 4 digit numbers.

The end result that I want is the order of Composite Lists remain as it as but the Child List (L4) be sorted as per the conditions. L4 (Sorted) followed by L3, L2, L1.

nvilkko

Thanks. I find it weird that I cannot mimic the issue. However, I would try these:

Recreate the grid in the UX, only apply the sorting and make sure that you don't apply any other settings (Show / Hide, Filter etc.)
Try creating a separate line item for sorting. Something like this: RANK(Relative Variance, DESCENDING, SEQUENTIAL, TRUE, Parent)

kevinsanghoi

Thanks. The first solution by recreating the grid didn't work so as you suggested the workaround using RANK function worked.

Quick Links

Can you help?

Unanswered questions

Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…