Hello, I have a chart, where i want to display months on the x-axis and years on the y-axis.
I have a cube that has All Dates Dimension that consists of All Dates Hierarchy that has levels: Year, Quarter, Month & Week.
How can I use these items to create a chart which displays Months Jan, Feb...Dec and plots a line for each year?
I have attached a sample output of what is expected.
Thanks in advance