Preparing Excel Pivot Table

Question

-

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:

Answer 1

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