Forum Discussion
need code
Hello Everyone, I have the "constant variable" as the main group in my table and then I have subgroups in my data set and each subgroup has multiple representatives to represent it in the ...
| Data set | |||||||
| Client list | Retailer list | Sales Representative | |||||
| A | a | R1 | When select R1 on the slicer | ||||
| B | a | R2 | Output required | ||||
| C | b | R1 | Client list | Retailer list | Overlapping efforts of Sales Representative | Retailer names | |
| D | g | R7 | A | a | R2 on | a | |
| E | d | R1 | C | b | R5 on | d and r | |
| F | d | R5 | E | d | R7 on | q,b, and g | |
| G | b | R1 | G | b | |||
| H | b | R7 | I | f | |||
| I | f | R1 | K | E | |||
| J | r | R5 | |||||
| K | E | R1 | |||||
| L | q | R7 |
I just want to display more than one representative working with the same retailer in the list and display that information with client details.