2 Replies Latest reply: Jun 11, 2012 2:22 AM by JATIN KOLHE RSS

    Exclude Yearselection



      if(TRIM(Group1)='Cash Flow From Operating Activities:-' or TRIM(Group1)='Change in C/A' or TRIM(Group1)='Change in C/L' or TRIM(Group1)='Cash Flow From Investing Activities:-' or

      TRIM(Group1)='Cash Flow From Financing Activities:-' or TRIM(Group1)='Summary of closing cash',' ')


      Above is my expression where if these group1 values are in the dimension then instead of amount it will show space since they r headers/titles,

      Problem is when i filter using year ,all these group1 values does not show in straight table since there r no dates for these group1 values,

      how to exclude year selection for all these Group1 values?