Integrated Sales Calculation for Targeted Brands and Markets

Requirement:

Develop a SQL script for each combination of brand name, product name, market name, competitor flag, channel, and transaction time, calculate the total number of integrated_units, integrated_normalized_units, and integrated_dollars using bai_sales_agg_obu_customer_datapack_weekly table.

 

If the brand is either "kanjinti", "mvasi", or "riabni", and if the GPO flag contains the word "KAISER", then treat the sales values as zero for those rows.

 

Make sure the transaction date is within the last 36 months from the cdl effective date. Finally, include only the markets named "trastuzumab-anns", "bevacizumab-awwb", or "rituximab market".