I have a report where employees are classified into a stream from the data source. They can be split accross the streams. This creates a multivalue error when I try categorise their expenditure into the relevant categories.
The report uses two data sources, one for the employee stream and one for the transactional data and they are linked using their userid
What I want to do is make a decision on to prioritise the manufacturing stream over the professional stream. Is there any way I can do this?
Below is a sample of the data used and the query it comes from
| Account Holder (Transaction) | Employee Stream (Staff) | Amount (Transaction) |
| EMP1 | Professional | (14.09) |
| EMP2 | Manufacturing | 1.89 |
| EMP3 | #MULTIVALUE | 200.00 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.