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...
v-yadongf-msft
Community Support
Community SupportHi joshua1990 ,
Can you tell me what is your expected output?
Thanks for your efforts & time in advance.
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
- joshua1990
No ideas?