Hi Guys,
I have been looking for the answer everywhere and no one has answer to my question. Hopefully someone experienced the same problem!
I created a line chart with makers for YTD (on my x-axis), shows every month for YTD.
I got two lines: showing revenue in series (measure) and expense in series (also a measure).
Is it possible to add 3rd line that will be PARALLEL to other lines in the same chart and will show Prior YTD Revenue but the X-axis still will show current YTD?
I created total([Revenue} within set [Prior YTD]) and dragged into the series but that is not working!
Thank-you!
Nikki
use trick
add
lag([Selected Month],12) for last year
next periodsToDate([xxx].[All Time Periods].[All Time Periods].[Year],[Selected MonthLY]) for YTD Months - LY
in crostab second item add to column
and in rows add one more revenue
next hide cells in 1st revenue for current year
and hide cells in 2st revenue for last year
Look at adding the data item as a marker like a goal. Markers are just below the Y axis stuff on the chart.