Pivot Table Question

[Peter Haworth]

I have used pivot tables quite frequently but have come across a situation I
can't figure out.

The spreadsheet keeps tracl of revenue and expenses for a band. I have a
separate column for each band members' share of revenue and expenses and
another column that contains a "type", eg Cash Sale, Credit Sale,
Disbursement, Expense, etc.

I want to have a pivot table that has a column for each band member and a
roe for each value in the Type column. The columns for each band member
should show the total value for each value of type. For example:

TYPE MIKE PETE JOHN DAVID
Cash Sale xxx xxxx xxxx xxxxx
Expenses xxx xxxx xxxx xxxxx
TOTAL xxx xxxx xxxx xxxxx

HOw can I do this?

Thanks,
Pete

 

[Katherine Coombs]

Hi Pete,

If your spreadsheet looks like this:

NAME TYPE AMOUNT
Mike Expenses $25.00
etc
etc

Then you can get the pivot table that you want by using "Name" as the column
field, "Type" for the row field and "Amount" as the data item in your Pivot
Table.

HTH,
katherine

 

[Peter Haworth]

Unfortunately, that's not how the spreadsheet is laid out. The Column you
called NAME is actually 4 different columns labelled MIKE PETE JOHN DAVID
with each of those columns containing a dollar value.

I guess what I need to do is to keep that format but insted of having
multiple rows for each value of TYPE, just one rwo for each value of TYPE>

Pete