I have a sql view linked to my dashboard with session speciality, I also have a spreadsheet linked in by speciality. I only want the dashboard to show information regarding the specialties that appear on the spreadsheet. I have managed to get the list box only looking at the excel spec but some other fields in the dashboard are still taking into account the other specs. How do I exclude the certain specs from the whole dashboard?
Do I do a where clause saying :
where speciality not in ('1','2','3' ... etc) Will that filter out any information to do with those specs?
