Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Community,
I have a question on displaying Fiscal Years and Months. My aim is to be able to display Volumes floating over Fiscal Years (Fiscal Year starts in Oct). So out of the data I want to be able to select e.g. Aug FY 2017 to Dec FY 2018.
Thank you very much in advance!
Fiscal Year | Month |
2017 | Oct |
2017 | Nov |
2017 | Dec |
2017 | Jan |
2017 | Feb |
2017 | Mar |
2017 | Apr |
2017 | May |
2017 | Jun |
2017 | Jul |
2017 | Aug |
2017 | Sep |
2018 | Oct |
2018 | Nov |
2018 | Dec |
Solved it myself
Added a mapping table which dims Months as Periods.
Then used ="Fiscal Year (FY)"&'/'&Period in the Data Dimension Field.