T
TEN
Hi,
is it possible to have an Pivot Table subtract values in a
sum column, and not only Add or Multiply?
For instance, we have the following Pivot Table-structure:
A B C
1 2 3
2 4 6
7 3 10
We would like a Column C to not have the sum of Column A
and B, but rather the Column A - Column B-values. Is it
possible to do this with Pivot Table with two columns?
We of course know we could add a new column in the
spreadsheet alone, but this would easily be errorful when
changing the Pivot Table.
Thank you!
is it possible to have an Pivot Table subtract values in a
sum column, and not only Add or Multiply?
For instance, we have the following Pivot Table-structure:
A B C
1 2 3
2 4 6
7 3 10
We would like a Column C to not have the sum of Column A
and B, but rather the Column A - Column B-values. Is it
possible to do this with Pivot Table with two columns?
We of course know we could add a new column in the
spreadsheet alone, but this would easily be errorful when
changing the Pivot Table.
Thank you!