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

vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

what is your measure calculation?

sudhakar111's avatar
sudhakar111
Helper IV
9 years ago

It is Difference % = Budget-Actual/Budget

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

    Hi sudhakar111,

     

    Could you post your table structures(including the measures) with some sample data which can reproduce the issue, so that we can better assist on it? It's better to share a sample pbix file. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. :smileyhappy:

     

    Regards