Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a field of 5 item. how do i tie each item to a text or button such that if i click on any it will exclude it from my selections and change the color?
i can also use listbox if its posible to exclude with it
Create 5 buttons ans variables for values you want to exclude
Set action Set Variable
and in expression right something like
Sum( { < [Department] = {'*'}-{$(=$(Department01)),$(=$(Department02))} > } Sales)
This will only complicate things unnecessarily , what are you trying to achieve.
Why not stick with a ListBox with selection style as LED Check box,
Hi,
Please see attached.
Select 1 or multiple items that you want to exclude and then hit the exclude button.
Button > Actions> Add > select excluded > Field = YourFieldName
Hope this helps!
Why i cant use listbox is by default when u select an item it filters based on your selection, what i want is when i select it should exclude the item selected
Clear?
This not it. I have a stack bar chart and i have a field holding 5 items in the stack. i want to use a listbox or buttons to select what i wanna see in the stack
have you tried above solution
You can try this with list box selection:
If(GetSelectedCount(Item) = 0, Sum(Measure), Sum({<Item = e(Item)>}Measure))
Hi Emma,
It should work with a stack as well. See updated app attached.
OK, I am trying to understand the use case here
Making an exclusion from a selected field is going to be a two step Process
1) You make the user select a value to exclude
2) You make the user click on another button to confirm the action(Action > Select Excluded )
Another Approach , Is a Single step process for the USER, Where user makes only one selection and
you modify expressions to exclude selections, like stalwar1 has demonstrated below.
Your choice!!