Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to build a chart that shows me every month how many customers buy me now and that they did not buy me before and how many customers bought me in the previous month and now they do not buy me.
This is the grid that i have:
Customer | Jan | Feb | Mar | Apr | May |
---|---|---|---|---|---|
A | 10 | - | - | 10 | 10 |
B | - | 10 | 10 | - | 10 |
C | - | - | 10 | 10 | - |
D | 10 | - | 10 | 10 | - |
E | - | 10 | - | 10 | - |
And i need this result:
Feb
2 new customers (B and E) and 2 customers less (A and D) -- i only need the value (2 and 2)
Mar
2 new customers (C and D) and 1 customers less (E) -- i only need the value (2 and 1)
Abr
2 new customers (A and E) and 1 customers less (B) -- i only need the value (2 and 1)
May
1 new customers (B) -- i only need the value (1)
I need this result in a chart... Sorry for my english! I hope you guys can help me.
Hi, thnks for your help, this is a little example because the data that i have to work with is to big.