Hello everyone,
I want to sort below month'Year in asending order.
I am not able to sort. please help on this.
Used already-Created monthNo & sorted on and got result correct for only year but not for more than 1 year as it has more than 1 year like in above view .
I don't have to plot year above month row in view.
Thanks
Shiv
Hello @shankarshiva70 ,
Create MonthYearInteger column
MonthYearInteger =
Hi Tarun,
Thanks for reply
I have done this by this way
Created one column
Hi Tarun,
I have done this using @amitchandak post. but thanks for reply you r also corect
@shankarshiva70
You need to create the sort column including the year, modify monthno column as follows, and sort by that:
YearMonth = YEAR(Dates[Date]) * 100 + MONTH(Dates[Date])
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
Thanks for reply
I have done this by this way
Created one column
User | Count |
---|---|
49 | |
43 | |
26 | |
11 | |
10 |
User | Count |
---|---|
41 | |
37 | |
28 | |
11 | |
10 |