Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
In your expression, you have to use dual() function with :
dual(num(sum(Attendances) / sum(TOTAL Attendances),'# ##0,0%'), sum(Attendances))