7 Replies Latest reply: Oct 20, 2017 7:20 AM by Felip Drechsler RSS

    Trending of sales

    Rani Bosch

      Hi, I've got a field called TRENDING CODES.


      In this field I've got the following values:


      1. MFGTYPE

      2. PACKSIZE


      each of the above mentioned fields are then linked to anothre table called dimension values.

      so basically it can be broken down as follows:


      1. MFGTYPE:

           a. hand pack

           b. machine pack


      2. PACKSIZE:

           a. 30g

           b. 100g

           c. 450 g


      i would like to create a trending chart where i group the sum of sales per month for MFGTYPE hand pack vs machine pack


      and then another chart where i compare the same as above, but only for the pack sizes.


      how do i do this on the object in my design?????