Special Pivot Table

[Mederic]

Hello everyone,
I would need your precious help for my problem.
I would like to make a Pivot Table built like on the image in the capture below in which I put a maximum of information

I think that this is not possible with a classic Pivot Table and that it would be necessary to use DAX measures.

Can you please help me with this?

Thank you in advance for your help
Regards

PO	POS	"Last  
Modification"	Vendor	Amt	Cat
8900015	1	21/03/2016	ABC	43	A
8900015	2	21/03/2016	ABC	64	A
8900019	1	08/05/2016	DEF	32	B
8900019	2	17/01/2017	DEF	-14	B
8900019	3	17/01/2017	DEF	16	B
8900019	4	17/09/2017	DEF	42	B
8900027	1	01/10/2017	GHI	34	A
8900027	2	01/10/2017	GHI	78	A
8900028	1	12/11/2018	JKL	120	A
8900028	2	22/01/2019	JKL	12	A
8900028	3	22/01/2019	JKL	-36	A
8900028	4	16/12/2018	JKL	-65	A
8900032	1	15/12/2020	MNO	67	B
8900056	1	13/03/2020	OPQ	135	B
8900056	2	20/02/2020	OPQ	24	B
8900078	1	18/02/2021	RST	78	A
8900078	2	18/02/2021	RST	-15	A
8900078	3	18/02/2021	RST	44	A
8900095	1	31/05/2022	ABC	65	B
8900095	2	06/06/2022	ABC	34	B
8900102	2	26/07/2022	GHI	-14	B
8900102	5	26/07/2022	GHI	73	B
8900103	4	02/10/2022	UVW	41	A
8900105	1	07/11/2022	RST	63	A
8900105	2	07/11/2022	RST	51	A
8900106	1	16/12/2022	RST	97	B
8900107	2	03/01/2023	XYZ	14	A
8900107	4	09/03/2023	XYZ	98	A
8900108	1	05/02/2023	MNO	42	B
8900109	2	18/03/2023	JKL	57	B
8900109	5	15/02/2023	JKL	33	B

[Mederic]

Hello @Greg_Deckler ,

Thank you very much for your reply and the link, which I consulted carefully.
Unfortunately, I am not familiar with Dax codes with functions I do not know and the notion of Hierarchy.
Not sure if ISINSCOPE is accepted in my Excel 2019 Pro version.
I still have doubts about the use of punctuation.
I don't know if it depends on the versions or the language or the Country !
It seems to me that a formula should start with := then I don't know if the separator between the arguments is ; or the ,
In the first versions of Excel, it seems to me that it was the ;
I will test this code in Power BI to see.

Otherwise, it occurred to me that one could mix Power Query and Pivot Table.

I will open a message in Power query and see if there is an easier solution for me.

Thank you again for your suggestion
Have a nice day

Regards

[Greg_Deckler]

@Mederic See if this helps: The New Hotness (Custom Matrix Hierarchy) - Microsoft Power BI Community