Percentage done column

Hi there all

I am not very good at pivot charts yet.. Therefore I ran into this problem..!

The problem is as follows:

I have table 1, as shown below, Where I have different tasks, which I give an "1" for "done" and a "0" for "not done.

Now I want a pivot table and then a chart, to show how far I am, divided into column "A" and/ or "B" columns, so that I can see the status on how far I am on my tasks, for instance for "Ventilation".

So here I want the table to show how many percent I have, marked "done", for that "Theme".. At the moment, there is 1 task that is "done", and one that is "not done". Therefore the table should say 50% "done".

Excel pivot problem.png

But when I make my Pivot table, with column "B", and make it either "sum" or "count" and then show as percentage, it does not show 50%.. ?

Can anyone please tell me how to do this..? HELP