Query to fetch the series aggregated data from Sales_data/mdp_matrix

Hi,

I need to take Shipment History and returns History from Sales_data table.

Shipment_Histiry and Returns_history were created as series.

Pls tell teh query on how to fethc the details based on the 2 series?

Whether these 2 series were created as columns in sales_data table/mdp_matrix. If yes how we need to aggregate based on Item and location combination.

Thanks in Advance

Gopi G