3 Replies Latest reply: May 18, 2012 1:36 PM by Jay Jethwa RSS

    Help with Aggr Function?  Market Share.

      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