Register
Log In
Unanswered
Home
Dashboards
Excel
Word
Outlook
May 19, 2016
Offline
In New Zealand, the financial year usually ends in March so I need to produce graphs showing the months April through March but it displays them on a calendar year basis. How do I force it to show the financial year?
Sample workbook is attached.
See Answer
Dashboards
June 25, 2016
Offline
Hi Peter
You could try sorting your Pivot Table Row Labels by moving (dragging) April, May and June to the top.
Hope this helps.
Sunny
Dashboards
Excel
Word
Outlook
May 19, 2016
Offline
Thank you Sunny but when I try to use the Manual sort option I can't get it to work although I may well be doing it incorrectly. See attached.
Kind Regards
Peter
Dashboards
June 25, 2016
Offline
See my example
Dashboards
Excel
Word
Outlook
May 19, 2016
Offline
Thank you Sunny. After looking at what you have done I finally figured out that you need to right click on the month/s you need to move to activate the "move" menu.
Thanks for your help.
Peter
Answers Post
Dashboards
Power BI
Power Query
April 21, 2015
Offline
Other way is I think shown in the Dashboard course here by Mynda: make a helper column where you 'translate' the month to the period in the financial year it takes (so April becomes one I think). You can sort then that way.
Dashboards
Excel
Word
Outlook
May 19, 2016
Offline
Hi Frans. Are you able to tell me what session number that was because I'm having trouble getting the slicer to list the months in the order I want.
Regards Peter
Dashboards
Power BI
Power Query
April 21, 2015
Offline
I had to search, but here's a blogpost from our Mynda that I think exactly explains how to deal with your problems: https://www.myonlinetraininghub.com/excel-slicers-for-fiscal-years
Good luck!
Most Users Ever Online: 57
Currently Online: clark shao
14 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Md. Rahman
Lilian Vo
Jane Kumwenda
David Miller
Efe Onwochei
LynAnn Williams
Brandy Kriger
purna chandar
E K
velissa barr
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
