Total for Column for days by category

lumjingbki

Hi Can you please help in achiving the below input to output. I have tried using cross tab and summarize tool but not able to achieve the below output. Attaching the sample data

Input						Output
Categories	Code	Count	Amount	Date		Categories	Code	Amount/Count	20240109	20240110
Furniture	MIA	30	100	20240109		Furniture	MIA	Amount	100	200
Furniture	MIA	15	200	20240110		Furniture	MIA	Count	30	15
Furniture	LLB	5	300	20240109		Furniture	LLB	Amount	300	200
Furniture	LLB	10	200	20240110		Furniture	LLB	Count	5	10
						Furniture	Total of Amount	Amount	400	400
						Furniture	Total of Count	Count	35	25

sample data.xlsx

Amit_G_Limbasia

Dear @lumjingbki 

Please Find Attached workflow for your required solution

Solution Updated..

Sol_Amit_234.yxmd