Attrition rates on a graph

N

Nathan Greurg

Hi,
I'm trying to display attrition rates on a graph.
So I need my figures set up on a spreadsheet the sheet in a particular way
for the graph to make any sense of it.
I want this automated so I want to use a Pivot Table and an external CSV
data file.

My CSV data records contain
- for each client (= Client ID)
- the first payment date and
- the most recent payment date.
- Number of Days betwen First and Latest payment Date

(First payment is equivalent to recruitment date.
Latest payment is the Client's most recent sign of life in my base.
If a client has not made a payment for the last 12 months I can consider him
inactive.)

So I have everthing I need to look at the attrition rate.

I have published this posting as a gif file on a website as the tables I
want to display get mangled when displayed as text.

It is quite complicated and I am looking for help from someone who really
knows his stuff on Pivot Tables and Graphs.
here' the gif www.fransysco.net/attrition.gif

Any help appreciated.
It my question is not clear enough, just let me know and I'll put some more
effort into it.

TIA
By for now,

Nathan.
(or Dave)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table headache 2
Select a range of data dependant on the users input ie dates 2
Calulate interest for a loan as payments are received 2
Pivot Table Help 1
Cutting excess rows 2
show the most recent payment 5
Extracting data from spreadsheet to a graph 2
Calculating interest due on late loan payments 1

Top