Aggr() Question

[Anonymous]

Hi,

I'm fairly new to qlikview and struggling to implement the following chart.

I started using aggr() function hoping that would be helpful, but it doesn't give the results that I need.

This is what I'm trying to implement:

When I use =aggr(sum(Sales)/sum(TOTAL Sales),Team, TeamMember), I get this:

Any advice would be appreciated. Thanks in advance.

[rubenmarin · Accepted solution]

Hi Shobana, I think you only need this:

sum(Sales)/sum(TOTAL <Team> Sales)

[Anonymous]

Thanks a lot Ruben, that worked!!!