Show value if specific value in other column

[#1]

Hey guys,

Small question concerning a pivot table.

I have got a pivot table with the following columns:

dimension "ordernumber" || dimension "article"

Basically, I need all the order numbers that contain the article "x".

So if the second column contains "x" it should show the ordernumber, AND all the other articles that were in this order.

If the order does not contain the value x, I do not want the see the order nor all its articles.

Why I am stuck, I cannot just use an expression with article = {'xtrans'} because it would then show me the article xtrans, but hide all the other articles in this order.. See my problem?

Thanks for the help!

[tresesco · Accepted solution]

Is this what you want? PFA.

[#3]

Yes that's the one!!

So now it shows me 111 and 133 since they both contain the value x1. Awesome!

One last addition though.

If I add another dimension "description", how should I add this to this calculated dimension?

[tresesco]

If it's a description of the article, then simply add that dimension after article. If it is the description of orderno, then use :

Aggr(Only({<Ordernumber=p({1<Article={'x1'}>})>}Description),Description)

[#5]

Great, thank you so much for your help and quick replies!!