Pivot table over two dates ranges

[DctheDC]

I have a list of items that have dates against them of date rec’d and date issued, I wish to count the number of dates per month as a running total in a pivot chart but whatever I do the resulting count is the same for both date ranges. Manually checking the data, they have different values per month.

If I run the pivot chart/table on one date range it works as expected and the line graph is displaying correctly, but when I add the second date range it displays the same results for both counts.

As an example:-

In March 17 I rec’d 25 items but issued out 10 – the values on the pivot chart should be 25 & 10
In April 17 I rec’d 10 items but issued out 20 – the values on the pivot chart should be 35 & 30

But as mentioned the values are displayed as 35 for both totals

In addition, I cannot figure out how to get the dates on the X axis to run from Mar-17 to Feb-18 and not have the running total re-set itself as is jumps from 2017 to 2018

I have the result I want by manually counting the totals per month and then calculating a running total and doing that for both data series and putting that on a normal graph, but it is very long-winded way of doing things as I have 12 separate spreadsheets I need to report against

Any help would be appreciated

 

[oldbrewer]

	item	received	issued	date	month				month	received	issued	cum recd	cum issued
	item1	25		02/01/2017	Jan				jan	41	0	41	0
	item2	16		18/01/2017	Jan				feb	77	0	118	0
	item3	33		03/02/2017	Feb				mar	77	7	77	7
	item4	44		19/02/2017	Feb				apr	10	25	87	32
	item5	77		07/03/2017	Mar				may	25	45	25	77
	item2		7	23/03/2017	Mar				jun	27	28	52	105
	item3		25	08/04/2017	Apr				jul	29	27	29	132
	item4	10		24/04/2017	Apr				aug	31	26	60	158
	item5		45	10/05/2017	May				sep	0	25	0	183
	item3	25		26/05/2017	May				oct	33	24	33	207
	item4		28	11/06/2017	Jun				nov	35	23	35	230
	item5	27		27/06/2017	Jun				dec	52	22	87	252
	item1		27	13/07/2017	Jul
	item2	29		29/07/2017	Jul
	item3		26	14/08/2017	Aug
	item4	31		30/08/2017	Aug
	item5		25	15/09/2017	Sep
	item2	33		01/10/2017	Oct
	item3		24	17/10/2017	Oct				if you make the above table dynamic
	item4	35		02/11/2017	Nov				you can plot between any start and end month
	item5		23	18/11/2017	Nov
	item3	37		04/12/2017	Dec				not sure what you want
	item4		22	20/12/2017	Dec				can you say in terms of this example ?
	item5	15		23/12/2017	Dec

<colgroup><col span="2"><col><col><col><col span="12"></colgroup><tbody>
</tbody>