I have data stored in SQL Server 2008 and I use Pivot Table (Excel 2013) to generate some reports. Sometimes I want to apply a filter to a specific column based on a field from another worksheet or simply from another sheet, because there are a lot of elements to select and the better way I guess is to use a filter based on my other sheet. Do you think is possible to do use using Excel ?
Thank you