Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Do you want to show contribution in BarCharts only? Otherwise, Tree map is also very helpful in such scenario.
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