Master Dashboard view with several ancillary calculations
I've designed a database to track inventory for sale. What I'm trying to do is build a "master dashboard" view to give me a snapshot of what's happening with the business. I'm trying to build a Form View that shows the results of several other reports that I've already written, but I can't seem to crack this nut. I'd like to show metrics such as:
-Total available inventory (in $)
-Total available inventory (in qty)
-Total unpaid sales
-Total sales in last 30, 60, 90 days
-etc. etc. etc.
I've tried several things including building portals to calculate summary cells, but nothing seems to be able to accurately show me these numbers all in the same window.
Any suggestions would be much appreciated!
Thanks in advance.