[Resolved] How to calculate sum of custom numeric field with group by in view

[Author]

Posts

[insooJ]

Tell us what you are trying to do?

I'd like calculate custom fields in view with DISTINCT , GroupBY
For example,

id buyer seller product amount
----- ------ ------- ------ ------
1 A X tv 100
2 B X tv 50
3 A X tv 200
4 B X radio 300
5 B Y radio 400

I want the results like below .

1) DISTINCT product
: tv
radio

2) sum groupby product per buyer

buyer product sum count
-------- ------------ ------ -------
A tv 300 2
B tv 50 1
B radio 700 2

How can I get them?

Best regards,
Insoo

[Minesh Supporter Languages: English (English ) Timezone: Asia/Kolkata (GMT+05:30)]

Hello. Thank you for contacting the Toolset support.

Well - There is no native feature available to group by custom field values, you need to write custom shortcocde.

However - I've one example to share with you (not exactly as you want but this will give you idea) which may help you:
=> https://toolset.com/2013/10/how-to-group-views-results-by-year-and-month/
[Check with above link how posts are grouped by year and month]

This needs custom programming for this which is beyond the scope of our support policy. If you need custom programming for your project, please feel free to contact our certified partners:
=> https://toolset.com/toolset-support-policy/

[insooJ]

Thank you for your effort.