Dear Zoho Community,

I'm really new to Zoho but I'm excited about the world of endless possibilities that it gives me!

I will really appreciate any help to guide me!

I have Heating and Air Conditioning business and I created an app to get more in control in my business. 

One thing that I need to accomplish right now is creating a report that would show me profitability of my jobs. To count that I need to pull data from the Job Form which has the price of the job, then deduct the materials logged for that particular job from Outgo Form and also deduct Labor expenses related to that job from the Labor Form. There are existing relationships between these forms. But how do I create a custom report that would count things like that using my business specific formula for each job?

I tried Pivot Table, but it looks like it can only use data from a single form or am I missing something?