How to insert "countblank" function in my Pivot

[Excelsemi]

Hello all

I have tried to search posts and google, maybe it's because I'm totally new to Pivot that I don't know what to look for, sorry if this has been posted a million times, as I said I have tried to find a solution.

However, my problem is I have a data set, with 20-30 coloums and 3500 ish rows - in here I have to get different kind of information on each coloumn.
One of them is Missing Values, that is cells that are blank in the specific coloumns, I know I can just use the countblank function and then just put in the number - but how do I do it if I want the formula to appear "inside" my pivot table, so that I have this range of data, and I want to calculate how many blank cells this specific coloumn have.

So my question is: Is possible to add the formula to my pivot table/data and get it to show next to the other information that I require on the different coloumns?

Thanks in advance.

[judgeh59]

I have not used them much, but I would look up Calculated Fields --- I don't know if will help you but it would be where I would start....sorry I don't much experience with them....maybe this is my chance to learn...anyway check it out....HTH

[Excelsemi]

Yea I looked a bit into that, but I couldn't figure out how I applied a formula to a coloumn I had in my Pivot..
Is it just me or shouldn't it be easy to choose a data range and apply a formula once it's already in the pivot?

[judgeh59]

Me Either....yes, it should be, but there are a lot of issues doing it that way...would it help to upload some data so we can get an idea of what we are looking at....and remove any company confidential data

[Excelsemi]

Me Either....yes, it should be, but there are a lot of issues doing it that way...would it help to upload some data so we can get an idea of what we are looking at....and remove any company confidential data

Can't really upload anything but what I need is the same for something like this, so countblank and count unique values, lenght of characters

then just for a much larger dataset