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.

[xyz1]

let me know if it works.

[Anonymous]

No It is not working .It is pulling all the data including TestService.

[xyz1]

.

[Anonymous]

I have already used that expression which is working pulling the Live services but my issue is that expression is not stopping the test service attributes coming on to the pivot table.

[Anonymous]

Hi Vamsi,

There is nothing wrong with your expression. Check "Suppress Null Value" for your dimension in chart properties will solve your problem.

[Anonymous · Accepted solution]

Hello Vamsi,

Try this. Suppress Null values for your calculated dimension.

[Anonymous]

Brilliant.Thanks vishwa.I was breaking my head on this since morning.

That thing changed the figures though not sure if it is wat my PM wanted.

But thanks for your help.

[Anonymous]

Hi Vamsi,

Please mark it as helpful if it solved your issue. Thanks.