I want to display CAGR% Qty for 2024 year Comparision of 2022

[tkavitha911]

Year	Month Used	BGR	Qty	Category Mapping	Pack Size	Exit Status
2022	01-01-2022	DEO FEMALE	0	Personal Care	150	Active
2022	01-01-2022	LIP	0	Skin Care	4.8	Active
2022	01-01-2022	LIP	0	Skin Care	4.8	Active
2022	01-01-2022	DEO FEMALE	0	Personal Care	150	Active
2022	01-01-2022	DEO MALE	0	Personal Care	150	Active
2022	01-01-2022	DEO ROLL-ON	0	Personal Care	25	Active
2022	01-01-2022	NM FACE - CLEANSING	0	Skin Care	50	Active
2022	01-01-2022	NM FACE - CLEANSING	0	Skin Care	50	Active
2022	01-01-2022	DEO MALE	0	Personal Care	120	Delisted
2022	01-01-2022	SOAP	0	Personal Care	125	Delisted
2022	01-01-2022	SOAP	0	Personal Care	75	Delisted
2022	01-01-2022	DEO ROLL-ON	0	Personal Care	50	Active
2022	01-01-2022	DEO ROLL-ON	0	Personal Care	50	Active
2022	01-01-2022	BODY	0	Skin Care	75	Active
2022	01-01-2022	DEO ROLL-ON	0	Personal Care	50	Active
2022	01-01-2022	CREMES	0	Skin Care	20	Delisted
2022	01-01-2022	BODY	0	Skin Care	400	Active
2022	01-01-2022	BODY	0	Skin Care	75	Active
2022	01-01-2022	BODY	0	Skin Care	400	Active
2022	01-01-2022	BODY	0	Skin Care	200	Active
2022	01-01-2022	NM FACE - CARE	0	Skin Care	75	Active
2022	01-01-2022	BODY	0	Skin Care	75	Active
2022	01-01-2022	BODY	0	Skin Care	75	Active
2022	01-01-2022	BODY	0	Skin Care	200	Active
2022	01-01-2022	BODY	0	Skin Care	400	Active

[tkavitha911]

above table is sample output i wnat to display like that

[FreemanZ]

hi @tkavitha911 ,

It would be necessary if you could provide enough sample data to well represent your challenge. 

[tkavitha911]

Above table is sample data 

[tkavitha911]

-27%-6%3%0%7%5%5%-4%-4%2%3%8%-13%4%-2%4%-1%

Category	BGR	Pack Size	Product Status	Jan-24	Feb-24	Mar-24	Apr-24	May-24	Jun-24	Jul-24	Aug-24	Sep-24	Oct-24	Nov-24	Dec-24	Q1	Q2	Q3	Q4	2024
Skin Care	BODY	35	Delisted	-77%	-29%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	-71%	-100%	-100%	-100%	-86%
Skin Care	BODY	18	Delisted	-53%	-53%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	-78%	-100%	-100%	-100%	-83%
Skin Care	BODY	350	Delisted	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	-100%	-100%	-100%	0%
	BODY Total			-34%	-3%	0%	-6%	13%	17%	9%	5%	-4%	2%	1%	9%	-16%	6%	1%	3%	0%
Skin Care	SOFT	300	Active	5%	11%	12%	19%	33%	28%	39%	19%	27%	23%	28%	27%	8%	26%	27%	26%	24%
Skin Care	SOFT	0	Active	19%	168%	65%	12%	16%	42%	3%	15%	12%	-27%	-18%	43%	72%	22%	10%	-12%	10%
Skin Care	SOFT	250	Delisted	-42%	35%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	-38%	0%	-100%	-100%	0%
Skin Care	SOFT	75	Delisted	-65%	-16%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	-54%	-100%	-100%	-100%	-81%
Skin Care	SOFT	8	Active	0%	-46%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	-100%	-100%	-100%	-85%
	SOFT Total			-28%	-17%	7%	17%	4%	11%	15%	-4%	-4%	7%	14%	10%	-16%	11%	1%	10%	3%
Skin Care Total
Personal Care	DEO FEMALE ROLL-ON	50	Active	-4%	17%	19%	8%	1%	6%	12%	9%	8%	0%	6%	-8%	12%	5%	9%	-1%	6%
Personal Care	DEO FEMALE ROLL-ON	25	Active	-4%	18%	14%	16%	22%	5%	2%	23%	13%	18%	16%	25%	10%	14%	11%	20%	13%
Personal Care	DEO FEMALE ROLL-ON	8	Active	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%
Personal Care	DEO FEMALE ROLL-ON	40	Delisted	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	-100%	-100%	-100%	0%
	DEO FEMALE ROLL-ON Total			-5%	16%	17%	9%	7%	6%	8%	12%	9%	4%	9%	0%	10%	7%	10%	4%	8%
Personal Care	SHOWER	250	Active	-12%	8%	0%	4%	-11%	0%	14%	3%	7%	12%	10%	14%	-1%	-3%	8%	12%	3%
Personal Care	SHOWER	125	Active	58%	8%	30%	43%	46%	9%	38%	29%	12%	16%	5%	11%	26%	29%	25%	11%	23%
	SHOWER Total			-9%	7%	5%	8%	-2%	3%	15%	4%	9%	13%	10%	16%	1%	3%	9%	13%	6%