Filter between tablebox and chart

[#1]

Hi all,

I have table box showing the

time,tradeno clientname clientNo branch Amt Product

and chart showing the sum of amt (sales) based on the the time.

How can i do :

when i click on any data in the tablebox like clientno, clientname,tradeno etc , i want pass the time as my filter to the chart.

Thanks

[sunny_talwar]

How can i do :

when i click on any data in the tablebox like clientno, clientname,tradeno etc , i want pass the time as my filter to the chart.

Not sure I understand your request. Would you be able to provide a sample so that we can visualized what you are trying to do.

Best,

Sunny

[swuehl]

If you want to consider the possible values for time (limited by your selections in the other fields), but disregard any other selections in your aggregation, try something like this in your chart expression:

=Sum({1<time = p()>} Amt)

or

=Sum({<time=p() ,tradeno, clientname, clientNo, branch, Product>} Amt)