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 0
Slicers and Calculated Items in Pivot Table 2
Counting number of items excluding duplicates. 1
Arriving at totals 2
Dealing with a Pivot Table (when I don't want to) 0
Additional columns for Pivot table 0
Pivot Table, new field added 0
Formula in Pivot Table 0

Top