I see you've attached a sample data source. It would help if you attached a sample Tableau workbook with what you've tried so far.
Hello Amanda - I have attached a sample workbook for your reference. On sheet 1, you will observe the condensed raw data in its simplest form (i.e. Sales for each competitor, in a particular quarter for a specific category). my goal is to calculate competitor market shares in each of these quarter/categories.
As a next step - I would like to only keep the competitors I am interested in and remove others from the view, without affecting their market share calculation.
Market shares workbook.twb 38.2 KB