ExcelBanter - Pivot Table - Calculated Field

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot Table - Calculated Field (https://www.excelbanter.com/excel-discussion-misc-queries/250474-pivot-table-calculated-field.html)

Emece

Pivot Table - Calculated Field

I have a Pivot Table with the following format:

ALMACEN
ARTCOD MOVENTSAL Total
9 S 11.36
S 209.48
E 79.45
E 55
S 137.88

I need the result of Total S - Total E. Can I do this with a calculated field?

Thanks in advance

Regards,
Emece.-

Jim Thomlinson

Pivot Table - Calculated Field

Post some source data...
--
HTH...

Jim Thomlinson

"Emece" wrote:

I have a Pivot Table with the following format:

ALMACEN
ARTCOD MOVENTSAL Total
9 S 11.36
S 209.48
E 79.45
E 55
S 137.88

I need the result of Total S - Total E. Can I do this with a calculated field?

Thanks in advance

Regards,
Emece.-

Emece

Pivot Table - Calculated Field

Here some source data:

ARTCOD MOVCNT MOVENTSAL
1904 65.16 S
1904 61.1 E
1904 163.14 S
37299 11.36 S
37299 209.48 S
37299 79.45 E

Thanks again

Regards,
Emece.-

"Jim Thomlinson" wrote:

Post some source data...
--
HTH...

Jim Thomlinson

"Emece" wrote:

I have a Pivot Table with the following format:

ALMACEN
ARTCOD MOVENTSAL Total
9 S 11.36
S 209.48
E 79.45
E 55
S 137.88

I need the result of Total S - Total E. Can I do this with a calculated field?

Thanks in advance

Regards,
Emece.-

All times are GMT +1. The time now is 12:05 PM.