3 Replies Latest reply: Dec 16, 2014 6:27 AM by Tibor Sebok RSS

    Pivot Table (how to apply conditional to dimension)

    paulo costa

      I have a Period list and a Pivot Table that uses this dimension. When selecting more than one Period, I would like to see only the last selected one at the Pivot Table, but the total column should consider all selected Periods. I´ve made a conditional expression  for Period dimension but it´s not fine.

       

      [Período DRE]=right(getfieldselections ( [Período DRE] , ',',100),7)

       

      See the attached file.