The dashboards in Projects are useful to an extent, however I have been tasked to build reports and dashboards in Zoho Analytics that more meet specific needs.

I am trying to create a pivot to show :

Project Name - Status - Budget Cost - Forecast Cost - Planned Cost - Actual Cost

I have created a SQL query to get the actual cost as a calculation from the timesheets of hours worked * user rate and found the Budget value in Projects.Billable Amount

How do I work out Planned and Forecast ?