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]

try something like:

Only({ordernumber=p({1<article={'x'}>})}article)

Edit: included '1' to disregard selection

[#3]

I do not understand the expression you have given me.

What does the "p" stand for? And the "1"?

[tresesco]

These are set analysis elements. Goto help and search for set analysis.

[#5]

Will do, but unfortunately it does not work..

It shows the p red underlinded..

[#6]

Think we had forgotten the $ sign. Adding this to the function the underlined p is OK now.

Other question though, I am supposed to pased this in the calculated dimension of "ordernumber" right?

Or where should I use this?

[tresesco]

Sorry, corrected expression :Only({<ordernumber=p({1<article={'x'}>})>}article). Try to use this as expression. If does not work, please share a sample app.

[#8]

The expression seems to be ok, but when I paste your function in the used dimension box, I get the "// error in calculated dimension"

I am now using

*the calculated dimension you told me, and

*the dimension "article"

Is that ok or am I using the function in the wrong place?

Thank you

[tresesco]

Request you to share the sample, that would minimize this loop, if you are worried about data security, please see this link

[#10]

Here is a file with my dimensions..

The funny thing is, it does give me a value for sales, but it does not want to show me the order numbers