Exclude Yearselection

[#1]

Hi,

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?

[jagan]

Hi,

Use

YearField=

in expression.

Ex: Sum({<YearField=>} Sales)

The above expression excludes YearField selection.

Hope this helps you.

Regards,

Jagan.

[#3]

Hi Jagan,

I cannot apply sum since i want space instead of amount for the above group1 values,sum of space will not be shown in straight table.