Pivot table help

TishyMouse · #1 04-25-2012, 08:35 AM

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

Code:

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:

Code:

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
pivot table	aliasadi_07	Excel	1	03-11-2012 12:49 AM
Help with pivot table macro	ejima	Excel Programming	2	02-16-2012 03:45 PM
Help with a pivot table please!	natsha	Excel	1	02-16-2012 12:41 PM
Pivot Table	Karen615	Excel	5	08-03-2011 10:46 AM
Pivot table problem	swindon	Excel	5	05-25-2010 02:05 PM