Announcement

Collapse
No announcement yet.

How to consolidate master - detail

Collapse
This topic is closed.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to consolidate master - detail

    Hi all,

    I need help with the following report format :


    Currently, i have this fields
    dept
    class
    date
    qty

    This is sample of the datas
    dept | class | date | qty
    Supermarket | toys | 2014-9-1 | 2
    Supermarket | toys | 2014-9-3 | 3
    Dept Store | Fashion |2014-9-1|10
    Dept Store | Fashion |2014-9-2|1
    Dept Store | Bangle | 2014-9-1|5

    What i want is to produce a grid report like this :


    Dept Class Qty
    -------------------------------------------
    Supermarket
    Toys 5
    Dept Store
    Fashion 11
    Bangle 5


    Currently, if i use group by i can only come up with

    Supermarket
    Toys 2
    Toys 5
    Dept Store
    Fashion 10
    Fashion 1
    Bangle 5



    Any help will be very much appreciated.

    Thank you

  • #2
    You must group by two keys dept and class.

    Comment


    • #3
      Thank's a lot.
      I tried but didn't put it into summary.

      After i choose summary & it worked !
      Thank's

      Now left with the format

      Comment


      • #4
        Then it's solved to close the thread?
        /Giuseppe

        Professional Scriptcase Services
        Some Customers opinions

        Comment


        • #5
          Giu,

          you can close it.

          Comment

          Working...
          X