I am a new user and have searched and read many post, but cannot seem to get a solution that works.
I have an excel list that I would like the user to select a value from a column.
My sample excel data looks like:
Collector Balance
Kermit 10.00
Grouch 20.00
Chef 1,000.00
I attached my test...I am getting all records even if I select just one when running as app.
If the user selects Kermit I would like the result to be only for Kermit.
Thank you for taking the time to review.
Solved! Go to Solution.
Ok, so try do this:
You're trying to use the sort, that tool just to sort of the records, to you get part of the records only, based in something, need to use filter tool.
Hope that helps!
Thank you!!!
Hi @Gbergero
The reason why you would be getting blank is no value is matching
Basically in your previous app you were getting value Collector which you are not supposed to because Collector column doesnt have value collector.
I made changed in crosstab tool and deselected Collector column. You will have only values. Now you will result.
Hope this helps 🙂
And yeah @marcusblackhill point too you were using sort tool instead of filter tool before