Skip to Content

SAP Analytics Cloud – how can you display the dimension members in a specific order in charts (remote models)

When you develop SAP Analytics Cloud dashboards, one of the common need (especially for financial people) is to display the dimension members in specific order. The most common example is the months which need to be displayed in a chronological order.
I will explain in this blog step-by-step how you can achieve this in SAP Analytics Cloud using live data connection (HANA or BW).
Let’s suppose you have the data in this format:

If financial people want to report Sales by Month,they are expecting to see the months in a chronological order , but in SAC(by default) will be displayed like this:

How you can solve this issue?

You have to add an additional column in your table where you define the correct order like this:

In SAC, now you can use the Advance sorting option:

Select the column you used to define the order and the way how you want to order:

Click OK.

Now the chart will display the months in the correct order (you defined).

Thanks for reading!

2 Comments
You must be Logged on to comment or reply to a post.
  • Nice blog, Thanks.

    In my data contains Fiscal Month/Year now how to apply custom sorting in Table,

    Our data as like below,

    Jan-18
    Feb-18
    Mar-18
    Apr-18
    May-18
    Jun-18
    Jul-18
    Aug-18
    Sep-18
    Oct-18
    Nov-18
    Dec-18
    Jan-19
    Feb-19
    Mar-19
    Apr-19
    May-19
    Jun-19
    Jul-19
    Aug-19
    Sep-19
    Oct-19
    Nov-19
     

    please help in the scenario.

    Back end connection: Live connection SAP BW

    Thanks,

    Chandrasekhar