Percentage in a bar char

[GeosoftRim]

Hello
I have a stick graph which shows the proposed transport accepted, refused, canceled and pending
The sum of accepted, rejected, canceled and pending transports is equal to the proposed transports.
I want to present the percentage of accepted refused canceled pending compared to proposed and I want to present them in a bar chart

thanks 

[jbhappysocks · Accepted solution]

Hi

Normally you can use the built in modifier to achieve this, but that would make Proposé 50% and the rest would add up to the other 50 %. So you'll have to do it manually:

Sum(Amount)/Sum(total <Dimension> {<Type = {'Proposé'}>} Amount)

Is this how you wanted it?

[GeosoftRim]

Can you tell me "Amount" come back to what?
Here is how I calculate the proposed : count(reftdr)
And the others : count ({< [PCATDR.SENS] ={'Accepté'}>}[PCATDR.REFTDR])

[jbhappysocks]

Ok, you have them specified as separate calculations, I thought you had two dimension and one measure.

But then you should be able to change it to

proposed : 1  ( =count(reftdr) / count(reftdr) )
And the others : count ({< [PCATDR.SENS] ={'Accepté'}>}[PCATDR.REFTDR]) / count(reftdr)

Assuming count(PCATDR.REFTDR) = count (reftdr) = 100%