Forum Discussion

sudhakar111's avatar
sudhakar111
Helper IV
9 years ago
Solved

Problem with Cumulative percentage

Hi All,   I am facing an issue with the cumulative percentage totals. The table being used is Matrix preview.     I have 3 levels in my report like a hierarchy. The measure fields used are...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi sudhakar111,

    But i need to show it as 2016-Apr,2016-May and so on in that order.

     

    It is only showing in alphabetical order like 2016-Apr,2016-Aug and so on.

    You should be able to follow steps below to get this work. :smileyhappy:

     

    1. Select "Year Month" column.

    2. Click Sort by Column under Modeling tab.

    3. Select "Month Year"

     

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi sudhakar111,

But i need to show it as 2016-Apr,2016-May and so on in that order.

 

It is only showing in alphabetical order like 2016-Apr,2016-Aug and so on.

You should be able to follow steps below to get this work. :smileyhappy:

 

1. Select "Year Month" column.

2. Click Sort by Column under Modeling tab.

3. Select "Month Year"

 

 

Regards

sudhakar111's avatar
sudhakar111
Helper IV
9 years ago

Thank you so much v-ljerr-msft, it works perfectly. The mistake i made was trying to sort on the same column.