I have a database from which I am trying to get information, similar to the table below. I have created a pivot table to give me the number of accounts with each bank using Count(Distinct Account). However I am having trouble creating another column beside the total for each bank which shows the percentage of the total number of accounts. The second table shows what I am trying to do. I can't seem to find any other query on the forum which covers this. Any help would be much appreciated.