Pivot table showing a total and a percentage

[mayday1]

I have accounts which have sub accounts and each sub account is a separate row in my data. I need the "closed" percentage of each department in a Pivot Table.
ACCOUNT and STATUS are the column headings in my data

ACCOUNT, STATUS
acct#1, closed
acct#1, open
acct#1, closed
acct#1, open
acct#1, open
acct#1, open
acct#1, open
acct#1, closed
acct#1, open
acct#1, closed
acct#2, closed
acct#2, open
acct#2, closed
acct#2, open
acct#2, open
acct#2, open
acct#2, open
acct#2, closed
acct#2, open
acct#2, open

From these data I know how to do a pivot table that shows me total count of Account 1 and account 2. I can also get total of account 1 & 2 that are Closed. What I don't know is how to get a Pivot Table that shows me that PLUS the percent of each type of account that is Closed. Looking for output like this:
Acct#1 5, 10, 50%
Acct#2 4, 10, 40%

That last column has to be a formula somehow. I know how to get the Closed percentage of the total (in this example 5 out of 20 and 4 out of 20) but I need to show it as a percentage of each account type - as in each row of data.

 

[SpillerBD]

?
Maybe you are wanting "Show Value As"... "% of RowTotal"

 

[mayday1]

?
Maybe you are wanting "Show Value As"... "% of RowTotal"

That makes the value 100% for all rows

 

[SpillerBD]

Do you have Status as a Column field?
Otherwise you will have to PowerPivot (or PowerBI Desktop) to make the Pivot Table show this.