0 Replies Latest reply: Sep 26, 2013 4:02 AM by CRISTINA TALMACIU RSS

    not collapsed calculated dimensions

      Hi,


      I have a pivot table with expanding columns and one calculated dimension (PY Price). The user needs to visualize the calculated

      dimension for all levels even if he collapses one of the level. My problem is, when I collapse one column, the calculated

      dimension - which is the last column in the table - disappears because it behaves as a dimension in a pivot table.
      (see the enclosed file).
      What should I do in order to always visualize the calculated dimension? Consider that I can't transform it into an

      expression because on horizontal I have the detail for Month and it would split it into months

       

      Thanks

      Cristina