Pivot Table Calculated Field with Count

[jschena]

Hello,

I am trying to calculate a ratio for Hours per Ticket by month. I have a pivot table that COUNTS tickets and SUMS hours per month. I was hoping to create a calculated field to the jist of COUNT(Tickets) / SUM(Hours), but this does not work because calculated fields aggregate data.... I was hoping to keep it all in a pivot table so that I can still use slicers and such. Any ideas?

Pivot Table:

Rows: Years, Months
Values: Tickets (Count), Hours (Sum)

Month	Tickets (count)	Hours(sum)	Throughput (Calculated)
2013
Apr	65	22	2.97
May	311	321	0.97
Jun	306	469	0.65
Jul	415	329	1.26
Aug	461	350	1.32
Sep	430	434	0.99
Oct	538	428	1.26
Nov	458	416	1.10
Dec	420	401	1.05
2014
Jan	401	374	1.07
Feb	400	358	1.12
Mar	458	443	1.03
Apr	385	457	0.84
May	370	260	1.42
Jun	203	185	1.10
Grand Total	5621	5247	1.07

<tbody>
</tbody><colgroup><col><col><col><col></colgroup>

Thank you thank you!!

 

[Excelaron]

Did you try to put the calculation in the source data?