6 Replies Latest reply: Jun 7, 2017 8:26 AM by MARCO HADIYANTO RSS

    IF condition with date

    Zied Ahmed

      Hello,

      in a pivot table I have a date like 01/01/2017

       

      i need an expression like this

        if (Dimensionality()=1,' ',

      (if (Dimensionality()=2 and date>'01/06/2017',

      'Hello'

      )))

      But it doesn't work (when i delete the condition of date it display hello...

       

      regards