Excel pivot chart

Question

Hi

I have created a excel spreadsheet for water sampling results, to act has a tracker.

There are other tabs for each of the buildings.

I have conditional formatted the pre and post columns, so for example if there is a 50 it turns the cell green as per our water safety plan

I would like to do a summary table showing amount of greens, reds etc with the analytical report code so we know which sampling run its from.

Is there a way to do this, i have attached a print screen of what it looks like.

Thank you in advance

Type	Barcode	Primary Identifier	Secondary Identifier	Location	NEW ROOM NUMBER	Type	Sample date	Analytical Report Code	Results date	HOT	Cold	Mixed
						Q=Quarterly <br>R= Resample				Pre	Temp	Post	Temp	Pre	Temp	Post	Temp	Pre	Temp	Post	Temp
Non senintel outlets	04005	WHB		Bloxwich Hospital/Bloxwich Hospital/Floor 1/1.36 - Laundry	B01-01A-003 - Laundry
sentinel outlets	04006	Sink	secondary Identifier	Bloxwich Hospital/Bloxwich Hospital/Floor 1/1.36 - Laundry	B01-01A-003 - Laundry	QUARERLY	25/04/2024	AR-24-TO-035683-01	09/05/2024	475	46.4			ND	16.1
Showers	115680	ThermostaticMixedShower		Bloxwich Hospital/Bloxwich Hospital/Floor 1/1.35 - Hair Salon	B01-01A-039 - Salon
TMV	04010	WHB		Bloxwich Hospital/Bloxwich Hospital/Floor 1/Cedar Ward 1.21 - Bedroom	B01-01A-025 - Bedroom	QUARERLY	25/04/2024	AR-24-TO-035683-01	09/05/2024					ND	14.2			500	41.1
TMV	04012	WHB		Bloxwich Hospital/Bloxwich Hospital/Floor 1/Cedar Ward 1.24 - Bedroom	B01-01A-028 - bedroom	QUARERLY	08/08/2024	AR-24-TO-067992-01	21/08/2024									50	42.2

Answer 1

I have emailed it you via a secure file transfer

Karen,

I'm sorry but I can not open the file because your secure file transfer ask me for a "Egress ID" which I don't have.

Please try to upload the file into my DropBox:
Microsoft Answers Community Public Request - Dropbox

Andreas.

Answer 2

Hi Andreas

I have emailed it you via a secure file transfer

Thanks

Karen

Answer 3

We need to see your (sample) file.
Why a sample file is important for troubleshooting. How to do it. - Microsoft Community

Andreas.