Pivot table for Daily Stock Report

Isn't this more or less the same as your other thread today?

Right - please ask for a pivot table solution as an option in the original thread.

Administrative Note:

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...k-balance.html

Since you have not indicated what your PT should look like I have guessed.

Excel 2016 (Windows) 64 bit

	F	G	H	I	J	K
3	Date	Description	Opening Balance	Fitted Cycle kept in Godown	Cycle given for fitters	Brouht from Godown
4	7/10/2023	Hercules Std. Black	2
5	7/10/2023	Ladybird Diva 26" Pink	2
6	7/10/2023	Ladybird Diva 26" Sports purple	2
7	7/10/2023	Photon Ex	2
8	7/13/2023	Hercules Std. Green		2
9	7/13/2023	Hero Ladies Std. Green		2
10	7/13/2023	Street Cat Pro DX2 26"		2
11	7/13/2023	Street Rider ZX 26" Black A.Green		2
12	7/13/2023	Wildrock R/F 26"		2
13	7/14/2023	Hercules Std. Ashvat Green			4
14	7/14/2023	Hercules Std. Black			4
15	7/14/2023	Hercules Std. Green			4
16	7/14/2023	Ladybird Diva 26" Pink				2
17	7/14/2023	Ladybird Diva 26" Sports purple				2
18	7/14/2023	Photon Ex			1
19	7/14/2023	Street Rider ZX 26 Red				2
20	7/14/2023	Trailfire RF - 26" Ivory white				2
21	7/15/2023	Hercules Std. Ashvat Green

Sheet: Sheet1

Please Login or Register  to view this content.