Placing % on top of stacked charts with totals on x axis

[sweens78]

Hi Guys in the below chart I want to put the percentage on top of each stack column instead of the total, it works when I tick the Relative box in expression but I then want to show the the total on the x axis instead on the bottom of the of each stack but when I do it gives me each individual amount rather than the Total see below also any ideas.?  It has also misaligned my heading on x axis

ORIGINAL CHART

CHART WITH PERCENTAGE ON TOP

[sergio0592]

Hi,

In your expression, you have to use dual() function with :

dual(num(sum(Attendances) / sum(TOTAL Attendances),'# ##0,0%'), sum(Attendances))