Any new ways to deal with costs and revenue tables?

I have a table of costs, and a table of revenue. At this point I have a summary table of months, with a 'key' in both revenue and costs tables, to look at everything on a monthly basis.

With the introduction of dashboards, summary formulas in reports, formula queries, etc, is there a better way to do this now? I still think i need a summary table to accomplish this, but am wondering if this is still true?

Ultimately, I am trying to look at gross margin and other items which involve formulas between costs and revenue.

------------------------------
Mike Tamoush
------------------------------