Divide crosstab fact cell with an integer

[ankurmittal]

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?

[blom0344]

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