Pivot Count Values greater than zero

Hi All,

How do i count value which are greater than zero in pivot table.

Thanks in advance.

regare

Use calculated field with if combination.

Hi Suresh,

You wish to count values already present in pivot table or
you wish to count values of a data table using pivot table ?

Regards,
DILIPandey

<click on below 'star' if this helps>

Okay..
lets take an example, You have a pivot in column A,B,C and you need to count the values >0 from column C.. correct?
so it would be simply countif function in a cell (lets say D1) .. no matter you reference a data table or a pivot table.. additionally you can use a defined name to get range correctly every time. If you have some other point, please upload a sample workbook. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

Okay..
lets take an example, You have a pivot in column A,B,C and you need to count the values >0 from column C.. correct?
so it would be simply countif function in a cell (lets say D1) .. no matter you reference a data table or a pivot table.. additionally you can use a defined name to get range correctly every time. If you have some other point, please upload a sample workbook. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

Hi Sixsense,

Can you please help with the attached file.
In count of balance i need count which item balance are >0

regards,
suresh

Hi Dilip,

I have uploaded the sample file.
In count of balance i need count which item balance are >0

thanks,
suresh

Do a google search with the Keyword Using Calculated Fields In Pivot Tables or click the keyword which will show you lot of links about it.

Hi,

The answer is you must filter out the individual values that are zero. See the attached. It has nothing to do with a calculated field or item.

It has nothing to do with a calculated field or item

Without seeing the OP's Pivot Structure, it is meaningless in quoting the above sentence

The OP posted the workbook in the first post. I bet they edited it and put it in after you guys tried to imagine what the question was.

@MarvinP,

When the OP posted the initial thread at that time there was no excel file was provided, now the OP edited the initial post and totally changed the content and replaced it with new text and added an excel file.

Did you just change the question with this new attached example? What do you expect the result to be?

@6 - I've seen people add an attachment onto the original post. They don't know it doesn't make sense to our top to bottom logic.

Originally Posted by MarvinP

They don't know it doesn't make sense to our top to bottom logic.

Agreed...