3 Replies Latest reply: Feb 21, 2012 7:02 AM by fantasticmrfox RSS

    Pie chart help

      I'm trying to see the total revenue generated by each of courses in a given month. I am then putting the information into a pie chart to show the six highest grossing courses. The problem I am having is that I want to show the proportion of total revenue each course contributes in % terms and not, as it currently is, in real £ terms.

      dimension: Course Name

       

      expression:

       

      ((Sum({<[Pipeline Year]={$(varCurrentYear)}, [Pipeline Month]={$(varCurrentMonth)}, COUNTY -={'JSY','GNY','IOM','NHQ'}>} [InCompany Revenue]) +

      Sum({<[Pipeline Year]={$(varCurrentYear)}, [Pipeline Month]={$(varCurrentMonth)}, COUNTY -={'JSY','GNY','IOM','NHQ'} >} [Scheduled Revenue])))

       

       

      Is there a way to edit my current expression so that the result is shown in % terms, rather than having to re-write the expression?

       

      Thanks.