Pivot table help

[TishyMouse]

I'm sure there is a very simple answer to this but I can't figure it out...



I have a table containing data about a new database that I am creating

It contains a list of mappings including the following columns

SourceValue, NewTable, NewField, NewFieldDescription, AnyOtherCol
a, Table1, Field1, blah 1, x
b, Table1, Field2, blah 2, x
c, Table2, Field1, blah 3, x
d, Table1, Field1, blah 1, x

A SourceValue can be mapped to a single table/field combination.
The table/field combination may however map to multiple SourceValues.

I want to create a table that will count the instances of each mapping but will also include in each row the NewFieldDescription, i.e. as follows:

NewTable, NewField, NewFieldDescription, Count of SourceValue
Table1, Field1, blah 1, 2
Table1, Field2, blah 2, 1
Table2, Field1, blah 3, 1

I can successfully create the pivot table without the description as follows:
Row Labels: NewTable, NewField
Values: Count of AnyOtherCol

But I don't know how to include the NewFieldDescription against each row in the table.


I'm using Excel 2007.

[TishyMouse]

Bump... Any thoughts on this at all? Thanks

[Pecoflyer]

Could you post a sample sheet please showing "before" and "after" ? Thx