Pivot table - counting by calculate field

[madocar]

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

 

[KenU]

@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

 

[Deepak]

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.

 

[Faseeh]

@ madocar

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

=IF(B2>1,1,0)

 

[madocar]

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