3 Replies Latest reply: Feb 15, 2012 6:25 AM by Henric Cronström RSS

    Problem with Hierarchy

    Hugues DEL PINO

      Hi,

      I have imported a group of table that contain the following informations:

      - sales table containing customer numbern item number and turnover

      - customer table containing customer number, name of the customer, and hierarchy (differents customers belong to one hierarchy)

      - items table containing item number and product name

      - items list containing the hierarchy number and the item numbers (those items must obligatory be sold in this hierarchy)

       

      Using those datas, it is very easy to obtain the sales by customers, by item, by hierarchy... But what I want to show is the sales by hierarchy with products grouped by 2 categories. the first category is the items that must be sold in the hierarchy, and the second one the other items sold but not listed for the selected hierarchy. See my example in qvw, and the excel spreadsheet for datas.

       

      regards