How to Calculate Percentage off Custom Filtered Dataset

[kdstrin1]

Hi-

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.

Thank you

[Venkadesh_Ponnu]

Do you want to show contribution in BarCharts only? Otherwise, Tree map is also very helpful in such scenario.

[kdstrin1]

Yes, i would like to show it in a bar chart as i'm recreating a view currently used through manual data manipulation in excel