3 Replies Latest reply: Apr 3, 2012 5:46 AM by Jason Michaelides RSS

    Help with graph showing percentages

      hi all,

       

      I have a graph which shows 3 percentages, by month.

       

      At the moment, the percentages seem to be worked out on totals across ALL time - yet I need them specific to the month that is being shown.

       

      If I select a particular month from a list box it is fine...

       

       

      my expression is:

       

       

      SUM(HOURS)

      /

      SUM( TOTAL HOURS)

       

       

      simple enough..

      so how can I make it relate to the TOTAL in just the month (one of the dimensions)?

       

      Thanks in advance,

      Matt