0

quantity of item categories in orders

Jet Reports Historic Posts

February 13, 2014 07:33

None

Follow

Dear all,

i am a newbie and I have just got the Basic Training of Jet Reports. Now I have the Task to make a Report like this:

Filter:
- Item Category
- Product Group Code
- Period of time (e.g. 31.10.13-10.02.14)

Result: CATEGORIE | PRODUCT GROUP CODE | SUM OF QUANTITY

this would be my first step!

can anybody help me with a quick solution?

• -13022014.pdf

• Facebook
• Twitter
• LinkedIn

5 comments

• 0
  
  Jet Reports Historic Posts February 17, 2014 15:27

  Hi all,
  
  is there anybody who can help?
  
  thanks

• 0
  
  Jet Reports Historic Posts February 17, 2014 15:47

  hi luke,
  
  i'm not quiet sure about that, what you want…
  do you want to have a sum of quantitiy for each category?
  or
  do you want to have a sum of quantitiy for each product group code?
  
  To which field belongs the "period of time"..f.e. "order date"?
  
  regards
  jetsetter

• 0
  
  Jet Reports Historic Posts February 17, 2014 16:02

  Hi,
  
  thanks for your reply.
  
  I need both sums, for the categorie and also inside the categorie the sums for each product Group:
  
  e.g.:
  CATEGORIE A = 1.000 pcs, PRODUCT GROUP CODE 1 = 600 pcs, CODE 2 = 300 pcs, CODE 3 = 100 pcs
  
  the Period of time belongs to the delivery date / shipment date

• 0
  
  Jet Reports Historic Posts February 18, 2014 07:52

  hi,
  
  thanks for the example.
  is it possible, that f.e. PRODUCT GROUP CODE 1 is in CATEGORIE A and also in CATEGORIE B?
  see attached file, should be something like this:
  
  Product group 1 3.500pc
  Product group 1 - Categorie A 1.000pc
  Product group 1 - Categorie B 2.000pc
  Product group 1 - Categorie C 500pc
  
  Product group 2 2.500pc
  Product group 2 - Categorie A 1.500pc
  Product group 2 - Categorie B 0pc
  Product group 2 - Categorie C 1.000pc
  
  Product group 3 0pc
  Product group 3 - Categorie A 0pc
  Product group 3 - Categorie B 0pc
  Product group 3 - Categorie C 0pc
  
  but the attached file should only be an starting point for you, this is not a "ready-to-go"-report……!!
  there also might be other ways to go…even better ways..!!
  but give it a try..and a feedback…
  
  regards
  jetsetter

  • jet item.xlsx
• 0
  
  Jet Reports Historic Posts February 19, 2014 07:13

  Hi,
  
  yes it is possible. Thanks for sending the file. I will have a look and send Feedback soon.
  
  thanks!!!!!