Jump to content
  • 0

Manual Sort in Data Page - Pivot Table



2 answers to this question

Recommended Posts

  • 0

One way to do this is to create a lookup table to pull your size drop-down values from.  In the lookup table, make a 'label' and 'sortvalue' column and assign your values accordingly (xs = 0, s = 1, m = 2, etc).  When you're setting up the datapage field, you'll set the field type to a drop down and use your lookup table as the source.   You will be given options about what field do you want to determine the sort order - pick your sortvalue column from the lookup table then set your ascending/descending setting to your liking.

That should do it, let us know if that works.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...