Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi friends,
Can anyone solve my issue as below:
selected 'always select one value' for customer name filter as I want in sheet1. In other sheets there is no customer name filter, but the chart objects in sheet2 &sheet3 also showing values based on customer name filter selected in sheet1.
Thanks in advance.
filter applies to all sheets in an app. If you don't want it, then alternate states might help.
Hi @Venus ,
Thanks for suggestion, I tried & that works, but the problem is in sheet1 it is single selection, where as in sheet2 I have to give multiple customer selection as well, according to new requirement. Is there any possibility to show without using extensions.
I'm afraid I don't understand what you want as a result. You have 3 sheets. Sheet 2 and sheet 3 are not supposed to react to the filters of sheet 1, right? any other conditions?
Hi @Venus ,
Yes, that's exact I want. Here are 2 images one is with alternate state & the other without.
Applied 'single value selection' for 'Designation' field from field settings, as it was mandatory at least one selection and given alternate state for table & filter in sheet1.
unable to select more than 1 value in filter in sheet2 without alternate state, Also tried creating new Designation field with alias name , still not getting on showing ticks
Did you assign the alternate state to the filter, too? The filter that has to be able to change the objects data has to be in the same alternate state.
Yes, applied same alternate state to filter & as well as for chart object.
create two states. Apply the objects of the first page to the first stage e.g. "stage1"
apply "stage 2" to the others