R
RGO
Hello
Could anybody help me with this problem I am trying to solve.
Is it possible to apply the soustraction operator on a field of a pivot
table ?
I have a table with 2000 lines with this structure :
A B C
Isin Id Surcote
AT383740 00058 - Bilan 934
AT383740 PA058 - Bilan 734
AT384821 00058 - Bilan 89
AT384821 PA058 - Bilan 89
From this, I tried to obtain a synthesis table like :
A B C D
Isin Id Total Gap Surcote
AT383740 00058 - Bilan 1 200
PA058 - Bilan 1
AT384821 00058 - Bilan 1 0
PA058 - Bilan 1
I obtain the first gap surcote (in colonn D) by doing this operation :
934-734 = 200
When I use the pivot table there's no problem with the first 3 fields (Isin,
Id and total).
But I don't know how to make this soustraction in order to obtain the field
named Gap surcote.
Thank you for any help
rgo
Could anybody help me with this problem I am trying to solve.
Is it possible to apply the soustraction operator on a field of a pivot
table ?
I have a table with 2000 lines with this structure :
A B C
Isin Id Surcote
AT383740 00058 - Bilan 934
AT383740 PA058 - Bilan 734
AT384821 00058 - Bilan 89
AT384821 PA058 - Bilan 89
From this, I tried to obtain a synthesis table like :
A B C D
Isin Id Total Gap Surcote
AT383740 00058 - Bilan 1 200
PA058 - Bilan 1
AT384821 00058 - Bilan 1 0
PA058 - Bilan 1
I obtain the first gap surcote (in colonn D) by doing this operation :
934-734 = 200
When I use the pivot table there's no problem with the first 3 fields (Isin,
Id and total).
But I don't know how to make this soustraction in order to obtain the field
named Gap surcote.
Thank you for any help
rgo