Calculated field in pivote table

[Anonymous]

Hello everyone,

My requirement is to show subtract total value at bottom of table(Horizontally).

I have 4  KPI . i want to subtract A from D ie D-A  which is know as Balance at the bottom of table.

KPI	2014	2015	2016	Q1 2017	Q2 2017
A	20	40	50	25	30
B	14	16	10	5	8
C	22	35	26	12	3
D	50	70	75	90	60
Balance	30	30	25	65	30

  i am not getting how it is possible. please help me to find out.

Thanks.

[sunny_talwar]

Would you be able to share a sample where you are trying this out?

[Anonymous]

Sorry Sunny i can't share.

[sunny_talwar]

no problem

[Anonymous]

it is possible to show specific field value calculation in pivot table?

[shiveshsingh]

Please share sample to brainstorm

[sunny_talwar]

I think it is possible... but since I don't know how everything is setup for you... don't really know how to help.... May be someone else can offer advice...

[Nagaraju_KCS]

PFA,

[Anonymous]

Hi Raju,

you used subtraction  for but still it shows addition in 2014 and remaining are empty.

 

[Nagaraju_KCS]

In expression tab, change Expression total to Sum..