Non Numeric Data in Pivot Table

llcooljabe

Board Regular
Joined
Jun 13, 2002
Messages
76
HI,

I'm trying to teach a non excel user how to use pivot tables. That part is ok.

However, one of his goals in using pivot tables is analysing data as it changes from quarter to quarter. I'm in insurance. He's got a list of claims, with claim ID #, and Status (Open/Closed) and evaluation date:

Eval Date Claim# Status
9/30/2004 1001 Open
9/30/2004 1002 Open
9/30/2004 1003 Closed
12/31/2004 1001 Closed
12/31/2004 1002 Open
12/31/2004 1003 Reopened

He wants to run a pivot table by claim number to see which claims have changed status. The goal in this exercise is that he doesn't constantly come back to me to do his reports. I want to give him a flat file of data and teach him how to manipulate it himelf.

Most other things I've taught him. I can't figure out how to teach him this. I am hoping to use pivot tables, since I used them for my other lessons.
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

KenWright

Active Member
Joined
Jan 14, 2005
Messages
267
Claim# to ROW fields
Status to COLUMN fields
Eval date to ROW fields between Claim# and DATA field
Eval date ALSO into DATA area

Right click on value 'Open' and Order / 'move left' to get a better looking report.

This gives a logical progression of Open / Closed / Reopened
 

Watch MrExcel Video

Forum statistics

Threads
1,132,792
Messages
5,655,332
Members
418,190
Latest member
Timex

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top