How to show percentages in pivot for each column value?

[#1]

Hi,

I have pivot chart data as below in qvw.

Flag	MONTH	Grand Total	Oct 2013	Nov 2013	Dec 2013	Jan 2014	Feb 2014	Mar 2014	Apr 2014	May 2014	Jun 2014
ALLOW		1176	8	53	30	32	17	36	36	49	28
NOT ALLOW		783	5	34	30	29	15	28	31	39	16
ENTER		84	2	15	9	3	2	6	5	5	6
AUDIT		322	1	4	8	1	3	3	13	5	5
CONVERSION		373	2	16	9	4	2	8	5	9	8

I need the pivot chart data should show the percentages also. so, need output as below

Flag	MONTH	Grand Total	Oct 2013	Nov 2013	Dec 2013	Jan 2014	Feb 2014	Mar 2014	Apr 2014	May 2014	Jun 2014
ALLOW		1176	8	53	30	32	17	36	36	49	28
NOT ALLOW		783	5	34	30	29	15	28	31	39	16
NOT ALLOW/ALLOW		66.00%	62.50%	64.15%	100.00%	90.63%	88.24%	77.78%	86.11%	79.59%	57.14%
ENTER		84	2	15	9	3	2	6	5	5	6
ENTER/ALLOW		7.14%	25.00%	28.30%	30.00%	9.38%	11.76%	16.67%	13.89%	10.20%	21.43%
AUDIT		322	1	4	8	1	3	3	13	5	5
AUDIT/ALLOW		27.38%	12.50%	7.55%	26.67%	3.13%	17.65%	8.33%	36.11%	10.20%	17.86%
CONVERSION		373	2	16	9	4	2	8	5	9	8
CONVERSION/ALLOW		31.72%	25.00%	186.67%	30.00%	12.50%	11.76%	22.22%	13.97%	18.37%	28.57%

can anyone suggest me how to calculate the percentages to show at the bottom of each value.

Thanks.

[#2]

the expression I have used is Count(ID).

actually the requirement is to calculate count of IDs in each month. so, I have used this.

is there anything wrong I used?

[antoniotiman]

Do You have link between ID and MonthYear ?

[Digvijay_Singh]

This is certainly helpful to learn complex functions, Since I have personal edition, I tried to replicate the expression. Can you pl help me to know what mistake I did in replicating it. Showing exceeding memory in chart. Sharing QVW herewith.

[antoniotiman]

This is my script

CrossTable(MONTH, Value)
LOAD Flag,
[Oct 2013],
[Nov 2013],
[Dec 2013],
[Jan 2014],
[Feb 2014],
[Mar 2014],
[Apr 2014],
[May 2014],
[Jun 2014]
FROM
"https://community.qlik.com/message/838385"
(html, codepage is 1252, embedded labels, table is @1);

See Dimension and Expression in Post.

Regards