Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
Use
YearField=
in expression.
Ex: Sum({<YearField=>} Sales)
The above expression excludes YearField selection.
Hope this helps you.
Regards,
Jagan.
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.