Hi, how to do % calculation over dimension in pivot table, please help ASAP.

[#1]

ex:

Status	Week	W1	W14	W13	W28
Deleted		2504	7008	19	240
Pending		204	32	-	-
Proposal   Submitted		15634	46548	339	9599
Total		18342	53588	358	9839

eo/p should be like this

Status	Week	W1	W14	W13	W28
Deleted		2504	7008	19	240
Pending		204	32	-	-
Proposal   Submitted		15634	46548	339	9599
% Submitted		85
Total		18342	53588	358	9839

[Anonymous]

do the following

1. add dimensions like Status , deleted,pending,proposal submitted to your table

2. in expresioon tab  [Proposal submitted] / [Submitted]  (remember it should be in blue color which is correct)

3. go to Number tab select Radio button Integer and mark check box show in percent .

anant

[sujeetsingh]

See the sample and also go to the script for it