Bar Chart Data in %

[Anonymous]

Hello,

I have two dimensions, country, and type of business.

I am trying to show data as percentage.

I would like to have for Spain, for one part 51% and the other 49%.

I have tried clicking on relative, however it is giving me the percentage not by country but of the total.

i hope you can help me.

[sunny_talwar]

Try this

Sum(Measure)/Sum(TOTAL <Country> Measure)

[Anonymous]

hello,

Originally, i have this expression, COUNT(total{$<SEGMENT={'PLANE'}>}SHARE).

doing what you told me it is not working however i think that is more that i haven´t written well the expression.

COUNT(total{$<SEGMENT={'PLANE'}>}SHARE).

/

COUNT(total{$<SEGMENT={'PLANE'},COUNTRY>}SHARE).

[sunny_talwar · Accepted solution]

You had this as expression?

Count(TOTAL {$<SEGMENT={'PLANE'}>}SHARE)

or this

Count({$<SEGMENT={'PLANE'}>}SHARE)

May be try this

Count({$<SEGMENT={'PLANE'}>}SHARE)/Count(TOTAL <Country> {$<SEGMENT={'PLANE'}>}SHARE)

[Anonymous]

It worked perfectly