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

    If value = minimum value and value = .. then

    Steven Piers

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