dimension
HI,
I created 5 measures and put them together to act like a series of bar charts.
Each of them is consisted of 2 segements, A and B.
At the same time, I would like to create a new dimension and put it on Colour to visulise the segments and make the bar charts to be stacked bar charts.
Here is the code I wrote and I found that the logic does not seem right.
The reason I suspected is in the excel dataset, the data set is like this and the first if statement in the code will dominate the following 4.
| ID | Status 2011 | Status 2012 | Status 2013 | Status 2014 | Status 2015 |
|---|---|---|---|---|---|
| 1 | A | B | A | A | B |
| 2 | A | A | B | B | B |
| 3 | A | B | A | A | B |
| 4 | B | B | B | B | A |
| 5 | B | A | B | B | B |
| 6 | B | A | A | A | B |
Code of the dimension:
IF [Status 2011] = "A" then "A" ELSEIF [Status 2011] = "B" then "B"
ELSEIF [Status 2012] = "A" then "A" ELSEIF [Status 2012] = "B" then "B"
ELSEIF [Status 2013] = "A" then "A" ELSEIF [Status 2013] = "B" then "B"
ELSEIF [Status 2014] = "A" then "A" ELSEIF [Status 2014] = "B" then "B"
ELSEIF [Status 2015] = "A" then "A" ELSEIF [Status 2015] = "B" then "B"
END
Would you please let me know how I can modify the code or the dataset?
Thanks.
Oct 9, 2015 2:53 AM
