Hello,
sombody knows how to do slope function in Access?
I have 3 fields:
Customer
X = month-year
Y = percentage of open credit> of 1 year respect total open credit
Customer1 201501 10%
Cusotmer1 201502 20%
Cusotmer1 201502 15%
Customer2 201501 15%
Customer2 201502 10%
If I analyse the Graph in Excel grouping all customer togheter I can see, using regression line, if the situation of open credit is gettings worst referred to the age of the credit (more or less than one year).
the next step is identify the customer that are increasing this percentage
IN other words ar eall customer for which the slope is positive
I would like to have a sort of grouping query where for each customer I can have the slope in order to have the list ordered for slope value
that at the end is the indication who are the customers where the open credit is getting worst in the period selected
any idea?
Posted by: valentino.avvisati@gmail.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar