Grouping question

Grouping question

• Larry Buerk

  Excellent, thanks!!

  sluggy

  
  

• Aquilegia

  Sounds like those three matrics are using the same dataset. In that case, you should be able to remove the dataset set on these matrices respectively. Add a list that includes the three matrices, set the dataset on the list, and add a group on the list by the product.
  
  

• Mark Leung

  There are multiple ways to do this:

  1. Add a copy of the original matrices outside of the list.

  2. Use a matrix instead of list to host the three matrices, add a matrix row group by product, and enable subtotal on the row group. This way you will automatically get the matrics across all products in the subtotal row.

  
  
  

• Ethan Hunt

  Thanks Fang,

  that did the trick nicely.

  One further (possibly stupid) question: how could i then have a set of matrices at the end with the totals (ie the aggregations across all products) Should i just have a copy of the original matrices and make them invisible if there was only one product selected Or is there a more proper or cooler way to do it

  Many thanks,

  sluggy

  
  
• Grouping question