-
1. Re: Is there any way to store the excluded values(excluded through action filter) in calculated field?
Jonathan Drummey
Mar 21, 2014 4:56 AM
See the attached. I set up 2 filter actions, one for each target sheet, then activated the Filter Action by clicking on something. This instantiates the filter action as a pill in the target worksheet, then I could click on that pill to open the Filter dialog, and change it to an Exclude Filter:
Note that if you haven't selected anything for the Filter Action, then that Exclude button will be grayed out:
And here's a simple dashboard:
Is this what you were looking for?
Jonathan
-
2. Re: Is there any way to store the excluded values(excluded through action filter) in calculated field?
Thanks Jonathan,
You done great work, but i'm looking little bit different. I need to show included and excluded values in one sheet and not in dashboard. In my whole workbook i have only two sheets and one dashobard. one sheet contains values 1,2,3,4,5. and in another sheet i need to show "You selected 1" and "You not selected 2,3,4,5" if user selects 1 in action filter. I hope you understand my problem now . Thanks for the work you done.
-
3. Re: Is there any way to store the excluded values(excluded through action filter) in calculated field?
Jonathan Drummey
Mar 21, 2014 1:42 PM
Filter Actions are passed as regular filters on dimensions to the query to the data source, they remove data from the view, so you can only get one set of data back in a worksheet (the inclusions or exclusions). The only option I can think of to have just two worksheets (one for select, one for results) is to use a Highlight Action.
