Please follow Ben sullins advice
if this doesnt fulfill your requirement then please ping me will tell you some other alternative
Follow my Blog:
Thank you for your assistance. However I don't think this is exactly what I need.
For example I have selected a profile for someone that works in British Airways - I then want to be able to see all the users that work in British Airways - just their names, job titles, locations and emails.
All of this data is stored in a subscriber table - I just want to be able to if I chose a user to be able to see exactly how many users we have in our database that also work in British Airways.
Hope that makes sense.
You're not able to just filter on the Location field? That would give all users in the selected location.
The profile that I have created is basically you search a user based on their email - just to see a whole profile of basic information such as full name, company, location etc.
This is already filtered by their email address.
I then want to say for example you are looking at the user, you decide you want to see all the users that are based in that company to be able to click the company name and for all the users from that company to be listed in a table.
Ok, understood, you should check out Action filters. Filter Actions
You can easily set up an action filter so when the user clicks on the row containing the profile information it will load another table containing all users within that company.
Create 2 tables (and perhaps these look the same, depends on the information you wish to provide) with one of these being filtered by the email address.
Put both tables on to a dashboard, go to Dashboard - Actions and create a filter action where the Source is the sheet filtered by email and the target is the sheet to filter by location. You're able to set up the filter action to work on click (Select) and you are able to have this target sheet blank (Exlude all Values) when no one is selected.
Thanks for this Andrew, I will try this now.
fingers crossed it works