3 Replies Latest reply: Feb 24, 2017 9:32 AM by m s RSS

    Set analysis on dimension

    Akanksha Potdar

      Hi,

       

      I am trying to do set analysis on one of dimension. I am trying to get in pivot table, company names for only year=2017

      For Example:

      ONLY({<YEAR={'2017'}>}company)

       

      This is simple code, but I don't know why its not running. It's showing me invalid dimension. Please let me now what I am doing wrong or suggest any alternatives.

       

      Thanks