I'm using SP 2010. I have a few lists that have many of the same set of Choice columns. I want to be able to output a running total of how many there are of each choice from all lists. Maybe in a column in a separate list? The idea is to have a master list that totals out data aggregated from other lists.
ListA has 3 items where ChoiceA was selected.
ListB has 4 items where ChoiceA was selected.
My output in the master list will show something like "ChoiceA = 7"... and so on.
It seems like a calculated column won't help me here because I am working with many lists and primarily with text values. I could be wrong though.
What is the best way to achieve this?