locked
showing data rows at different regions or levels RRS feed

  • Question

  •  

    I have a table with metric ids as 101, 102, 103 etc..

     

    I need to create a report, in which I need to show up data as below:

     

    1 series -------

    metric 101:

    product name, product id, sales, amount

     

    metric 102:

    product name, product id, sales, amount

     

    metric 103:

    product name, product id, sales, amount

     

    2 series--------

    metric 201:

    product name, product id, sales, amount

     

    metric 202:

    product name, product id, sales, amount

     

    metric 303:

    product name, product id, sales, amount

     

    Please let me know, how I can show the rows of that table grouped for each metric id.

     

     

     

    Wednesday, August 8, 2007 2:34 PM