QV 11 - Drill down in field to open a straight table?

[#1]

Hi

I am using QV 11 and am trying to create a further drill down which opens up a straight table when any selection in a field is selected.

I am aware that QV will drill down to the extent of narrowing down your selection data but want to open up another table which show further details behind that selection.

Main Pivot = Budget Holder Report

Field = This Months Actual

Target Straight Table = GL Transactions

1. Select figure in 'This Months Actual'

2. Currently QV with select and show that rows data

Intention at step 2 is to select a figure in 'This Month's Actual' and then open the 'GL Transactions' table.

I am guessing I need to add a trigger to this field 'On Select' but am not sure where to add the 'Object ID'!!

Am I on the right track or do I need to do something completely different?

Any help would suffice,

thank you in adavance

regards

Andrew

[#2]

Hi Andrew,

You can use the conditional show in the layout properties of your straight table to be:

GetSelectedCount(fieldname)>0.

Would that answer your request or not ?

[#3]

1. I currently have a sheet with a number of objects in which only show when selected buttons are clicked

Adding you conditional show doesn't do anything as this table is already on show!

I am probably after this straight to maximise when any selection in fieldname in another chart is selected i.e.

active object minimise and target object maximise.

Hope this makes a little more sense?