Pivot Table - Calculated Field

E

Emece

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.-
 
E

Emece

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.-
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Calculated Field - Sum/count 1
Pivot Table - Calculated Field - Percentage - Rept 2
Delete calculated field 1
Problem inserting calculated pivot fields into Pivot Table (2007) 1
Pivot table, IF function, calculated item versus calculated field 1
Pivot table Calculated Field 1
Custom Calculation in a Pivot Table 1
How do I perform extended calculations in a Pivot Table in Excel 2 4

Top