% CALCULATION

[#1]

I want to calculate the % so that 129 should be divide by 154 & 17/154 same for the others.

Each value should be divide by total of it value 

[its_anandrjs]

Hi,

Did you try TOTAL key word

Ex:-

Sum( Metrics ) / Sum( TOTAL Metrics )

Regards

Anand

[anbu1984]

If your expression for K is Sum(Sales), then to calculate percentage use Sum(Sales) / Sum(Total Sales)

[Anonymous · Accepted solution]

Hi Shwetha,

In expression tab of chart properties add:

=sum(sales)/sum(Total Sales)

In Number tab:

Tick the checkbox show in percent option.

you will have % calculation and display percent in the chart

Regards

Neetha

[#5]

Hi,

Sum(K)/Sum( Total <Dimension1><Dimension2> K).

Hope this will help

Regards,

Joshmi

[#6]

Hi.

It works only with <Dimension2>.

Sum(K)/Sum(Total <Dimension2> K)

is right expression.

[#7]

Thats right Formula