No i cannot delete them..
I purposefully created this row for some other calculation requirement.
I only want to hide this row.
I can make its text color as White by checking if condition,but still blank row appears.
Please help me how can i hide the same or for workaround is it possible to make height of this column as zero using macro.
I can not use above stated expression for sum, because it will filter records of table depending upon that condition.
i dont want to filter records , i only want to hide the row...
i have trieid setting background color of the same.. but still the blank row displays.