I have a table that looks like:
id aff1 aff2 aff3 value
1 a x b 5
2 b c x 4
3 a b g 1
I would like to aggregate the aff columns to calculate the sum of "value" for each aff. For example, the above gives:
Ideally, I'd like to do this directly in tableau without remaking the table by unfolding it along all the aff columns.