How to Calculate Percentage off Custom Filtered Dataset
I'm building a dashboard off of a large dataset and would like the bar charts to display a percentage of the total filtered dataset. The users will be able to adjust the filters so how do I build a function to calculate a subtotal off of the selected dataset?
Using made up numbers, I entered what I would like to show; the market share attributed to each entity by year. So 2020 in red is capturing 20% of the filtered dataset for 2020, competitor A is capturing 5% of the filtered dataset for 2020, etc.
Any assistance you can offer on how I can accomplish this greatly appreciated.