Yes, I understand but if I do it that way then I will get all of the % Expended Values and I don't want that.
I need to be able to group the values as I mentioned before. I don't want the user to select from any value. I want to categorize them.
If I misunderstood what you were asking then I apologize.
check the attached qvw.
This solution has one small problem when you collapse the pivot table dimensions, the aggregated %Expended value will not work. It is supposed to work only when the table is fully expanded...
I've used the IntervalMatch function which can be kinda hard to understand for newbies. Let me know if you don't get it ...
Hope this helps
After looking back over your last post, I think I may understand. The second option may work for me. I am working on it now so I will get back with you if it works or doesn't.
I have marked your answer as helpful, but I still wanted to see if this can be done through the input box?
Thank you for your help I really appreciate it!!!!!
Did you put the script that I sent?
With this you will not need the input box nor the variable. Just select the field Show.
I've attached the solution. In this, you have two ways of filter the table:
- Grouping Show: Using the table Show that was created in script like I sent you
- Expended values: You can choose witch values you want to show.
Im really sorry if my english is not comprensible, Im from Argentina and only "practice" my english in this page!!!
Yes, I was able to create the list box with no issues just like you did. Thank you.
However, even though I don't need an input box, I wanted it that way. The final report will contain multiple variables in an input box and I was going to add this option there.
Can the Show field be linked to an input box? I will use your suggestion if it is not possible.
If you want, use the same variable: Variable1
Check that the input rules has the same values that the field Show.
Go to Document Properties, Triggers, Variable event triggers, find the Variable1 and select it.
Then, click OnChange Add Actions.
Now, Add, and Select in Field.
Search string: =$(Variable1)
Then, when you change the value of Variable1, their value will be selected in Show field.
I created the trigger for the variable, but when I select the value from the input box it is not working...
I entered the following under Listed Values:
When I went back to the properties, it changed to
What am I doing wrong?