Hi everyone. I have 5 objects (Account,B,C,D,E) and the lookup relationships are shown in the picture. I can create a summary report with objects (Accounts,B,C) with no problem as I can find the report type in Other Reports -> Account with B with C.
My problem is now I need the total of Amount field from Object C by using Object E (Name) as a means of grouping but I also need them to be grouped by Account(Name) at the same time. The final report wil be shown per Account and will contain the total Amount from Object C per grouping with Object E.
Ex. Sample Org (Account)
Object E --- Object C (sum of Amount)
Type 1 ------ $100
Type 2 ------ $200
Type 3 ------ $150
Is it possible to make such report? If so, can anyone please enlighten me? Thanks !