Hello Luis,
I need to divide using the DailyCount filed which is in the example below:
SUM(CASE WHEN BF_OFFER_CODE IS NOT NULL THEN 1 ELSE 0 END) 'DailyCount'
2014-07-21 00:00:00.000 AXXX Inventory (A) 84
2014-07-21 00:00:00.000 AXXX Inventory with Lead 45
2014-07-21 00:00:00.000AXXX Inventory Opt-In Rate 34%
Both the 84 and 45 numbers are derived from the above CASE statement.
What I need to do is create a new row named XXX Inventory Opt-In Rate (row in boldface) and divide the 45 number, which is the XXX Inventory with Lead number by the total grouping for XXX with is 129 (84+45)
Thanks