Conditional Question.

[MuraliPrasath]

Hi,

I've a Pie-Chart. If I select Pie-Chart dimension field, then it should take me to the SH04 sheet automatically, this is a detailed tab.

How to achieve this? How to write conditional statement on Dimension?

[MuraliPrasath]

On selection CarFamily is should take me to the SH04 Sheet. How to achieve this? How to write a condition?

[robert_mika]

If the second the only way is to add

a transparent button or Textbox which does exactly this action and put it over it the chart.

Create TextBox

Set Transparency to 100%

Then go to Actions-Add --Action Type-layout-ActiveSheet

In SheetID add SH04

[avinashelite]

Try like:

1.Set a variable to check whether dimension has been selected of not, like:

getfieldselections(your_fieldname)

2.Go to documents Triggers > on the variable action >set the activation of the desired sheet

hope this helps you

[Kushal_Chawda · Accepted solution]

!Hi,

You can use field event trigger for this.

Go to document properties -> Triggers-> Field event trigger

Select CarFamily-> Onselect-> Activate sheet-

!

[vikasmahajan]

Check if there is relation bewteen your data you can create drill and put into chart so that when you click on 2FICE 4PAS -> then pie chart will show further level in pie-Chart.

HTH

Vikas