Sort List for Page Selector

Hi team,

Is there a way that I can display a list in the Page selector based on the sorted order from another module? I have a Customer List that I am using as a Page Selector in 1 module and wish the List to be sorted from Highest to lowest revenue gap (it's a query to a employee) which I have created in another module

Thanks!!

Mark

Accepted answers

All comments

kavinkumar

HI @MarkTurkenburg,

We don't have such options but you can try similar workaround.

Step 1: Bring in the Revenue gap value into your destination module dimension by 'Customer List'.

Step 2: Pivot the module to have the Customer list in rows then apply Sort based on Revenue gap.

Step 3: After applying sort, pivot the Customer list back to page selector and publish the gird to dashboard.Hence in this way you can probably sort items in page selectors.

I hope this helps!
Regards,
Kavin.

MarkTurkenburg_*8288

Hi Kavin,

I tried this but when you pivot the dimensions to put the Customer List in Pages it resorts the Customer list back to the original format (see warning that Anaplan provides below)

Have I not understood your solution?

Thanks

Mark

kavinkumar

HI @MarkTurkenburg,

Ignore the pop up warning message. You will still be able to see the sort applied on the list items when you do the pivot to page selectors. Sample screenshots attached.

Publish the same grid to the dashboard! I hope this helps.

Regards,

Kavin.

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…