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