how to create a pivot table to count how many times a cell broke a numerical threshold

[almst791]

Hi guys, I have a tab where I manually input information with a column that has a day over day change of the data with the associated date. I want to create a table that has the 12 months in the columns and the year 2014 2015 and 2016 as the rows. I want to get a count of how many times this day over day change breaks a certain threshold. Is there anyway I can create a pivot table to keep a running count?


[TABLE="width: 523"]
<colgroup><col width="64" style="width: 48pt;"> <col width="288" style="width: 216pt; mso-width-source: userset; mso-width-alt: 10240;"> <col width="26" style="width: 20pt; mso-width-source: userset; mso-width-alt: 938;"> <col width="28" style="width: 21pt; mso-width-source: userset; mso-width-alt: 995;"> <col width="31" style="width: 23pt; mso-width-source: userset; mso-width-alt: 1109;"> <col width="27" style="width: 20pt; mso-width-source: userset; mso-width-alt: 967;"> <col width="33" style="width: 25pt; mso-width-source: userset; mso-width-alt: 1166;"> <col width="26" style="width: 20pt; mso-width-source: userset; mso-width-alt: 938;"> <col width="22" style="width: 17pt; mso-width-source: userset; mso-width-alt: 796;"> <col width="29" style="width: 22pt; mso-width-source: userset; mso-width-alt: 1024;"> <col width="33" style="width: 25pt; mso-width-source: userset; mso-width-alt: 1166;"> <col width="28" style="width: 21pt; mso-width-source: userset; mso-width-alt: 995;"> <col width="31" style="width: 23pt; mso-width-source: userset; mso-width-alt: 1109;"> <col width="30" style="width: 22pt; mso-width-source: userset; mso-width-alt: 1052;"> <tbody>[TR]
[TD="class: xl71, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl72, width: 288, bgcolor: transparent"]Count of Balance Changes Above Threshold[/TD]
[TD="class: xl71, width: 26, bgcolor: transparent"]Jan[/TD]
[TD="class: xl72, width: 28, bgcolor: transparent"]Feb[/TD]
[TD="class: xl72, width: 31, bgcolor: transparent"]Mar[/TD]
[TD="class: xl72, width: 27, bgcolor: transparent"]Apr[/TD]
[TD="class: xl72, width: 33, bgcolor: transparent"]May[/TD]
[TD="class: xl72, width: 26, bgcolor: transparent"]Jun[/TD]
[TD="class: xl72, width: 22, bgcolor: transparent"]Jul[/TD]
[TD="class: xl72, width: 29, bgcolor: transparent"]Aug[/TD]
[TD="class: xl72, width: 33, bgcolor: transparent"]Sept[/TD]
[TD="class: xl72, width: 28, bgcolor: transparent"]Oct[/TD]
[TD="class: xl72, width: 31, bgcolor: transparent"]Nov[/TD]
[TD="class: xl73, width: 30, bgcolor: transparent"]Dec[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent, align: right"]2014[/TD]
[TD="class: xl68, bgcolor: transparent"]$1MM[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]2015[/TD]
[TD="class: xl69, bgcolor: transparent"]$1.5MM[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent, align: right"]2016[/TD]
[TD="class: xl70, bgcolor: transparent"]$2MM[/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[/TR]
</tbody>[/TABLE]