Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Good Morning to All,
i have one straight table like this ,here problem is circled one is label
the next sheet i created one more table having all detail information about different business
when i click that label i just want to move the detail sheet
how can i make label as click format
Best Regards,
Niranjan
You can have a trigger that checks if only one of the problems are selected. If one single problem is selected then you can hide the current sheet and show the sheet with the details.
This is a little bit "risky" since there could possibly be other events than just clicking on the label that leads to only one label being selected - so the logic is not fail-safe.
The steps:
1) Create two variables named vShowMain and vShowDetails and assign the number 1 to each of them
2) Create the two sheets - one for the Details and one for the Overview (unless you already want to use your main sheet)
3) The Overview sheet needs a Show Sheet - Conditional that you can specify on the properties of the sheet like this:
vShowMain
4) The Details sheet needs a Show Sheet - Conditional
vShowDetails
5) Go to the Settings / Document Properties and the Triggers tab and select your field in
the Field Event Triggers listbox then press the On Select - Add Action(s) Button and add two actions
of type External , Set Variable:
variable: vShowMain
value: If( Count(DISTINCT TheLabel) = 1 , 0 , 1 )
variable: vShowDetails
value: If( Count(DISTINCT TheLabel) = 1 , 1 , 0 )
6) On the Details sheet you need some way of deselecting the single label so you can "leave" the sheet.
It could be made by having a button with this Action:
Selection / Select in Field:
Field: TheLabel (use the actual field that is displaying the label ... not the column header)
Hi Petter,
Many Thanks for your reply
i have 60 expression if can i select any one of expression from first chart
the same expression details i want to show in my details sheet
but label i can't able to select
if its required please find the my attachement
Many Thanks,
Niranjan
Are you saying that you can't select any value in the label column? Are you using a Straight Table or a Pivot Table?
Yes exactly Sorry its pivot table
when i click this label second sheet i m using same label expression for detail view
the same way for 60 expression every label i want to show the detail view
any way can i make label Click format
Best Regards,
Niranjan
So it works for you?
im not able to do that i attached sample app
can you please show me how we can achieve this problem
Many Thanks
Niranjan
I am sorry - I don't know of any way to achieve this in a Pivot Table that is embedded in a container seven times. With one single Pivot Table you could have a button for each of the rows to the right left of the first column. But with seven pivot tables there is no way that I know of to be able to detect which of the container objects are visible.
The only solution to this as far as I know is to abandon the container and emulate the container appearance with buttons instead and hiding and showing each pivot table. Then you could achieve this with buttons and detecting which of the pivot tables are currently active.
if can we achieve with one pivot table i will remove using Container object
above im using one list box if you select any value from list box details view sheet will appear
there im showing percentages also in list box, if nothing will work im planning to use that technique
Best Regards,
Niranjan
I think I can give you an example based on your Sample Application. But I am running out of time now for an appointment. Maybe I will be able to have a look at it later today or tomorrow.