sum and percentage in a same bar chart

[#1]

Hi any one Please help me with this fix...

I have an bar chart in that i am giving country as dimension and  =sum(amount) as expression..so that I am getting an bar chart.

I want a relative percentage of expression in the same chart

Eg :I want a relative percentage of germany in near to the value 39.48L..

thanks in advance..

[Gysbert_Wassenaar]

You can use the dual function. See attached example.

[jagan]

Hi,

Please find attached file, hope it helps you.

Regards,

Jagan.

[#4]

Thanks

But I need a Both percentage value and sum of value in a same bar.

Percentage value in a bracket and sum of value is near to that.

[#5]

Hi Jagan thanks fr yur reply

But I want a both values in same chart

[Gysbert_Wassenaar · Accepted solution]

Just add a bit to it to display both values:

dual(num(sum(Sales)/sum(total Sales),'0%') & chr(10) & sum(Sales), sum(Sales))

or maybe: dual(sum(Sales) & ' (' & num(sum(Sales)/sum(total Sales),'0%') & ')', sum(Sales))

[jagan]

PFA file for solution.

Regards,

Jagan.

[kaushiknsolanki]

HI,

     Why dont you show the both value when you take cursor on that, something like text popup.

Regards,

Kaushik Solanki

[#9]

Thank you for your reply

There is any other way apart from  dual function.?