Hi all,
So I have data for multiple countries based on the share of population number as per different income bands (US$0-500, US$500-1000, ..and so on until population with income of US$250,001+). I need to setup a dynamic summary dashboard with threshold income values using data validation. E.g. if for one country e.g. USA the threshold is US$30k, it returns the sum of population with income of more than US$30k. I know this can be done using SUMIFS by including a new column against income bands for those more than and those less than US$30k, using the criterias.
But what if the threshold needs to be set as dynamic, and it should return the sum of population numbers with more than the threshold set up validation e.g. US$10k, or $20k or $80K.
Thanks in advance for the help wonderful community members
Bookmarks