I want help in a report

Suppose there is a table called transaction in which i have columns like date, transaction type, qty, transaction type has values like purchase or return or initial or sale or adjustment, now i want to see for a particular duration how many quantity is given to the store and how many sold and what is sales ratio, Can anyone help me to acheiving it