Skip to Content
Former Member
Sep 23, 2011 at 01:27 AM

In Chart Month order not working when i use Ranking, Wt is Solution?


Hi Guys,

I am trying to do chart Expenditure by Month (each Year) with Departments.

I want to know how much top 20 departments (out of 50) are spending every month.

If i am using Ranking the month is not in order it is showing like Disorder(lAUG,Jun,SEP, DEC, JAN..etc)

If i am not using Ranking function it is showing in proper order like jan,feb,mar etc. But the chart is not looking good because all the 50 departments coming into my chart which i don't want.

I did custom sort.

What may be the solution.

Thanks in Advance