Pivot Table Count Without Row/Column Stacking

[MarkMcCann]

Hi!

I am currently trying to work out a way to individually total a number of categories per week.

In my data source each record is assigned a week number along with varying categories which I want to total.

For example, the data is based around 'Accidents' - with in each record you grade the accident out of '1-4', additionally you must state if 'further action was required' with a Y/N and if a 'Specialist was Engaged' also with a Y/N.

So I would need individual totals for each on a separate row, like so:

Screen Shot 2013-10-17 at 4.25.51 PM.png



I have tried with pivot tables but I am unable to 'unstack' the totals.

A work around for me would be to create separate pivot tables but I would also like to combine the data into a graph.

Any ideas anyone?
Thanks in advance!!
(Using Excel 2010)

[Bhuvi]

Hi Mark,

Open the field list in the pivot, put the "Grades col" in the Row labels, the "Week num" in the column labels and in the values section take count of "week num".
For "further action" and "specialist" totals you need to create a separate pivot.