Help with Aggr Function? Market Share.

[#1]

I've built a pivot simialr to below and want to calcuate our share of the market.  I've ried mutiple AGGR funcitons but cant seem to crack it...so requesting some expert help

In the AGGR column, I'm expecting the Competitor total in the first 3 cells (366,496), and then the Internal products total in the following 3 (43,538).

Any help will be appreciated.

Thanks, Jay

[swuehl]

If I understood correctly, try this for the share:

=sum(Amount) / sum(total<Ownership> Amount)

[Jason_Michaelides · Accepted solution]

Try Sum(TOTAL <Ownership> Sales) obviously replacing Sales with your own field.

Hope this helps,

Jason

[#4]

Cheers Jason - Thats exactly what I wanted.