Forum Discussion
Hidde
Helper I
Helper ICreating segments of customers based on multiple rows & values
Hi, I have rows of invoices, so lets say for 1 customer there are 4 invoices with a text description: 1. Standard module 1 2. Premium module 1 3. Standard module 2 4. Premium module 2 ...
HI Hidde,
Can you please share some sample data? I'm not so clarify for your data structure.
Regards,
Xiaoxin Sheng
HiddeHelper I
Helper I| Year | Period | Customer_name | Invoicenumber | Module | Desired outcome |
| 2018 | 1 | Client 1 | 13-104223 | Standard module 1 | Premium client |
| 2018 | 1 | Client 1 | 13-104223 | Premium module 2 | Premium client |
| 2018 | 1 | Client 1 | 13-104223 | Premium module 1 | Premium client |
| 2018 | 1 | Client 1 | 13-104223 | Standard module 2 | Premium client |
| 2018 | 1 | Client 1 | 13-104292 | Extra module | Premium client |
| 2018 | 1 | Client 1 | 13-104292 | Standard module 2 | Premium client |
| 2018 | 1 | Client 1 | 13-104368 | Standard module 1 | Premium client |
| 2018 | 1 | Client 1 | 13-104368 | Premium module 2 | Premium client |
| 2018 | 1 | Client 1 | 13-104368 | Premium module 1 | Premium client |
| 2018 | 1 | Client 1 | 13-104368 | Standard module 2 | Premium client |
| 2018 | 1 | Client 2 | 13-104223 | Standard module 1 | Standard client |
| 2018 | 1 | Client 2 | 13-104223 | Standard module 2 | Standard client |
| 2018 | 1 | Client 2 | 13-104292 | Extra module | Standard client |
| 2018 | 1 | Client 2 | 13-104292 | Standard module 2 | Standard client |
| 2018 | 1 | Client 2 | 13-104368 | Standard module 1 | Standard client |
| 2018 | 1 | Client 2 | 13-104368 | Standard module 2 | Standard client |
| 2018 | 2 | Client 1 | 13-104223 | Standard module 1 | Premium client |
| 2018 | 2 | Client 1 | 13-104223 | Premium module 2 | Premium client |
| 2018 | 2 | Client 1 | 13-104223 | Premium module 1 | Premium client |
| 2018 | 2 | Client 1 | 13-104223 | Standard module 2 | Premium client |
| 2018 | 2 | Client 1 | 13-104292 | Extra module | Premium client |
| 2018 | 2 | Client 1 | 13-104292 | Standard module 2 | Premium client |
| 2018 | 2 | Client 1 | 13-104368 | Standard module 1 | Premium client |
| 2018 | 2 | Client 1 | 13-104368 | Premium module 2 | Premium client |
| 2018 | 2 | Client 1 | 13-104368 | Premium module 1 | Premium client |
| 2018 | 2 | Client 1 | 13-104368 | Standard module 2 | Premium client |
| 2018 | 2 | Client 2 | 13-104223 | Standard module 1 | Premium client |
| 2018 | 2 | Client 2 | 13-104223 | Standard module 2 | Premium client |
| 2018 | 2 | Client 2 | 13-104292 | Extra module | Premium client |
| 2018 | 2 | Client 2 | 13-104292 | Standard module 2 | Premium client |
| 2018 | 2 | Client 2 | 13-104368 | Standard module 1 | Premium client |
| 2018 | 2 | Client 2 | 13-104368 | Premium module 2 | Premium client |