Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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)