Avg for previous 12 weeks & previous 7 monthg

[bsreddy]

Hi Mates,

Can some one pls help me in creating Avg for preious 12 weeks & Avg for previous 7 months.

for now i used num((sum({week_falg={2,3,4,5,6,7,8,9,10,11,12,13}>}[trxcut])/12),'#,##0')

instead of giving week flag static can we make it dynamic .

i have week ending date & month ending date dims