Hello All

I currently have a table that requires a formula to group totals but cannot work out how to do it. It is a movement table that lists all stock movements and I would like to summarise these by month.

Here is what I have

ITEM_NUMBER - (200 unique item numbers (Stock Codes)
ITMMOV_MOVEMENT_DATE
ITMMOV_MOVEMENT_CODE (W and S)
ITMMOV_QUANTITY

What I would like to achieve is have a formula called "May" and that will display the sum of all the item number movement quantity for that month.

I have 2 Movement codes that need to be seperated too which are "W" and "S".

Any help would be appreciated

Many thanks for the reply:

I need to display both the W and S figures side by side so sorting is out of the question.

Say Item "A" has 57 sales in May (40 W and 17S), I need to show on the report Item A - May Works - May Sales.

Hope the above is clearer.