Difference between two columns (only for last 2 columns) in cross table

[Minaxi Patel]

Hi,

 

I need to showcase difference between columns only for last 2 columns.

I have created calculated column in cross table using below formula but issue is, it is showing diffrence verywhere not only for last 2 columns. Any idea how to hide remaining columns values. We don't want first 2 'Diff' Columns in the final visualisation.

Formula:Sum([Column]) THEN [Value] - First([Value]) OVER (NavigatePeriod([Axis.Columns],"Qtr_Num",-4))

 

 

 

2016Q4

Diff

2017Q4

Diff

2018Q4

Diff

 

 

2473736400

 

2543243461

69507061.15

2473736425

-69507036.15

 

 

6574937016

 

6391037506

-183899509.1

6574937026

183899519.1

 

 

9048673436

 

8934280968

-114392467.9

9048673451

114392482.9

[Khushboo Rabadia]

If you are adding Diff as cell value and then in Horizontal axes, it will be available for each NESTED value.

But your table looks different so I am not quite sure how you populated that because if you have expression like below then you get only one Diff column

Sum([Value]) as [2016Q2],

Sum([Value]) as [2017Q2],

Sum([Value]) as [2018Q2],

Sum([Value]) as [Diff]It would be helpful if you can provide the sample dxp