Monday, March 19, 2012

data presentation at each level

I have a table with Columns as metric id, product name, product id, sales, amount.

The values of the column metric id will be 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.

Go to your layout, click on the Details row of your table and right-click then select "Edit Group". You should see an area labeled "Group On", if you click the first row there it will bring down a list of fields, pick the field that you want to group by.

No comments:

Post a Comment