Counting Feature

[Ishilad]

Hi I have a quick question.

I am currently working on a sheet with a series of projects listed. Each project has a number of people working on it. I have the project names and the people who are working on them as Dimensions on a pivot table. I need to add a column that allows me to count how many people there are working per project. I tried using the aggr() function, if statements, in addition to a few other features. I cannot seem to figure out how to do this. 

[Ishilad]

Maybe it has to do with my data then. I'll take a closer look. Thank you!

[Ishilad]

This formula works, but it also factors in the '0' values. I went into add ons and exluded values that are 0 but this does not seem to make a difference.

[Ishilad]

This formula works, but it also factors in the '0' values. I went into add on's and excluded values that are 0 but this does not seem to make a difference.

[dplr-rn]

i am assuming the resource name column will be null for those.
exclude null for that dimension

[Ishilad]

The null values in the dimensions are excluded as well

[dplr-rn]

hard to help further without access to your app