AnsweredAssumed Answered

Master Dashboard view with several ancillary calculations

Question asked by EvanStein on Oct 19, 2013
Latest reply on May 3, 2015 by younesDEFFOUS

Title

Master Dashboard view with several ancillary calculations

Post

     Hello all!

     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.
     Evan Stein

Outcomes