How to filter the data.

[Anonymous]

Hi ,

I have managed to filter the data in this scenario where my requirement is to pull only the "Live service attributes" and their "totals" for the respective months.

I have used the expression only to pull the "Live services" onto the group name without 'Test service' which is not required.

I have managed to some extent on the group name showing only the Live services but How to stop the Test service attributes in the rest of the attributes and their totals.

Here is the file I am working on.

• First Pic shows all the data in the Group name Including Test service which is red rounded circle having the service id's.Only the green is the one we are interested.
• Second Pic shows in the group name only showing the Live services that starts with number 272 attribute. but you can see those total value for the service attributes is not changing even after filtering the data.

Dont know where i am doing wrong or Am i missing something.

Let me share the expression I have used.

"=if(not WildMatch(service_name, '*Test*'),group_name)" n Group_name dimension.

Any help is really appreicated.

thanks.

[Anonymous]

I will do that viswa in next 10 mts.

Thanks.