Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there, I have created the chart below and I'm struggling to get the bars to be represented as a 100% value.
I have added the expression below - any suggestions?
Thanks
Rob
Expression
=Sum({$<Source_Key={1}>}Ans_Percent)/q1_total_sum_perc
Variable - q1_total_sum_perc
=sum ({$<Source_Key={1}>}Ans_Percent)
Hi.
It seems you don't have to discard the dimension totally as you want the ratios for each division:
=Sum({$<Source_Key={1}>} Ans_Percent)/Sum({$<Source_Key={1}>} TOTAL<Division_Name> Ans_Percent)
And the way you use the variables isn't suitable for this case as it's calculated ONCE for the whole chart.
If you remove the equal sign the content of the variable will be substituted into your expression.
Hi
Try like this
sum(ur expression) / sum(total ur expression)
Ex:
Sum(sales)/sum(total sales
Hope it helps
Hi Mayil, I tried that but wanted to check that I have it right as the result is a bit strange.
I created a variable VarDivPerc which was my expression
=Sum({$<Source_Key={1}>}Ans_Percent)/q1_total_sum_perc
Then applied your suggestion
=Sum(VarDivPerc)/ Sum(TOTAL VarDivPerc)
It came out like this!
Hi.
It seems you don't have to discard the dimension totally as you want the ratios for each division:
=Sum({$<Source_Key={1}>} Ans_Percent)/Sum({$<Source_Key={1}>} TOTAL<Division_Name> Ans_Percent)
And the way you use the variables isn't suitable for this case as it's calculated ONCE for the whole chart.
If you remove the equal sign the content of the variable will be substituted into your expression.
That is excellent, it has worked.
Much appreciated everyone.