Hi All,
We have 2 fields 'Primary Vendor' and 'Secondary Vendors' which will be visible once the "Root Cause Category" field is set to '3rd party' (refer the below screenshot).
Since the 'Secondary Vendors' field is an list, while reporting we couldn't derive distinct values. For example:
on 1 problem we may have value1, value2 and value3, and on another problem we might have value1 and value3. The report should return:
value1 – 2 problems
value2 – 1 Problem
value3 – 2 problem
We know that a bar report won't list result like above, so we decided to create an related list on the Problem form ("Vendors" - please refer the screenshot) and add records as distinct like value1 will have 2 records on the list, value2 will have 1record and value3 will have 2 records under the related list "Vendors" using an after business rule.
Please help me on this.
Thanks,
Lavanya
