I wonder how you can group-by list properties.
Specifically, as in the attached file, I would like to have figures by properties (category: Fruit/Vegetable) as shown as "Desired Result" Thankyou in advance..
Basically, you are looking to group/aggregate by an attribute.
There are two basic ways to aggregate by an attribute:
Now, Product Category may be referenced from the Products list itself (i.e. a property in the products list), or sometimes its a (hidden) line item in the Product Sales module. The result is the same either way.
Thank you, Paul.
I"ll definitely go for option 2 which is exactly what I was looking to.