Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Go to Properties---->Expression and check relative.
Hi,
Select the 'Relative' option in Expression tab in Chart Properties. This will give the percentage.
Regards,
Jagan.
Brilliant! Thank you both. I didn't know it was so simple!!!