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.
