Sales shares in Pivot

[#1]

I have a pivot table in which there are calculated sales of agents by brands and I want to calculate sales share of brands in total agent sales.

[oknotsen]

Are you using QlikView or Qlik Sense?

Based on that answer, we will move this question to the right section of the community.

Edit:

Question is ignored, so moving topic to QlikView section.

[sunny_talwar · Accepted solution]

May be like this:

Dimension:

Agents

Brands

Expression:

Sum(Sales)/Sum(TOTAL <Agents> Sales)

[#4]

It works

Thank you a lot