If value = minimum value and value = .. then

[stevenpiers]

Hi,

I'm looking for a proper expression for the following issue:

I have a list of items (30.000 + rows and counting...) for which I know what kind of packaging it is (column STREEP) and if I want to publish it (column VPUIT)

For the minimum absolute value of STREEP and with VPUIT value 1 I want to show the articles in a pivottable. So for my calculated dimension I'd like to have this expression.

The yellow marked cells in the sample file should be the result

Is there anyone who can help me out? Thanks in advance!!

[chrismarlow]

Does this do it?

FirstSortedValue({<VPVUIT={1}>}STREEP,fabs(STREEP))

Regards,

Chris.

[dplr-rn]

try something like this

aggr(max({<VPVUIT={1}>}STREEP),Artikel) this will return the appropriate value of STREEP

[stevenpiers]

Hi Chris,

Unfortunately no... I get a NULL result, thanks though.

[stevenpiers]

Hi Dilip,

My result should be as below. Your expression does work but needs a little extra effort I'm afraid. Your help is very appreciated!

[stevenpiers]

Weight in Requested Result should be 304 of course...

[dplr-rn]

whats your expression for weight?

[chrismarlow · Accepted solution]

It appeared to work for me, but looking at the later posts there is more to your data model .

Attaching the app just in case it is of any use (I do have personal edition though).

Regards,

Chris.

[stevenpiers]

The app is too big and sensitive to send. I'll try to make a workable version. I'll get back to you asap.