How to get percentage values in tool tip

I have a stacked bar chart, with X axis shows Projet column and the stacked bars with sub project names. Stacked bars are colored based on sub project names.

The Monthly amount is shown on the Y axis..

In the tool tip I wanted to show the percentage of share for each stack bars. I tried to add a custom formula in the tool tip but it is showing as a decimal value and not as a percentage.

 

Custom expression in tool tip : Sum([MonthlyRate]) / Sum([MonthlyRate]) over (Intersect(Parent([ProjectName]),All([Axis.Color]))).

 

How can we get the percentage share in the tool tip?

(1) Answer

Login