In Demantra, a series called 'History' gets its data from sales_data.Actual_quantity but it not show

I am using the query :

select SUM(ACTUAL_QUANTITY) from demprd.sales_data where item_id = 615 and SALES_DATE = '31-AUG-15'

and location_id in (

select LOCATION_ID from demprd.Location where T_EP_SITE_EP_ID IN (

select T_EP_SITE_EP_ID from demprd.t_ep_site where SITE like '%_BNA'))

But I am not getting the correct value.

At org level I am trying to see the sales history data for a particular week.

kindly let me know if you need any further details.