count of region

[soniasweety]

Hi all,

I have pie chart with  count of regions  it will display  each region count

but my requirement is

if I select any region in pie chart ---      that particular  region count should display in text object 

how can I write the expression in text object dynamically?

[Anil_Babu_Samineni]

It should automatic, no need to manipulate here. Count(Measure) is enough i believe

[soniasweety]

I need to ddisplay in text box along with the selected region

how can I get it?

[trdandamudi]

May be as below:

=If(GetSelectedCount(Region) >0, Count(Region),0)

[Anil_Babu_Samineni]

Why not this?

=GetFieldSelections(Region) & ' - ' & Count(Measure)

[trdandamudi · Accepted solution]

In text box use the below:

=If(GetSelectedCount(Region) >0, Region &'-' &Count(Region),0)

[soniasweety]

thanks aall.,

I will check and update you.