Skip to main content
Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Unanswered

I have a question when creating a table in Measures.

(2) ShareShare
ReportReport
Posted on by 5
I have a few questions.
 
1) Through Measures, I want to create the total purchase amount for each customer, the number of purchases by product category, and the purchase amount.
 - ex) 
 - Total_Amount is the total amount the customer has purchased so far, regardless of category.
 - Category_total_amount and Number of purchases by category are the amount and number of purchases by product category.
 
2) Also, is it possible to create the number of purchases per month, purchase amount, average purchase amount, number of purchases between 2 centers, purchase amount, etc. in one table?
 

Is it possible to implement this in Customer Insights?
 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Holly Huffman Profile Picture

Holly Huffman 103

#2
Muhammad Shahzad Shafique Profile Picture

Muhammad Shahzad Sh... 96 Most Valuable Professional

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 51 Most Valuable Professional

Product updates

Dynamics 365 release plans