Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am facing issue in Pie chart, when i select any of the Dimension value. It show 100% share.
How can we get the exact % value even after selecting any value ?
It shows 100% share.
try like this in Expression
If(GetSelectedCount(YearMonth)>0,Sum(SalesAmount),num(Sum(SalesAmount),'#.##%'))
See the attached
Step1:
Modify the expression to ignore the pie dimension
sum({<salesrep=>}sales)
step2: Under Appearance >> Colors and Legend >> Colors >> uncheck Auto
Choose "Color by Dimension"
this will now highlight only selected dimension pie slice in the chart