3 Replies Latest reply on Jul 6, 2016 4:28 AM by Shinichiro Murakami

# Difference between two columns for multiple Measures

Hi Everyone ,

Hope you all are doing great.

I am facing some difficulty in creating one report here

As per my attached screen shot-

TY,LY,

MTD, MTD LY,

QTD,QTD LY,

YTD, YTD LY     -  all are coming from one dimension.

and i have many measures as well, like delivered,Uniqueopen etc.

what my requirement is - need to add calculations between the values of dimension

like

TY, LY, TY / LY

MTD, MTD LY , MTD / MTD LY

QTD,QTD LY, , QTD / QTD LY

YTD, YTD LY  , YTD / YTD LY.

as attached in another screen shot (prototype ).

Thanks

Bhumin Shah.

• ###### 1. Re: Difference between two columns for multiple Measures

I don't know any other way than using Dashboard with combining four different calculated fields and existing four..

Thanks,

Shin

[TY / LY]

sum(if [Measure Type]="TY" then [Value] end) / sum(if [Measure Type]="LY" then [Value] end)

[QTD / QTD LY]

sum(if [Measure Type]="QTD" then [Value] end) / sum(if [Measure Type]="QTD LY" then [Value] end)

[MTD / MTD LY]

sum(if [Measure Type]="MTD" then [Value] end) / sum(if [Measure Type]="MTD LY" then [Value] end)

[YTD / YTD LY]

sum(if [Measure Type]="YTD" then [Value] end) / sum(if [Measure Type]="YTD LY" then [Value] end)

Thanks,

Shin

9.0 attached.

• ###### 2. Re: Difference between two columns for multiple Measures

Hey

Shinichiro Murakami

Thanks a lot , much appreciated , its working fine for me.

Regards

Bhumin Shah.

• ###### 3. Re: Difference between two columns for multiple Measures

Sounds good!

Shin