Forum Discussion
Problem with Running total vizualisation
I think your weeknumbers are across all the years and it is combining the data together for all the weeks from multiple years. if you add year and then week number and use drill down all level in hierarchary or create week number with year appended to it and then check.
Wah, that was quick!
Thank you so much, parry2k, adding the fiscal year did help in displaying the measure for the current fiscal year.
But my objective is to display lines for both current and previous fiscal year for comparison purposes.
Having the year added does not really allow me to do this as I would get something more like this:
Which is not ideal...
Aha, drop week number on x axis and year on legend. that will do it.
For some reason, I cannot drop Year on legend, it would not le me do it...
do you have more than one field in values? you have to have one field in values, can you send screen shot what kind of field you have on axis, value, legend?