Pivot table calc display

[Sharksfan]

I have a data sheet with several columns; Date, part number, quantity, inventory status code.. I want to pivot this with part number as rows and dates as columns and 2 calculated fields showing inventory class, inventory one above the other in the same column (separate rows) under the respective dates. When I create a pivot table I can only get the calculated field to show side by side in two separate columns side by side (same row). Advice?

 

[Anfinsen]

I am not sure what you mean. You say your data has inventory status code, and then you reference an inventory class. Are those the same things? see my example below.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	Date	part	Quantity	Inventory Status Code		Sum of Quantity	Column Labels
2	9/7/2023	1234	1212	Homer J Simpson			9/7/2023		9/7/2023 Total	9/9/2023		9/9/2023 Total	9/11/2023		9/11/2023 Total	9/13/2023	9/13/2023 Total	(blank)	(blank) Total	Grand Total
3	9/7/2023	1235	1213	batman symbol		Row Labels	batman symbol	Homer J Simpson		five	octopus		#blessed	%^%&^		fiveteen		(blank)
4	9/9/2023	1236	1214	five		1234		1212	1212											1212
5	9/9/2023	1237	1215	octopus		1235	1213		1213											1213
6	9/11/2023	1238	1216	#blessed		1236				1214		1214								1214
7	9/11/2023	1239	1217	%^%&^		1237					1215	1215								1215
8	9/13/2023	1240	1218	fiveteen		1238							1216		1216					1216
9						1239								1217	1217					1217
10						1240										1218	1218			1218
11						(blank)
12						Grand Total	1213	1212	2425	1214	1215	2429	1216	1217	2433	1218	1218			8505
Sheet1

 

[Sharksfan]

Not quite what I am looking for. I have cobbled together a short list of data and ultimately what I would like it to look like. When I do a pivot it puts the inventory class and the quantity side by side in columns. I would like that data one above the other in rows. This way, reading left to right, I can easily see changes in inventory class, quantity and the date the change occurred.

 

[Anfinsen]

Without using VBA, the closest I can get to your desired result using a pivot table is this.

fdgfgdf.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Location	part	Quantity	Inventory class	DATE		Sum of Quantity		Column Labels
2	L01	0000010301	333	O	7/14/2023		Row Labels	part	7/14/2023	7/21/2023	7/28/2023	8/4/2023	8/11/2023	8/18/2023	8/25/2023	(blank)	Grand Total
3	L01	0000010301	333	O	7/21/2023		L01		333	333	333	71					1070
4	L01	0000010301	333	O	7/28/2023		O	0000010301	333	333	333	71					1070
5	L01	0000010301	71	O	8/4/2023		O Total		333	333	333	71					1070
6	L08	0000010355	46	S	8/11/2023		L08						46	46	46		138
7	L08	0000010355	46		8/18/2023		S	0000010355					46		46		92
8	L08	0000010355	46	S	8/25/2023		S Total						46		46		92
9							(blank)	0000010355						46			46
10							(blank) Total							46			46
11							(blank)
12							(blank)	(blank)
13							(blank) Total
14							Grand Total		333	333	333	71	46	46	46		1208
Sheet1

this is the setting I used;

then you have to set the value field settings for both part and class, to this;