How to activate/show an object(Pie-chart) when we select the dimension in Barchart/Pivot Table

[PradeepReddy]

Hi,

Here is the requirement. whenver  I click a dimension in Bar Chart/Pivot table, another chart(Pie chart) should be populated. This shouldbe dynamic.

Org Type	Sector	Company Name	Tax pay
Govt	Biotechnology	Name1
	Infrastructure	Name2
	Medical	Name3
	Manufacturing	Name4
Private	IT	Name5
	Manufacturing	Name6
	Banking	Name7
Public-Private	Biotechnology	Name8
	Infrastructure	Name9
	Medical	Name10
	Manufacturing	Name11

Suppose when I selected the dimension 'Org Type' in pivot table/bar chart, a new sheet object(Pie chart) with "Sector" as dimension & "Tax pay" as expression shoud be visible.

Thanks in advance...

[Anonymous]

Hi Jonathan

Thanks for the Suggestion it really works

But

I have a new Scenario that

like

Year,

Month,

day

So when i select any Value from month then it should not effect to Year

is it Possible ?

Regards

Tahemas

[Kushal_Chawda]

to get this done, create the copy of your dimension based on which you need to show pie chart

LOAD ...

      [Org Type],

      [Org Type] as  [Org Type Bar],

      [Org Type] as  [Org Type Pivot],

Use [Org Type] in listbox which will be standard for all

Use [Org Type Bar] dimension in Bar chart

Use [Org Type Pivot] dimension in Pivot table

Now, in pie chart->Properties->Layout->Conditional, put below expression

=getselectedcount([Org Type Bar])>0 or getselectedcount([Org Type Bar])>0

or you can create only one copy of your dimension, which can be used in Bar/Pivot Both

[Shubham_Deshmukh]

Hey,
I just want to clear one thing that we cannot activate any chart by selecting Bar chart , right?