• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot table - counting by calculate field

madocar

madocar

Member
Hello my friends,

is it possible to count only those cells which have a value larger than 1?
I'm talking about Pivot table and I would like to use calculate field for that issue.

More in attachment

Thanks a lot guys
 

Attachments

  • chandoo_calculate field.xlsx
    13.8 KB · Views: 14
@madocar,

I have a solution, but it is using SUMPRODUCT rather than a pivot table. Please see if the attached will serve your needs.

Regards,
Ken
 

Attachments

  • chandoo_calculate field_KenU.xlsx
    14.4 KB · Views: 2
If you wish to auto group the date & count the value based on that then loop to attached file.
You may change the range as needed.
 

Attachments

  • chandoo_calculate field_imdkbj.xlsx
    14.8 KB · Views: 4
@ madocar

...Add a helper column (which i think you don't like to :) with the following formula and add this column in the Pivot:

Code: 
=IF(B2>1,1,0)

Pivot_madocar.png
 
Thanks all of you.
I know there is a lot of different solution by adding a new column etc ..
I was just curious if it is possible to do it right into my pivot table.
Probably not ... sad
 
You must log in or register to reply here.
Back
Top