Sub total issue

[mohamed_ahid]

Hi every body,

I'm working on a pivot table like this :

Level	Canal	Cost this year	Cost last year	Weignt
RENAGEL	HP	4865	5641,65	46.22%
	MT	3506	5641,65	33.31%
	GP	2154	1927,8	20;46%
	Total	10525	1927,8	100%

for facts columns i used this formulas :

Cost this year : set analysis over Cost column using a varibles which returns this year number :

 

=sum({<Level={'level1'},Year={$(=year_n)}>}cost) 

Cost last year : same thing this the formula :

=sum({<Level={'level1'},Year={$(=year_n-1)}>}cost)

my question is what is the formula to calculate weight like in the  table ? 

exmple : 46.22%=(4865/10525)*100

THX

[stevelord]

I see assumed answered, but had one more neat trick to contribute.

Just make another column with the same expression, then check the 'relative' box and set totals mode to 'expression totals' for that expression.  (These options are on the expressions tab.).  That's if you want one column for the counts and one for the percentages.  You could just check the relative box on the expression you have to make it go to percentages.