7 Replies Latest reply: Oct 16, 2018 5:23 AM by Steven Piers RSS

    If value = minimum value and value = .. then

    Steven Piers



      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!!