multiple filters

We have an Excel sheet that is a database of tasks used to manage work assignments for about 10 people in the office. As it is today, a staff member can click on a control on the sheet with their name and the list will filter out blank records, displaying to them just their tasks that are not in...

Hi, I am trying to work out the DAX to calculate the average time taken to fill a specific type of vacancy from my data source ‘CSD Archive’ To do this manually I would set filters on the following columns: ‘% Filled (Static)’ to 100 ‘Route’ to 1.GRS To work out the average I would then...

I have a report that we are trying to filter for the top/bottom reps for each manager. Even if we filter for the manager name first and then apply the top/bottom 10 filter built into excel it is only returning the top/bottom 10 based on the entire worksheet. Is there an easier way to look at...

Hi i have been Searching the internet for some time to try use multiple filter criteria on a pivot table. i am able to apply one of the criteria but as soon as i try and combine them it fails to pick up the second filter. If I do not filter both then there are instances where the top 10 results...

Hello all - I have the following problem: I have a pivot table with thousands of products and all their info. Each day, sales makes deals with different pricing for each customer. Operations then uploads the new price for the particular customer and send us the products affected. Today for...