Hi all, I have a pivot table that is analyzing the data of service calls to serial number of units, grouped by type of service call and age of unit. I would like to display the following information for each serial number: Total service calls, total tier 2 calls and total tier 3 calls in every 12 month service period. The farthest I can get is to display the number of each individual kind of service call per 12 month period for each serial number, but I can't figure out how to sub divide/group the kinds of service calls. I have attached images of what my pivot table looks like now and the pivot table fields below.
ss.PNG
ddd.PNG
Any help is appreciated, thank you!
Bookmarks