removing specific fields in a pie chart?

[knightwriter]

Hi friends,

How do I remove a specific activity type from my pie chart? Thanks.

[anguila · Accepted solution]

You could remove it from your dimension.

So in the dimension tab:

if (Activity_Owner.BusinesGroup<>'IT',Activity_Owner.BusinesGroup)

Then check  the supress when null value checkbox. Thus, you're choosing as your dimension everything but IT.

[rubenmarin]

Hi Stephen, you can use set analysis, ie:

TextCount({<Activity.Type-={"IT(Name of the activity to exclude)"}>} Activity.Type)

or

TextCount({<Activity_Owner.BusinesGroup-={"IT(Name of the activity to exclude)"}>} Activity.Type)

It will show an error on expression but it should work.

[knightwriter]

If I do more than 1 in the legend ie 2, it now shows the 2 fields that ive only excluded as opposed to the ones I want! What steps are next? Thanks.