Skip to Content
0

sales report by sub dept (UDF) with this year and last year comparitive

Jul 06, 2017 at 09:34 PM

20

avatar image

Hi guys Im really stuck on doing this query.....it keeps telling me my syntax is wrong and now my queries aren't running at all !

I need a query grouped by sub dept ( UDF) on OINM showing sales for this year and the same period for last year.

columns required are

Sub Dept (UDF), Item code, Qty, Sales value, Margin

hope someone can help.

thanks

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers