Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
!Hi,
You can use field event trigger for this.
Go to document properties -> Triggers-> Field event trigger
Select CarFamily-> Onselect-> Activate sheet-
!
On selection CarFamily is should take me to the SH04 Sheet. How to achieve this? How to write a condition?
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
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
!Hi,
You can use field event trigger for this.
Go to document properties -> Triggers-> Field event trigger
Select CarFamily-> Onselect-> Activate sheet-
!
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