Pivot tables - adding dates, descriptions


L

Len Chaston

I am not understanding a basic process in the pivot tables.

I have a simple table of subcontracts for my construction company. The
fields are:
Job#
Contract #
Vendor
Date
Contract item #
Description

I can make a pivot table that shows the contract item #'s as a row label and
then the sum of the valuse as a seperate column.

What I want to show is the date and the description of each contract item,
so that the pivot table would look something like this:

Contract item #1 12/18/09 framing $18,000
Contract item #2 12/22/09 window prep $2,300

I can add date and description as Row Labels, but then they each create a
seperate row, and I would like all of the information to be on one row,with
the values at the end.
Any help is much appreciated
 
Ad

Advertisements

T

trip_to_tokyo

Len, I am looking at this right now.

Question please: you mention a figure of $ 18,000.

Which column (in the underlying data) does this come from?

As far as I can see your columns:-

Job#
Contract #
Vendor
Date
Contract item #
Description

- do not have a, "number" field (from which the figure of $ 18,000 is
derived).

Which column (in the underlying data) does this come from?
 

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