Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
tkavitha911
Helper I
Helper I

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

YearMonth UsedBGR Qty Category MappingPack SizeExit Status
202201-01-2022DEO FEMALE0Personal Care150Active
202201-01-2022LIP0Skin Care4.8Active
202201-01-2022LIP0Skin Care4.8Active
202201-01-2022DEO FEMALE0Personal Care150Active
202201-01-2022DEO MALE0Personal Care150Active
202201-01-2022DEO ROLL-ON0Personal Care25Active
202201-01-2022NM FACE - CLEANSING0Skin Care50Active
202201-01-2022NM FACE - CLEANSING0Skin Care50Active
202201-01-2022DEO MALE0Personal Care120Delisted
202201-01-2022SOAP0Personal Care125Delisted
202201-01-2022SOAP0Personal Care75Delisted
202201-01-2022DEO ROLL-ON0Personal Care50Active
202201-01-2022DEO ROLL-ON0Personal Care50Active
202201-01-2022BODY0Skin Care75Active
202201-01-2022DEO ROLL-ON0Personal Care50Active
202201-01-2022CREMES0Skin Care20Delisted
202201-01-2022BODY0Skin Care400Active
202201-01-2022BODY0Skin Care75Active
202201-01-2022BODY0Skin Care400Active
202201-01-2022BODY0Skin Care200Active
202201-01-2022NM FACE - CARE0Skin Care75Active
202201-01-2022BODY0Skin Care75Active
202201-01-2022BODY0Skin Care75Active
202201-01-2022BODY0Skin Care200Active
202201-01-2022BODY0Skin Care400Active
1 ACCEPTED SOLUTION
tkavitha911
Helper I
Helper I

above table is sample output i wnat to display like that

View solution in original post

4 REPLIES 4
tkavitha911
Helper I
Helper I

above table is sample output i wnat to display like that

FreemanZ
Super User
Super User

hi @tkavitha911 ,

 

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

Above table is sample data 

-27%-6%3%0%7%5%5%-4%-4%2%3%8%-13%4%-2%4%-1%
CategoryBGRPack SizeProduct StatusJan-24Feb-24Mar-24Apr-24May-24Jun-24Jul-24Aug-24Sep-24Oct-24Nov-24Dec-24Q1Q2Q3Q42024
Skin CareBODY35Delisted-77%-29%0%0%0%0%0%0%0%0%0%0%-71%-100%-100%-100%-86%
Skin CareBODY18Delisted-53%-53%0%0%0%0%0%0%0%0%0%0%-78%-100%-100%-100%-83%
Skin CareBODY350Delisted0%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 CareSOFT300Active5%11%12%19%33%28%39%19%27%23%28%27%8%26%27%26%24%
Skin CareSOFT0Active19%168%65%12%16%42%3%15%12%-27%-18%43%72%22%10%-12%10%
Skin CareSOFT250Delisted-42%35%0%0%0%0%0%0%0%0%0%0%-38%0%-100%-100%0%
Skin CareSOFT75Delisted-65%-16%0%0%0%0%0%0%0%0%0%0%-54%-100%-100%-100%-81%
Skin CareSOFT8Active0%-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 CareDEO FEMALE ROLL-ON50Active-4%17%19%8%1%6%12%9%8%0%6%-8%12%5%9%-1%6%
Personal CareDEO FEMALE ROLL-ON25Active-4%18%14%16%22%5%2%23%13%18%16%25%10%14%11%20%13%
Personal CareDEO FEMALE ROLL-ON8Active0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%
Personal CareDEO FEMALE ROLL-ON40Delisted0%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 CareSHOWER250Active-12%8%0%4%-11%0%14%3%7%12%10%14%-1%-3%8%12%3%
Personal CareSHOWER125Active58%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%

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.