Segmenting customer by removing sales order of specific products

[former_member1048271]

Hi All,

Is it possible to segment a customer by removing/filter products from its total orders? i.e., customer have 1500$ total orders But out of that 1500$ I want to remove a specific sale of specific product and not count it to the total order of the customers.

Is it possible with marketing cloud?

Please advise and thanks in advance

- Glenn

[former_member27]

Hi gmreales,

Welcome to the SAP Community! Thank you for visiting us to get answers to your questions.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Secondly, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html as well, as that will help you when submitting questions to the community.

Second, if you're interested in connecting with community members, please pay a visit to our new Welcome Corner thread with advice from our champions. You'll need to sign up, but it's a great way to interact with peers and get to know other experts!
https://groups.community.sap.com/t5/welcome-corner-discussions/advice-from-sap-champions-questions-a...

Finally, I recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

Regards,

Dedi

[KunalBansal]

Hi Glenn,

I understand your scenario, but as per my experience, you can filter down on order value as it's an accumulated/calculated field.
You can only filter them if they are coming as separate interactions with dates or any attribute.

Hope this was hopeful to close the thread.

Thank you.

Best Regards,

Kunal Bansal, SAP CX Architect