Percentage in Pivot Table

Thu, 22 Jan 2015 11:24:01 GMT

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

Re: Percentage in Pivot Table

alexandros17 — Thu, 22 Jan 2015 11:27:40 GMT

The expression you need is:

Count(Account)/Count(TOTAL Account)

let me know

Re: Percentage in Pivot Table

Thu, 22 Jan 2015 11:33:36 GMT

Well that was simple.

Thanks for your help

Re: Percentage in Pivot Table

alexandros17 — Thu, 22 Jan 2015 11:36:17 GMT

Could you please mark the answer?

Thanks

topic Re: Percentage in Pivot Table in Qlik Learning Discussions

Percentage in Pivot Table

Re: Percentage in Pivot Table

Re: Percentage in Pivot Table

Re: Percentage in Pivot Table