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...