Create separate calculations for contains() REC and NOT contains() REC:
REC: if CONTAINS([Description], 'REC') then [Description] end
Non-Rec: if NOT CONTAINS([Description], 'REC') then [Description] end
Then create a CASE statement for your parameter calling the new calculations above:
Hope that helps!
Thanks for your reply.May be i am not clear in explaining the requirement.I am not using Description field in the view and i am just using sum(no of records).
I have attached packaged workbook.Could you please check and help.
I am trying to use as below in calculated field and use it in filters but its not working.
if [Select]='REC' or [Select]='Total'
I am happy to send if any more info is required.
Please attach workbook
i have attached it to the initial post.