PivotTable formula problem - countif?

[Zabman]

Hi,

I have a problem which I think is actually very basic, i'm just to stupid to work it out.

I have a pivottable looking at a datasource with several thousand rows. Column Y in the datasource is a weight, and I want to be able to have 2 column labels in my pivot, one counting all values OVER 15, and one column counting all those BELOW 15.

Please help?

 

[paulabatton]

Hi,

I have a problem which I think is actually very basic, i'm just to stupid to work it out.

I have a pivottable looking at a datasource with several thousand rows. Column Y in the datasource is a weight, and I want to be able to have 2 column labels in my pivot, one counting all values OVER 15, and one column counting all those BELOW 15.

Please help?

Did you ever figure out how to do this?

I have raw data in the format of time duration mmss
I have a pivot table that I need to get a count of number of calls under 30 seconds, I think this would answer how to do that.

 

[Fazza]

Hi,

Maybe one way is to add a new field to the source data? Say, Category. With a formula like =if(Y2>15,"Over 15", "Not over 15"). Put this new field in the pivot table.

Another would be to set the pivot table up via the external data option and add a new field via SQL. Something like

SELECT *, IIF(Weight>15,'Over 15', 'Not over 15') AS [Category]
FROM data_source

HTH