Calculated field

Dear All,
I have a UD table which has Part no(example TP6345),quantity and order date(the date part was ordered).I have to create a calculated field in the dashboard which gives me the total number of TP6345 ordered during the past 6 weeks.

How do I go about creating this 6 weeks usage.

Thank You,
Regards,
Anitha.