Preparing Excel Pivot Table

I have a tabular data with values as in picture. I created a pivot table in excel 2007 .How can I get count value of each up/Down for date specified. I tried to开发者_开发百科 by making one column row and other as values but it would not work.

The result would be:

A better solution is to use a countif function on a second tab. something like

=COUNTIF(Sheet1!A:A,"UP")

and

=COUNTIF(Sheet1!A:A,"DOWN")

and copy it across the range of dates.

If you can format your data differently to look like this

Then the pivot table becomes easy withthe following settings