Hello,
i have two questions:
A
i have crosstab in relational package -
1. element - scenario (contain - current value; plan value)
2 element - year (2014; 2015; 2016....)
how can I separate e.g. scenario/year in two various elments (current value; plan value) to calculate for example current - plan or 2015 - 2014
In dimensional package i work with MUN but how do it here in relational package?
B
how can i edit on specific element of my report result. E.g. City (London; Paris, Berlin, Rome etc..). It is possible bold, framework, Background one specific element... e.g city Paris for example?
and sorry for my bad english
thank
A - You can pit Current and Plan as separate measures in the columns. I presume you will have those two measures already built in the package. If not, you will have to find out what identifies Current and what identifies Plan and then split them into separate measures with a Case statement
B - You can define a conditional variable and use that for conditional formatting.