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?