Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
What I really want is that depending on which line & which month the user clicks, the table displays the appropriate details. Any suggestions?
Thanks