select dc_city, month, round(hm_ns/1e5,1) as hm_ns, round(sm_ns/1e5,1) as sm_ns, round(amz_ns/1e5,1) as amz_ns, round(offline_ns/1e5,1) as offline_ns, round(case when prev_hm_ns<>0 then hm_ns*1e2/prev_hm_ns-100.0 else 0.0 end,1) as hm_growth, round(case when prev_sm_ns<>0 then sm_ns*1e2/prev_sm_ns-100.0 else 0.0 end,1) as sm_growth, round(case when prev_amz_ns<>0 then amz_ns*1e2/prev_amz_ns-100.0 else 0.0 end,1) as amz_growth, round(case when prev_offline_ns<>0 then offline_ns*1e2/prev_offline_ns-100.0 else 0.0 end,1) as offline_growth from (select dc_city,month,mth, hm_ns, lag(hm_ns,1) over (PARTITION by dc_city,mth order by month) as prev_hm_ns, sm_ns, lag(sm_ns,1) over (PARTITION by dc_city,mth order by month) as prev_sm_ns, amz_ns, lag(amz_ns,1) over (PARTITION by dc_city,mth order by month) as prev_amz_ns, offline_ns, lag(offline_ns,1) over (PARTITION by dc_city,mth order by month) as prev_offline_ns from (select dc_city,last_day(b_date) as month, date_part(month,b_date) as mth, sum(case when sub_tran_type not in ('INSTI','AMZNOW','OFFREG') and format = 'HM' and loc_type <>'DARKSTORE'then bill_net_value else 0.0 end) as hm_ns, sum(case when sub_tran_type not in ('INSTI','AMZNOW','OFFREG') and format = 'SM' and loc_type <>'DARKSTORE'then bill_net_value else 0.0 end) as sm_ns, sum(case when sub_tran_type not in ('INSTI','AMZNOW','OFFREG') and loc_type <>'DARKSTORE' then bill_net_value else 0.0 end) as offline_ns, sum(case when sub_tran_type = 'AMZNOW' then bill_net_value else 0.0 end) as amz_ns from tran.txn t join master.loc l on t.location_code = l.loc join master.item i on t.item_no = i.item where (b_date between '2024-01-01' and current_date-1 or b_date between '2023-01-01' and dateadd(d,-365,current_date-1)) and date_part(d,b_date)<=date_part(d,current_date-1) and date_part(month,b_date)<=date_part(month,current_date-1) and dept <>91 and (close_date is null and inactive_date is null) group by 1,2,3) where 1=1 qualify prev_sm_ns is not null)

Sales and Growth Report

Daily Sales

Weekend Count

Daily (net) Sales for Trailing 7 Days in Rs Crs

Growth Analysis

Month-wise Yoy Growth for Like Stores

Ytd Yoy Growth for Like Stores

Month-wise Yoy Growth for All Stores

Ytd Yoy Growth for All Stores

Other Cuts

Omni Sales

Institutional Sales

DC City Sales

YoY Analysis for LTL

YTD Analysis for LTL

FnV Economics

All Stores

Offline and Hybrid Stores

Dark Stores