Need help with my pivot graphic

Hey, I'm currently making an hour registration for my colleagues (I'm a trainee).
I have a table with following columns: name, function, task, date, weeknumber, total hours spent.

I would like to make a pivot table (for dashboard).
I would like to make a comparison like this: total hours spent on each task/person
total hours spent on each task/person.

For each person I made a different drop-down menu, with their own, specific tasks. However, when I add them to the pivot chart and when i make a pivot graph, using a filter for one function, all tasks are shown in the legend (instead of specifically that one function).

When I use a slicer (for function) on the pivot graph, the range doens't change, which is probably the reason why it also shows are tasks, that are not linked to the function. I added a picture.

Hope you can help me, feeling quite desperate now.

FYI: also added the document itself, yes it's in spanish, but it's quite the same.

QUESTION: Might the reason be that I'm using Office 365 for Mac instead of Windows?

Hi Nyltiak95,

I don't think that Pivot Tables support what you're trying to do.

Could you mock up a dummy example to show what you want the pivot to look like as you need it to be?

Thanks