Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Did you try TOTAL key word
Ex:-
Sum( Metrics ) / Sum( TOTAL Metrics )
Regards
Anand
If your expression for K is Sum(Sales), then to calculate percentage use Sum(Sales) / Sum(Total Sales)
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
Hi,
Sum(K)/Sum( Total <Dimension1><Dimension2> K).
Hope this will help
Regards,
Joshmi
Hi.
It works only with <Dimension2>.
Sum(K)/Sum(Total <Dimension2> K)
is right expression.
Thats right Formula