Summarize Report Function with Dropdown Menu Selections
I am looking to determine the instances of a particular dropdown value entered into my sheet by using the report function with the summarize feature in order to determine, based on the weighted value, how large a portion of total any one category may hold. Easily thought about as a pie chart. My dropdown values would be the slices of pie and the weight of each instance of a dropdown value being used would be added to the pie with the corresponding weight determining the size of the slice in relation to the other pieces already added.
Hopefully, that is explained well enough! Thanks and looking forward to getting this solved.
Help Article Resources
Check out the Formula Handbook template!