Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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.
Does this do it?
FirstSortedValue({<VPVUIT={1}>}STREEP,fabs(STREEP))
Regards,
Chris.
try something like this
aggr(max({<VPVUIT={1}>}STREEP),Artikel) this will return the appropriate value of STREEP
Hi Chris,
Unfortunately no... I get a NULL result, thanks though.
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!
Weight in Requested Result should be 304 of course...
whats your expression for weight?
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.
The app is too big and sensitive to send. I'll try to make a workable version. I'll get back to you asap.