Customer_360 -Compute Brand-Level Sales Metrics & Growth Calculations for C360 Report

Introduction: For Customer_360 Insights, calculate performance metrics like TRx, NRx, Dollars, DOT, and Units. For each metric, also compute the Previous value, Growth (difference), Growth percentage, Market share.

 

Requirements: Develop SQL logic, Read the table “c360_brand_weekly_sales_report“ to calculate key sales metrics such as TRx, NRx, Dollars, DOT, and Units for each brand. For every metric, use the current value and subtract the growth value to find the previous period value since growth is already provided. Then calculate percent growth by dividing the growth amount by the previous value and multiplying by 100. Also need to compute market share by dividing the brand’s value by the total market value for that period.

 

Final Output: Display the results.

 

Unity Catalog: c360_brand_weekly_sales_report