Pivot table and calculated fields

J

Jan T.

I have a pivot table where I want to do some calculations.

The fields are as follows:

Rowfield:
Name
OrderNo

Datafield:
Amount
Cost

From this I made a calculated field where I subtracted Cost from
Amount.
So far so good. I can see what I have left for each order.

However, I also want to see what is the average (profit) I have for
all orders
for one person or per Name.

Is it possible to calcuate this in my pivot table or du I have to do
something
in my source data?

Thanks for any help.


Regard
Jan
 

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

Problem inserting calculated pivot fields into Pivot Table (2007) 1
Pivot Table calculated item 4
Pivot table formulas 1
Pivot table, IF function, calculated item versus calculated field 1
Can I do calculations on already calculated fields in a pivot tabl 3
Calculated field in pivot adds row 1
Problem with Calculated item in Pivot Table 1
Calculates field in pivot table 2

Top