How to Sum off categories inside a column

[#1]

Question -

I have some HR data coming in and I need to create a chart that shows the sum of all IT Team Members.  Currently my data is coming in as follows.  How can I create a chart that shows only the count of IT-Team Member?  I also have a month field that would be used as my Dimension.

Person Type	Count
Team Member	30
IT-Team Member	5
IT-Contractor	2
Contractor	10

[#2]

I guess the better question is how can I write the expression, I know how to create a chart....

[#3]

How many members are there in the IT team. If it is not a lot then you can hard code them in set analysis.

Thanks

[#4]

At the moment there are 200 or so but it changes every month.

[#5]

I mean how many person types.

[#6]

There are only 4 different person types.  Team Member, IT-Team Member, IT-Contractor, and Contractor.

[#7]

count({<[Person Type]={'IT-Contractor', 'IT-Team Member'}>} [Person Type])

[#8]

That is close but that returns the count of the appearance of IT-Team Member and IT-Contractor.  I need the sum of the count field for every line where the person type is IT-Team Member or IT-Contractor.  They could be separate from each other.

[#9]

I think this might be it.

Sum({<[PersonType]={'IT-Team Member'}>} [CountOfTEXID])

[#10 · Accepted solution]

Or Sum({<[PersonType]={'IT-Team Member'}>} [Count])