Forum Discussion
MAX FOR CUSTOMER
HELLO
I HAVE THE FOLLOWING SITUATION.
| A | B | C | D | E | F | G | H |
| Customer Number | Country (0 = No Risky; 1= Risky) | Index of payment2 | Rating (0 = A,B; 1= C,D,E,F, no rating) | Insurance limit (0 = yes insurance; 1= no insurance) | (B-A) > 0 is 1 <0 is 0: | RISKY OVERDU Y is 1 empty is 02 | total rec on cl2 |
| AE00001 | 1 | 0 | 0 | 1 | 1 | 0 | 0 |
| AE00006 | 1 | 0 | 0 | 1 | 0 | 0 | 0 |
| BE00011 | 0 | 1 | 0 | 1 | 1 | 1 | 0 |
| BE00011 | 0 | 1 | 0 | 1 | 1 | 1 | 0 |
| BE00035 | 0 | 1 | 0 | 1 | 1 | 1 | 0 |
| BE00218 | 0 | 1 | 0 | 1 | 1 | 1 | 0 |
| BE00218 | 0 | 1 | 0 | 1 | 1 | 1 | 0 |
| BE00218 | 0 | 1 | 0 | 1 | 1 | 1 | 0 |
| BE00297 | 0 | 1 | 0 | 1 | 1 | 0 | 0 |
| BE00303 | 0 | 1 | 0 | 1 | 1 | 1 | 0 |
| BE00396 | 0 | 1 | 0 | 1 | 1 | 1 | 0 |
| BE00396 | 0 | 1 | 0 | 1 | 1 | 1 | 0 |
| BE00568 | 0 | 1 | 0 | 1 | 0 | 1 | 0 |
| BE00568 | 0 | 1 | 0 | 1 | 0 | 1 | 0 |
| BE00568 | 0 | 1 | 0 | 1 | 0 | 1 | 0 |
| BE00569 | 0 | 1 | 0 | 1 | 0 | 1 | 0 |
| BE01155 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |
| CA00036 | 0 | 1 | 0 | 1 | 1 | 1 | 0 |
| CA00110 | 0 | 0 | 0 | 1 | 1 | 0 | 0 |
I NEED A FORMULA THAT GIVE ME THE SUM OF COLUMN B-C-D-E-F-G BY CUSTOMER (FOR EXAMPLE TOTAL BE00568=3) AND THEN I NEED THAT THIS SUM IS DIVIDED FOR THE COUNTING OF ALL CUSTOMERS.
CAN YOU HELP ME ?
USE THE SAME MEASURE
total = var total=SUM(Hoja5[B])+SUM(Hoja5[C])+SUM(Hoja5[D])+SUM(Hoja5[E])+SUM(Hoja5[F])+SUM(Hoja5[G]) var cont=COUNT(Hoja5[A]) return DIVIDE(total;cont)
here the result
3 Replies
try this creat an index in the table and this measure.
total = var total=SUM(Hoja5[B])+SUM(Hoja5[C])+SUM(Hoja5[D])+SUM(Hoja5[E])+SUM(Hoja5[F])+SUM(Hoja5[G]) var cont=COUNT(Hoja5[A]) return DIVIDE(total;cont)
i give another example
yes
for example i have these datas
A B C D E F G H
AE00001 1 0 0 1 1 0 0
AE00006 1 0 0 1 0 0 0
BE00011 0 1 0 1 1 1 0
BE00011 0 1 0 1 1 1 0in my pivot i need a colum that give me BY customer MAX of the sum of all column B C D E F G H
here the result
Customer Number total AE00001 3 AE00006 2 BE00011 4 and then i need another mesure that give me the SUM of this new column "TOTAL" dived by the number of the customer (in this case 9/3
thanks to all
USE THE SAME MEASURE
total = var total=SUM(Hoja5[B])+SUM(Hoja5[C])+SUM(Hoja5[D])+SUM(Hoja5[E])+SUM(Hoja5[F])+SUM(Hoja5[G]) var cont=COUNT(Hoja5[A]) return DIVIDE(total;cont)
here the result