Pie chart help

[#1]

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.

[vijay_iitkgp · Accepted solution]

Hi,

Go to Properties---->Expression and check relative.

[jagan]

Hi,

Select the 'Relative' option in Expression tab in Chart Properties.  This will give the percentage.

Regards,

Jagan.

[#4]

Brilliant! Thank you both. I didn't know it was so simple!!!