Could some please help me with what the correct structure for my report should be. I'm trying to product a report which has rows with summed totals for 2 datasets summed across 2 other datasets which are indirectly linked to each other (but directly linked to both of the datasets I'm trying to sum), but haven't been able to get the report structure correct (it either sums the wrong thing, or records are missing).
There are 4 data dictionaries (simplified for this example): RetailSales (RS), TradeSales (TS), Customers and Products. RS & TS are essentially the same structure linked to Customers and Products.
I would like to product a report which essentially looks like:
CustomerA Product1 sum(RS of P1) sum(TS of P1)
Product3 sum(RS of P3) sum(TS of P3)
CustomerB ....
But haven't been able to quite get the report right since Products and Customers aren't directly linked and I'm trying to sum two different datasets in a single row. Can anyone please help?
Creating reports and dashboards | Stimulsoft community forum
Reporting tool and data analytics tools for creating reports and dashboards in ASP.NET, ASP.NET MVC, .NET Core, Blazor, Angular, PHP, Python, WPF, JavaScript, and Java applications.