Column difference in Pivot table/Staright table

[Anonymous]

I have the data as per attached excel sheet (data.xls).

I want to get the difference between last two columns in Pivot table / Straight table.

Source	Team	BDate	2018-03-01	2018-03-08	2018-03-15	Diff (between last tow columns)
Client1	Team1		510	1010	1510	500
Client1	Team2		60	110	160	50
Client2	Team1		5100	10100	15100	5000
Client2	Team2		600	1100	1600	500

[fabdulazeez]

In a straight table you can do Column(3) - Column(2)

[shiveshsingh]

Try column(3)-Column(2)

Can you share your app?

[Anonymous]

Hi,

Try Column(3) - Column(2) . If this was not works in your case, share the sample application.

Thanks,

Venkata Sreekanth

[Anonymous]

Thanks for your reply,

I have attached the data I am using.

I have data vertically and the data will change (means data is not static).

In pivot I can move the dimension from vertical to horizontal.

But how can I achieve desired result in straight table. Can you please create the sample application with the data I have attached.