This content has been marked as final. Show 3 replies
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.