Forum Discussion
joshua1990
Post Prodigy
Post ProdigyExclude columns in matrix from dimensional table
Hi experts!
I have a table that lists all articles (Article):
Article
Date
Value
A
01.01.2022
500
B
01.01.2022
600
C
01.01.2022
400
Then I have...
joshua1990Post Prodigy
Post Prodigyv-yadongf-msft : Thanks for your support.
In the end a matrix should be displayed in this way:
| Article | Order | Process Step 01 | Process Step 02 | Process Step 03 | Process Step 04 |
| A | 1 | 50 | 50 | 0 | 50 |
| B | 2 | 50 | 50 | 50 | 0 |
In columns we have Process Step XX.
But here I would like to exclude all Process Steps that are not part of Tabl Routing and the selected Articles.
Just necessary / applicable Process Steps should be displayed.
joshua1990Post Prodigy
Post ProdigyNo ideas?