How do I use a pivot table to present data, not sum or count it.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Here is my problem, I have one database with three fields, Name, Exam, Date
Taken. I want a pivot or other report which shows the names in rows and the
exam type in columns. The data section of the report needs to just present
the date the exam was taken. The pivot table is perfect except it wants to
operate on the data (sum, count, average, etc.) Is there a way to just have
it present the data. Or, is there another function that would do that?

Rick
 
Assuming for each name, there is only one exam and 1 date, try using the
min or max option instead of count or sum. format the max of date field
to be a date.

Matt
 
What would you do if the same person took the same exam more than once? I
think you'd have to choose either the first date ('Min'), the last date
('Max') or an intermediate date ('Average'). Since the pivot has to allow
for the possiblity of duplicates, you need to choose whichever function comes
closest to what you'd want. Of course, if you never have duplicates, then
those three options all return identical -- and correct -- results.
(BTW, you'll probably want to right-click on one of the filled in data cells
and select Field Settings; from there, choose a better label and format
(click on Number... and choose Date)).
 
I'm looking for something similar where I want to list the values in th
pivot

In my case I have a large list of systems used by our various DIVISION
by Different REGION. I wany my rows and columns to be GROUP an
REGION...and the "value" to be the list of systems used by tha
Group/Division combination. In some cases two different groups o
regions share the same system and it's value is repeated as anothe
row.

I can't figure out how to do this
 
I'm looking for something similar where I want to list the values in the
pivot

In my case I have a large list of systems used by our various DIVISIONS
by Different REGION. I wany my rows and columns to be GROUP and
REGION...and the "value" to be the list of systems used by that
Group/Division combination. In some cases two different groups or
regions share the same system and it's value is repeated as another
row.

I can't figure out how to do this.
 
I'm looking for something similar where I want to list the values in th
pivot

In my case I have a large list of systems used by our various DIVISION
by Different REGION. I wany my rows and columns to be GROUP an
REGION...and the "value" to be the list of systems used by tha
Group/Division combination. In some cases two different groups o
regions share the same system and it's value is repeated as anothe
row.

I can't figure out how to do this
 
I'm looking for something similar where I want to list the values in the
pivot

In my case I have a large list of systems used by our various DIVISIONS
by Different REGION. I wany my rows and columns to be GROUP and
REGION...and the "value" to be the list of systems used by that
Group/Division combination. In some cases two different groups or
regions share the same system and it's value is repeated as another
row.

I can't figure out how to do this.
 
Rick said:
Here is my problem, I have one database with three fields, Name, Exam, Date
Taken. I want a pivot or other report which shows the names in rows and the
exam type in columns. The data section of the report needs to just present
the date the exam was taken. The pivot table is perfect except it wants to
operate on the data (sum, count, average, etc.) Is there a way to just have
it present the data. Or, is there another function that would do that?

Rick
Click to expand...
Rick,
You need to choose "Product" option. Go into Field settings and select
product.
Cheers
Andy
 
Rick said:
Here is my problem, I have one database with three fields, Name, Exam, Date
Taken. I want a pivot or other report which shows the names in rows and the
exam type in columns. The data section of the report needs to just present
the date the exam was taken. The pivot table is perfect except it wants to
operate on the data (sum, count, average, etc.) Is there a way to just have
it present the data. Or, is there another function that would do that?

Rick
Click to expand...
Rick,
You need to choose "Product" option. Go into Field settings and select
product.
Cheers
Andy
 
Back
Top