Pivot Table or something similar

  • Thread starter Visual Calendar Dilemma
  • Start date
V

Visual Calendar Dilemma

Hello,

I have a situation where I have a list of data that I would like to "pivot",
however, the data doesn't contain numbers that I would like to compare and
put in the data items area. It is events that I would like to put there, so
I don't want it to count, sum, multiply, etc. the data I just want it to
display the text as is.

Is it possible to format a Pivot Table to do this, or do I need to be using
some other report?

Example:
DATA:
Year Customer Event
2006 Joes Event 1
2006 Marys Event A
2005 Johns Event 3

I would like it to display:
Joes Marys Johns
2006 Event 1 Event A
2005 Event 3
 
D

Debra Dalgleish

A pivot table can't show text fields as text in its data area.
You could add Year and Customer to the Row area, and Event to the Column
area
Then, add another copy of Customer to the data area, as Count of Customer.
It won't produce the exact layout you wanted, but would indicate which
customers attended which events.
 
Top