Creating % analytics

[#1]

Hello,

I have a chart to which I am trying to show a % of products used.  However, I've hit a dead end asto how to create this.  I currently have the following expression which gives me the total value of the product used:

=num(sum(OKM_POTENTIALVALUE)

I want to then divide this into the total for a specific procedure which the expression is the same.  Any ideas on how I can do this?

(The tab in question is the Consumable tab)

(Hope it makes sense)

[tresesco · Accepted solution]

Check 'Relative' in the expression tab, check the output, is this what you want?

[#3]

Clicked it, doesn't make any change unless I am doing something wrong??

[tresesco]

Did you try it in your pie chart? and yes check 'Values on data points' as well, you would notice the change. See how I see:

[#5]

Perfect!!!!  Something so simple has kept me stuck for days.

Thank you!