Hi Sindhu,
Create a calculated field with below Fixed LOD.
Cust - sales = { FIXED [Customer ID] : AVG([Sales]) }
Now drop the Region field along with the above created calculated field.
You can observe the sales per region, sales along with avg sales per customer for each region.
![](https://www.edureka.co/community/?qa=blob&qa_blobid=1544225009848882936)
Hope it helps you.