2 Replies Latest reply on Mar 16, 2012 12:57 PM by P Fro

    Running total against aggregate cost

    P Fro

      I know that mixing aggregate and non-aggregate is a "no-no" but I'm trying to come up with a view which will show a running total against the aggregate cost of an item. For example: Say I have a product which costs $200,000 total up-front and I collect income against that total cost over the course of a year. At the end of the year I want to look at a bar graph to see the running total of income against a total of cost to find the "break even" point and other points of interest (spikes, lulls, etc. image attached)

       

      I currently have my income running across the graph with a quick table calculation using the date.

       

      Any thoughts? Thanks!