% sum of Total Expression

[#1]

Hello again,

What i have:

Dimension is(or should be) variable, employee Nr. The table has 3 Expressions(sum amount, % GP,..) Also i have this expression that gives me an headake:

sum({<[Know How]={1}>} LINEAMOUNT)/sum(TOTAL {<[Know How]={1}>} LINEAMOUNT)

It gives me the % part of sales amount of the Total sum. Its nice and the right formula when i do not select(filter one employee).

Example(with all employees, what i have):

employee     % in total sum

2                    2,58%

3                    1,45%

Example(with one employees, what i have):

2                    100%

What i want/need:

I need the formula(if it is possible), when i select one employee that the % part of total sum does not change.

Example(with one employees, what i want/need):

2                    2,58%

Thank you ver much for your time.

Greetings,

Kristian

[#2]

Nobody a idea?

sum(aggr(if(rank(sum({$<IDENT=,Datum_fakture = {"<=$(vDatum)>$(=AddYears(vDatum,-1))"}>} LINEAMOUNT),4)<=10,sum({$<IDENT=,Datum_fakture = {"<=$(vDatum)>$(=AddYears(vDatum,-1))"}>} LINEAMOUNT)),IDENT,KOM))

This is the code i got, but should never change even if i select a KOM. Now it sums for the whole, but when i select a KOM the sum is only for him. Total is wrong because it sums all from 2009, i just need the last 12 months(the formula gives it to me) fixed, so that it want change when i filter.

I hope somebody can help me.

Greetings Kristian