# Filter and Sum Bundle by product and by date **URL:** \ **Category:** Questions\ **Tags:** format-date, arrays, bundles\ **Created:** [July 31, 2026, 7:32am UTC](https://community.make.com/t/filter-and-sum-bundle-by-product-and-by-date/112793 "2026-07-31T07:32:01Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Yann\_K](https://avatars.discourse-cdn.com/v4/letter/y/9fc348/32.png) [@Yann\_K](https://community.make.com/u/Yann_K)\ **Post date:** [July 31, 2026, 7:32am UTC](https://community.make.com/t/filter-and-sum-bundle-by-product-and-by-date/112793/1 "2026-07-31T07:32:02Z")
### šŸŽÆ What is your goal? Get the Sales for each month, without consumes too much credits ### šŸ¤” What is the problem & what have you tried? After an API call, I retrieve an array of collections. Each collection represents a sale with specific properties, notably ā€œproductā€ and ā€œSalesdateā€. I want to group them by product (there are only two possible types) and by sales month in order to retrieve the figures afterwards. I found a solution using date filters after an Iterator and a Numeric Aggregator, but I have to run the API call for each date, which consumes a lot of operations/credits. I am also considering a solution with 24 branches (one for each month of 2025 and 2026), but that doesnā€™t seem optimal to me. How can I optimize this? ### šŸ”— Create public scenario page ### šŸ“ø Screenshots (scenario flow, module settings, errors) ![Capture dā€™eĢcran 2026-07-31 aĢ€ 09.22.04.png](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/e/3ec160d4beac7bac283894c3503834bccacbf1a2.jpeg) ---
**Author:** ![Stoyan\_Vatov](https://avatars.discourse-cdn.com/v4/letter/s/5daacb/32.png) [@Stoyan\_Vatov](https://community.make.com/u/Stoyan_Vatov)\ **Post date:** [July 31, 2026, 7:38am UTC](https://community.make.com/t/filter-and-sum-bundle-by-product-and-by-date/112793/3 "2026-07-31T07:38:26Z")
Yooo mate, you left your API key exposed. I deleted the link to the scenario. Please donā€™t do that. Switch to the new HTTP module and use the connections instead of leaving the key inside the module. For the question itself. Can you check the API documentation of the endpoint you are reaching to see if you can make different calls to get more of the data? Cause getting all orders for the day and having to do that 30 or 31 times for each month is excesive. ---
**Author:** ![Yann\_K](https://avatars.discourse-cdn.com/v4/letter/y/9fc348/32.png) [@Yann\_K](https://community.make.com/u/Yann_K)\ **Post date:** [July 31, 2026, 7:43am UTC](https://community.make.com/t/filter-and-sum-bundle-by-product-and-by-date/112793/4 "2026-07-31T07:43:16Z")
thanks for Api key I get all the sales in One Api call. But i try to merge them after by month of sales ---
**Author:** ![Stoyan\_Vatov](https://avatars.discourse-cdn.com/v4/letter/s/5daacb/32.png) [@Stoyan\_Vatov](https://community.make.com/u/Stoyan_Vatov)\ **Post date:** [July 31, 2026, 7:50am UTC](https://community.make.com/t/filter-and-sum-bundle-by-product-and-by-date/112793/5 "2026-07-31T07:50:01Z")
If you are getting all of them in one call, then you can use the Group By function in the aggregator to combine them in different arrays based on the month. ---
**Author:** ![Yann\_K](https://avatars.discourse-cdn.com/v4/letter/y/9fc348/32.png) [@Yann\_K](https://community.make.com/u/Yann_K)\ **Post date:** [July 31, 2026, 8:01am UTC](https://community.make.com/t/filter-and-sum-bundle-by-product-and-by-date/112793/6 "2026-07-31T08:01:19Z")
Yes this is what i have just done, but i cant manage to sum by value ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/2/82899d2301df276a469e9b3315093873404ea227.png) ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/1/31904028f806a91b9bae891a9ac97571ad505697.png) ---
**Author:** ![Stoyan\_Vatov](https://avatars.discourse-cdn.com/v4/letter/s/5daacb/32.png) [@Stoyan\_Vatov](https://community.make.com/u/Stoyan_Vatov)\ **Post date:** [July 31, 2026, 8:09am UTC](https://community.make.com/t/filter-and-sum-bundle-by-product-and-by-date/112793/7 "2026-07-31T08:09:09Z")
Can you show how the modules are configured and what the input data looks like? ---
**Author:** ![Yann\_K](https://avatars.discourse-cdn.com/v4/letter/y/9fc348/32.png) [@Yann\_K](https://community.make.com/u/Yann_K)\ **Post date:** [July 31, 2026, 8:14am UTC](https://community.make.com/t/filter-and-sum-bundle-by-product-and-by-date/112793/8 "2026-07-31T08:14:42Z")
![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/c/9/c9e6aeec41ada6baab7da209836651a66eab128a.png) ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/7/f/7f55ceb9cb7cf7949a8803b3d3392b05c99d6a10.png) ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/4/941485272982de4ab2190d73752e41579153aca5.png) ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/4/941485272982de4ab2190d73752e41579153aca5.png) ---
**Author:** ![Stoyan\_Vatov](https://avatars.discourse-cdn.com/v4/letter/s/5daacb/32.png) [@Stoyan\_Vatov](https://community.make.com/u/Stoyan_Vatov)\ **Post date:** [July 31, 2026, 8:21am UTC](https://community.make.com/t/filter-and-sum-bundle-by-product-and-by-date/112793/9 "2026-07-31T08:21:47Z")
Ok but why are you grouping them by the date? That is not doing anything since they have different dates. Group them by the month instead using a formatDate function. Then you can sum them by month and get the totals. ---
**Author:** ![zayZ](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/zayz/32/92835_2.png) [@zayZ](https://community.make.com/u/zayZ)\ **Post date:** [August 2, 2026, 8:39pm UTC](https://community.make.com/t/filter-and-sum-bundle-by-product-and-by-date/112793/10 "2026-08-02T20:39:51Z")
Yes, grouping by month fixes the date part. One detail from Yannā€™s screenshots though: he also needs separate totals for each product. I would skip the Array Aggregator here and place a Numeric Aggregator directly after the Iterator: Value: `value` Function: `SUM` Group by: `product` + `|` + `formatDate(salesDate; "YYYY-MM")` That way it gives him one output bundle per product and month, for example `voucher|2026-07`, from the same API response. So thereā€™s no need for extra API calls or monthly branches.