Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
if I click on any field in chart… the chart should not filter/shrink on that value instead it should take the values of selected row and show in current selections or in list boxes.
For example if I click on company "A" (5th row), the chart should remain same (like detach) but and in the list boxes/ current selection the values are like
Hello,
If you want an object (for example a Straight Table or a Chart) to stay fixed with all the information you can use Set Analysis, but instead of using {$}, use {1} so that it always selects the whole set.
If you want it fixed but with certain information, you can also specify it in the Set Analysis part.
Hope it helps!
Thanks, can you please upload an example....
In my straight table there is expression Sum(Sales) to find out the total sales. instead of that ,if i use Sum({1}(Sales)), all the data will be displayed as such even if you select data on list box. Reason for that is,{ 1} - Represents the full set of all the records in the application
I have attached the example ,I have done ..please try this...
Hello,
I made a simple example for you. It contains a normal table and then the one with Set Analyisis so you can check the differences.
I hope it helps !
Thank you very much... Villafuerte & naive123 for your examples, its working fine but its not completely solves my problem, also looking for
Thanks in Advance
Can you please post the application? so we will better understand your requirements......................
Hi,
I hope we can help you with your problem, but can you make a dummy file so we can understand it better please?
Cheers