Drill down to a different object

[Anonymous]

I have a simple line chart (x axis : Mon-yy, y axis : Sum of dollars). What I want is when I double click on a line, it opens up the detailed transactions which makes up the dollars in a table format.

I am thinking of having a chart & a table with conditional display, but not sure how I can pull it off. Any ideas?

Thanks,

Dinesh.

[#2]

Hi

If my thinking is correct, when you double click on a line then that will probably select a single date, therefore, you could create your table object and give it a conditional show expression (in the layout tab), the expression would be something like:

GetSelectedCount("YourDateFieldName") = 1

That means, the table object will only show when only a single date is selected.

[boorgura]

Nigel,

I would agree with you.

But the only concern is - if a user selects a single date - I would assume it displays the TABLE.

not sure if that was fine.

[Anonymous]

What I really want is that depending on which line & which month the user clicks, the table displays the appropriate details. Any suggestions?

Thanks