This post explores an approach for implementing hierarchical selections in Tableau which can be used for filtering and highlighting.
Hierarchical Selections in Tableau
Previous_Value Table Calculation
The PREVIOUS_VALUE table calculation can be used to make custom versions of running sum calculations and generate comma separated lists of items. This blog gives an overview with these and other examples.
datavis.blog 