Pivot Table - Show to separate fields of data in Values (as rows not columns)

Hi,

I have attached some mock data to try explain what I am attempting to do.
The Mock Data has been used as the basis for a pivot table. The 'Pivot 01' and 'Pivot 02' sheets show the exact layout I want to see with count by month and total by month. I am trying to combine these onto the one pivot.

The question sheet shows a snippet of these two pivot tables and a third mocked up view which I am trying to get. The 'My Attempt' sheet shows that the data can only be shown side by side which doesn't make for a clear enough read.
As with most things the solution will either be a) obvious and staring me in the face or b) not possible.

I can create a sheet with populates as required for now but the speed of updating with a pivot table obviously will make my life easier so any feedback or alternative 'thinking outside the box' suggestions are welcomed.

Thanks in Advance
Harribone

Note thread title should read 'two' not 'to'.
Not sure if I can change this or if Admin can assist?

Hi Harribone,

The "My Attempt" pivot is how Pivot Tables work. You have a column of Count and another for Total. I don't think you can do a single column where it shows count above total. I believe the answer is - Pivot Tables don't have the ability you are looking for.

Marv
BTW - thanks for the Rep on my 2013 answer.

Thanks Marvin,

Will still to an old fashioned approach.

Must have had an old thread open looking for help on something, the rep should be for another thread which I have marked as solved today! It's been a long day in the office...

Thanks
Harribone

Hi,

See the attached where I got as close to what you asked for. Not exact but cleaner.

Closer PT View.xlsx

Thanks for having a go Marvin.
Date filter might work if they are open to change... fingers crossed