Pivot table with two different dates...

[copperwasher]

Hi there Excel Pivot Table masters.

I have attempted this, and failed, numerous times...
Hopefully, I can explain where I am, and where I wish to be.

Pivot table working perfectly, as below.
But, I need to add in a column between 'Sum of £ job' and 'Sum of paid banked'

This inserted column is the date the 'Sum of paid banked' was received.

The paid date exist in the table (It has it's own column), but I cant get the date to work without it messing up the table.

Co.	RHS				Dated	16:49 Mon 12 Jun 2023
Years (date)	date	job ref	invoice	Sum of £ job	Sum of paid banked	Balance
2022	09/12/2022	RL 43297032 / RHS12967	RHS Go UK 101	£660.00		-£300.42
	13/12/2022	RHS 13032 / 43390254	RHS Go UK 102	£624.00	£1,560.00
	14/12/2022	RHS13031 / 43407594	RHS Go UK 103	£336.00	£906.00
	20/12/2022	RHS 13052 / 43634644	RHS Go UK 104	£606.00	£624.00
	21/12/2022	RHS 13068 / 43649574	RHS Go UK 105	£246.00	£336.00
	29/12/2022	45946	RHS Go UK 106	£510.00
2022 Total				£2,982.00	£3,426.00
2023	04/01/2023	43833420	RHS Go UK 107	£510.00	£768.00
	05/01/2023	43847484 43877484	RHS Go UK 108	£600.00	£510.00
	06/01/2023	43850858 / 43860858	RHS Go UK 109	£354.00	£606.00
	07/01/2023	43869286	RHS Go UK 110	£258.00	£540.00
	10/01/2023	43945058	RHS Go UK 111	£870.00	£930.00
	11/01/2023	43960272	RHS Go UK 112	£570.00	£1,824.00
	12/01/2023	43998736	RHS Go UK 113	£450.00
	17/01/2023	44058242	RHS Go UK 114	£930.00
	18/01/2023	44105308	RHS Go UK 115	£690.00	£594.00
	19/01/2023	44114964	RHS Go UK 116	£210.00	£114.00
	23/01/2023	RHS 13221 / 13293	RHS Go UK 117	£540.00	£450.00
	24/01/2023	44215806	rhs Go UK 118	£594.00	£954.00
	25/01/2023	44240068	rhs Go UK 119	£690.00
	26/01/2023	44263876	rhs Go UK 120	£474.00
	30/01/2023	RHS13293	RHS Go UK 121	£540.00	£1,374.00
	31/01/2023	44358552	RHS Go UK 122	£714.00
	01/02/2023	44363576	RHS Go UK 123	£114.00
	02/03/2023	See table below	RHS Go UK 124	£300.42
2023 Total				£9,408.42	£8,664.00
Grand Total				£12,390.42	£12,090.00

Pivot table info:

Filter =
Co. = RHS

Rows =
Years (Date)
date
job ref
invoice

Columns =
Values

Values =
Sum of £ job
Sum of paid banked

Any assistance, as always, is greatly appreciated.

Yours,
Gary

 

[copperwasher]

More attempts...

This is as close as I can get without the table going into error...

Also, I can't find the option to remove the (blank) so the cell is clear (As there is no date available)

Can someone kindly guide me


My thanks in advance

Gary

 

[copperwasher]

Solved...

By myself

 

[RandyMorris]

Do you mind sharing your solution in case someone else finds it useful?

 

[Peter_SSs]

Good to hear you got the solution.
If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.