If condition in Pivot table

[NAVEEN C N]

Hi,

I want to find out minimum bat vol value from the bat vol column for values more than 1000 and i want to find out max temp value from temp column for values less than 300.

Pivot table attached for your reference.. please do the needful

 

[Asheesh]

Hi Naveen,

Can you please elaborate a bit more on your requirement...an example or 2 would be very helpful..

 

[ashish mehra]

Hi Naveen,

There are 13 pivot tables made.

If possible provide pivot table information in which you want the result to be displayed.

My suggestion to you while explaining your problem be specific with examples what you want.

Regards,
AM

 

[NAVEEN C N]

Sorry AM,
My data is listed as follows... dates in one column, battery voltages in one column..

While finding out max temp through pivot table it is taking values which are more than 300.. so i want to put a condition so that while taking max value it should consider only the values with in 300...
The same case for battery voltages, While finding out min bat vol through pivot table it is taking values which are less than 1000.. so i want to put a condition so that while taking min value it should consider only the values more than 1000...

Hope you got my problem..

Please do the needfull..