I have the following display requirement: - I have a diagram which is supposed to show YOY changes (2015 vs. 2014) in four different categories => So I have two dimensions, right? - >Category< and - >Year< So far, that is fine.
I already have another chart which shows the total of these four categories for the two years => There is only one category >Year< here => In addition to the two columns, I show a line representing the positive change - a line going down horizontally from 2014 to 2015.
=> Now I would like to show the same line (from 2014 to 2015) in the other chart, but of course for every category indiidually => there should be four individual lines.
By fixing the >category< dimension in a set_analysis, I can have four individual lines, but those are not horizontal, but rather vertical.
So there should be one line for every value in the >category< dimension and it should respect the <Year< dimension - I guess I need the TOTAL qualifier for that to disregard one of the two dimensions, but how to do it?
not quite since I don't have my desired result chart anywhere.
I will attach a screenshot of the chart I currently have - there are two dimensions as you can see. I have used a painting tool to roughly sketch the lines I want - not one continuous line, but four, each one diagonal.