2 Replies Latest reply on Jun 23, 2016 7:41 AM by Orlando Suarez

# Need Calculation that sorts in alphabetical order to tie into Parameter control

Could use a little help here folks. First let me explain what I've done so far:

I created a parameter control called "Sort By" that allows a user to sort columns uniformly for car models by:

% of Total

M/M %

Y/Y %

Seg. Rank

To power that parameter I created a calculation in Measures called "Sort % and rank" with a CASE / WHEN statement that references the [individual calculations] for each column. This "Sort % and rank" Measure Pill was placed on the Columns shelf.

I then created the "Sort By" Parameter control in the following manner:

NOW I want to add a 5th option to the "Sort by" parameter. This NEW FIFTH option is "Model". I want this to place the all car models in Alphabetical order in the column and I want this "Model" column to be the default setting for all sorting. So everytime a user opens the dashboard; the dashboard is always defaulting first to the alphabetized "Model" column.

So as you can see in the "Sort by" parameter control picture above, I added a 5th line and placed "Model" under "Display as". However the parameter is going to need to go back to the "Sort % and rank" calculation and reference the CASE/WHEN statement for a 5th line there. Here is where I need the help. What calculation can I create that will alphabetize the "Model" dimension so in turn I can throw that calculation into the CASE/WHEN statement inside of the "Sort% and rank" calculation that powers the parameter????

Below is a larger view of everything together:

THANKS!!!

• ###### 1. Re: Need Calculation that sorts in alphabetical order to tie into Parameter control

Ascii([Model]) will give you an integer value for the first character of each model

You can use this to sort or use multiple ascii formulas to get values for first second and third characters and sort accordingly.

• ###### 2. Re: Need Calculation that sorts in alphabetical order to tie into Parameter control

Thanks for the response Khalid! I will try this out and let you know how it works for me. Thanks again!