Pivot table Set Analyis Problem

[#1]

Hi,

I use a pivottable that looks like this:

salesperson s1 s2 s3
group
a1 10 20 30
a2 20 30 40
a3 30 40 50

I'd like to show a percentage for each salesperson over all salespersons for each group.
e.g.

s1 %s1
a1 10 16% (10/60)

how can I set this up.

tried with set analysis but failed. sum(amount) / sum({salesperson=}amount)

Someone an idea?
Thanks.

Aloah

[#2]

Hi Aloah,

see the attached example.

Good luck!

Rainer

[Miguel_Angel_Baeyens]

I'd try something like

Sum(amount) / Sum({< group = {"groupname"} >} amount)

[#4]

Hi Rainer,

thanks for your help. works perfectly. Can you explain me what "<group>" causes so that the formular works?

Aloah

[Miguel_Angel_Baeyens]

Hello Aloah, "<group>" references the name of the dimension or column.