I don't know whether this is possible to achieve in Views, or needs coding.

I want to be able to display Drupal Commerce Orders in a table, one row per order (as in default list provided by Drupal Commerce). I want the first 3-4 columns to show order number, order total, name of purchaser and date. No problem so far, it all works fine.

Now the difficult bit. I then want to have a number of additional columns, one for each category of product (taxonomy), and where an order contains a sale for a line item in each category, I want just the sub-total for that category to appear in the right category column.

For example, an order might contain £10 for a shirt (category/term), and £5 for a scarf (category/term). In the row for that order, I want the £10 to show in the column under the shirt category, and £5 to show in the column under the scarf category.

In spite of much research I cannot figure how to do this, or if it is possible, without coding the table.

Any help would be appreciated.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.