Using Calculated Items for aggregating more than 2 list items

You can create a new Product Group dimension containing the items Product M and Product S. Next, map each individual product to its corresponding group as shown below.

Finally, add the Product Group dimension to your table to enable sales aggregation at the group level.

Hey ​@Min Li,

Thanks a lot for the suggestion.

We did consider this approach but it doesn’t fully meet the requirements.

​@Rushi didn’t mention there are other products line without any bundle associated so if we follow that path

1. We will end up with bundles on top if unless we create additional dummy bundles to ensure every product line maps to one.
2. However, if we map all product lines to a bundle, it aggregates the unique ones — which makes the setup redundant.  

   

    

    

Basically, what we’re trying to achieve is to display calculated items at the bottom of our grid for specific product lines. It works for the 5400s, since there are only two items in that bundle, but not for the 7500s, which include three.
We also tried using cumulate on the calculated item, but it didn’t work since the items aren’t sequential.

Yes that’s what we ended up doing with ​@Rushi . Having more than 2 items on Calculated items could be a great idea !

Hi ​@Min Li, Thanks for sparing time for helping us, yes we solved it by creating additional metrics with  group dimension which had list items say product M series instead of Product list which had list items say Product M-100, Product M-200,
​@CDALMAY Thanks for helping me as always