displaying the months on a graph by fiscal year not calendar year

  • Thread starter Thread starter SMT
  • Start date Start date
S

SMT

I have a query in which I have included the tblmonth, which has a number and
its corresponding month according to fiscal year...i.e.,
Month, MonthID
October, 1
Novemer, 2
December, 3 and so on.

I am creating chart off of this query and need the chart to show display the
actual month but sort it in the order of MonthID. For example my graph has
the months listed at the bottom but they go in alpha order versus fiscal year
order which is what I need. How can I correct this so the graph will display
the appropriate month in its appropriate order?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fiscal Year Query 1
Fiscal year 2
Fiscal year (another try) 6
Extracting Month and Year For a Given Date 3
select dates for last fiscal year 3
Cross tab for a fiscal year starting in Oct 3
Group by fiscal months 5
YTD for the fiscal year 5

Back
Top