Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Percentage in Pivot Table

Hi

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.

Thanks,

Iain

Account Bank Name
22 Bank A
23 Bank B
24 Bank A
53 Bank C
25 Bank A
85 Bank C
46 Bank A
84 Bank B
36 Bank D
10 Bank A
13 Bank D
16 Bank B
33 Bank D
49 Bank B
54 Bank C
62 Bank A
78 Bank D
95 Bank B
72 Bank D
64 Bank C

Bank A 6 30%
Bank B 5 25%
Bank C 4 20%
Bank D 5 25%
Grand Total 20
1 Solution

Accepted Solutions
alexandros17
Partner - Champion III
Partner - Champion III

The expression you need is:

Count(Account)/Count(TOTAL Account)

let me know

View solution in original post

3 Replies
alexandros17
Partner - Champion III
Partner - Champion III

The expression you need is:

Count(Account)/Count(TOTAL Account)

let me know

Not applicable
Author

Well that was simple.

Thanks for your help

alexandros17
Partner - Champion III
Partner - Champion III

Could you please mark the answer?

Thanks