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
 
Ad

Advertisements


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

Top