Sum divided by Sum of all

[Anonymous]

Hi,

How can I calculate the following Mix % column?

i'm sure it is straight forward...

The row value divided by the Grand Total.

	Value	Mix %
Alpha	100	13%
Beta	200	25%
Charlie	200	25%
Delta	200	25%
Echo	100	13%
Grand Total	800	100%

thanks

Derrell

[#2]

try this

sum(Value)/sum(Total Value)

and under number format set Mix % format to integer and check show in percentage option

[SunilChauhan]

sum(Value)/sum(Total <dimensionName>Value)

[SunilChauhan]

sum(Value)/sum(all Value)

[Anonymous · Accepted solution]

Hi,

There are different ways to calculate the same...

1.Use the measure as sum(Value) and make the Relative check box selected in  the expression tab.

2.If you don't want to obey the % value according to the dimension used in the chart then use the measure as sum(Value)/sum(TOTAL {<Dimension  = >}Value) and change the number formatting settings to show in percentage.

Hope this helps.

Thanks,

Vignesh

[Anonymous]

thank you everyone, all your suggestions works.

happy holidays!