I have two tables of raw data: "product sales" (raw individual product sales) and "product work" (raw time log entries)

I want to create a chart that contains total revenue (sum of all sales) and total cost (sum of all work) on a monthly basis.  What is the best way to do this?

I can easily create a pivot view for sales and a pivot view for work, but what I want to do is create a view that combines two pivot views.

One challenge is that the pivot view cannot be queried by a query table, nor can it be charted (and data from two different tables cannot be charted).  Is the only solution to manually create pivot tables using special queries?  Or, did I miss some feature that would allow me to do this?

Is there any way to see the query used behind the scenes for a pivot view?  This would allow me to more easily create a query table that produces my pivot view.  Then I can create a query table that joins the two query tables with pivot views.

My one major challenge that I'm having is that it doesn't seem like "analysis" is very easy to do when the raw data spans multiple tables.  It seems that the only way is to dive into SQL and do it with query tables.