Spotfire Personalized link with just one table

Question

I have a table with usernames, country and the sales data, all this in one table.

How can we restrict access for users based on country using personalized information link.

I saw some tutorials with multiple lookup tables, but unable to locate one which uses only one table data.

Answer 1

In your information link, use %CURRENT_USER% as the Value under the Filters box for the column which contains the username. Or, if you are using a procedure, it would be for an input parameter.