Fixed Lod to calculate sales from each customer than repetitive orders from customers

Question

I want to calculate the sales for a region from customer only once without repeating same customer again.If a customer has bought multiple product in a region then show the average of the sales from a customer for a region.

Answer 1

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.

Hope it helps you.