6 Replies Latest reply: Sep 30, 2016 7:29 AM by Christiana Olschewski RSS

    NPrinting - Specific Filter on Level or Calculated column with Table

    Christiana Olschewski

      Dear all,

       

      I'm currently struggling with one of my tables in Excel.

      I wanted to create a table which has next to it a calculated column AND  which has a specific filter which should not be applied to the other tables in the report.

      As far as I know this is only possible with Levels but not with a "normal" table (my formulas always get moved down by the number of rows the table is inserting).

      But it seems that I can't put a filter on a Level, at least this is not possible via the properties as in the table.

       

      What can I do in order to have a table which has a calculated column and which has a specifi filter on?

       

      Many thanks to you all,

      Christiana