Pivot table calculated field.

[dheeraj1688]

A
_______
-0:05:00
-0:05:00
0:30:00
0:30:00
0:00:00
0:00:00

Hi there is a small problem i'm facing.I'm calculating (count) time Greater,less and equal to 0 by using formula Countif(A1:A6,">0"),Countif(A1:A6,"<0"),Countif(A1:A6,"=0").I'm getting result also.

But what should i do if i want do same process in Pivot table.
Attaching ref.
Thank you in advance .

 

[Somendra Misra]

Hi Dheeraj,

I doubt what you are trying to achieve through calculated field is possible. Try to add extra column in your data with these conditions and use those columns in Pivot.

Regards,