Grouping multiple columns in a view result for a report

Question

I have a requirement in which I need to display the stock report for an application as in the below image

I want to know how to group the Quantity, Batch no and Expiry date fields together in another column (Opening Stock) in Views. I am using Drupal 7 and Views 3.

Also I need a summary of the quantity in the footer of the view, for example sum of all quantity for a batch in the footer. Any help from the community is highly appreciated...

Answer 1

To group the quantity, Batch no and expiry date fields in another column, use the views secondary row module

Provides a way to split a views table row into two. In the table style settings, select a "Secondary row" option.

So if a table looks like this: Name | Description | Edit link | Delete link selecting "Name" as the secondary row option for "Edit link" and "Description" as the secondary row option for the "Delete link" will render two rows:

For summary of the quantity in the footer, use Views summarize

Enables an extra display style which displays summaries of a column on the last row.