Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to have a bar chart and except from the totals to have also the percentage?
Thank you in advance,
Angelos
Use dual in your expression
e.g.
dual(num(Sum(LineSalesAmount),'#,000.0')& ' (' & num(Sum(LineSalesAmount)/Sum(total LineSalesAmount),'#0.0%')&')',Sum(LineSalesAmount))
so your label will show some thing like 1,200 (10.1%)
Hope it helps
Use dual in your expression
e.g.
dual(num(Sum(LineSalesAmount),'#,000.0')& ' (' & num(Sum(LineSalesAmount)/Sum(total LineSalesAmount),'#0.0%')&')',Sum(LineSalesAmount))
so your label will show some thing like 1,200 (10.1%)
Hope it helps
It works when you change the number formatting to «Measure Expression»
Thanks
No problem. Missed to add that step 🙂