Skip to Content
0

SAP C4C Analytics: Data source for combining Tickets and Orders

Feb 03, 2017 at 10:01 AM

85

avatar image

Dear Experts,

for our C4C project, we set a report that compares the number of tickets and the number of orders opened for a certain sales organization or for a certain customer or by a certain employee.

To achieve it, we set up a custom Data Source that counts the number of tickets and the number of sales order, hence we set a join between the data sources related to the sales order header and to tickets.

The resulting report actually displays all sales organizations/customers/employees linked to a ticket OR to an order. So, basically, the results are not filtered at all.

What we need to set up is a filter on tickets: if in the sales org/customer/employee has not any ticket associated, then it should not be shown in the report list.

Can anyone have any hint to achieve this goal?

Thanks in advance for your help.

Kind regards

Rosalia

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers