Forum Discussion
Problem with Cumulative percentage
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
Thanks a lot v-ljerr-msft, it worked perfectly.
i posted one other issue on the same sample data.
The cross tab has year and month.If it is all numeric it works fine.
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.
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
Thank you so much v-ljerr-msft, it works perfectly. The mistake i made was trying to sort on the same column.