our customer requested to have two navigation cells pointing to two different pages in a summary table.
Example use case:
- User wants to have an overview of processed materials in a summary table
- There are two categories: Purchased and produced materials
- One material can belong to both purchased AND produced
- User wants two drilldown columns to decide whether to see the details for the produced items or the purchased items (schema of the details tables differs)
I tried specifying the go to page via a variable but since there is only one line per material in the summary table, I did not manage to reach a distinct value on column level…
Does anybody have an Idea how to make this possible?
Thank you a lot!