Hi,
I have a requirement wherein I have to divide crosstab fact cells of different columns with different numbers.
For example: Say a crosstab with row as R1 & columns as C1,C2,C3 with default measure M; now I want to display crosstab as folows:
--> intersection[R1,C1] as (M/n1)
--> intersection[R1,C2] as (M/n2)
--> intersection[R1,C3] as (M/n3)
Is it possible to achieve?
It is simply a matter of replacing the dataitem containing M with a CASE:
CASE
WHEN [COLITEM] = 'C1' THEN M/n1
WHEN [COLITEM] = 'C2' THEN M/n2
WHEN [COLITEM] = 'C3' THEN M/n3
ELSE 0
END