Pie chart Issue

[Tanish]

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.

[SunilChauhan]

try like this in Expression

If(GetSelectedCount(YearMonth)>0,Sum(SalesAmount),num(Sum(SalesAmount),'#.##%'))

See the attached

[vinieme12]

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