If i understand you correctly, you may want
to put each Step on a distinct worksheet,
then combine them all on a 'Sankey' dashboard --
together with some other ('flow') worksheets in between.
For that you'd like to have all Steps (Dimension Values)
on a view unfiltered, and use a Table Calculation Filter instead.
Please find the attached w/mods.
Hope it could help.
Sankey.PivotData_v10.5_YF.twbx 171.3 KB
Excellent! How did you make the filter?
1 of 1 people found this helpful
Create a new pill right on a view -- for example,
by double-clicking in Rows / Columns / Details --
then write a calculation and hit Enter.
The calculation itself is rather simple:
It is a Table Calculation, and as a Filter,
it is effectively hiding the Marks on a view --
not filtering them out -- thus preserving
any other Table Calculation based logic.
To have this calculation as a distinct Pill in the schema,
simply Ctrl-drag a copy from the Filter shelf to the Measures.
Hope it could help understanding.