How to compare data from 2 different modules that are child to a parent module?
I am trying to create a report using data from 3 modules: Account (parent module) and sales orders (child module) and distributor tracings (child module). I want to create a bar chart that shows by account owner (x-axis) how many items they have sold via sales orders (y-axis) and how many they have sold via distributor tracings (y-axis). Is there a way to add conditional filters so that the data results in the chart will show up if one set of criteria is applied for the sales orders OR if another set of criteria is applied to the distributor tracings? When I try to set a filter for sales orders (to exclude non-revenue items) it is automatically excluding all of the distributor tracings, but I want to retain the distributor tracing data in the results.