Fiscal Year to Month: Display months floating over Years

[philipp_meissne]

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

[philipp_meissne]

Solved it myself

Added a mapping table which dims Months as Periods.

Then used ="Fiscal Year (FY)"&'/'&Period in the Data Dimension Field.