Set analysis problem

[#1]

I thought this is simple but somehow i'm doing something wrong!

i attached my QVW and a excel file. The excel is what i'm trying to get.

[#2 · Accepted solution]

this is the excel file

[#3]

Hi

Try this

=

Sum(Real)/sum({$<Periode={'1'}>}total Norm)

Regards

Benoît

[#4]

Change the expression:

=Sum(Real)/TOP(TOTAL sum(Norm))

[#5]

thnx both suggestions work, but i go for the last solution!