Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
In a straight table you can do Column(3) - Column(2)
Try column(3)-Column(2)
Can you share your app?
Hi,
Try Column(3) - Column(2) . If this was not works in your case, share the sample application.
Thanks,
Venkata Sreekanth
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.