Show the average of dataset per ProductCagegory in straighttable.

[thymenkristen]

HI all,

Currently I'm working on a customer churn project. Therefore we are preparing a dataset which contains several variables. After the first attempts of creating a model, we decided to include some more variables.

In this case, I'm trying to realize to show  the Total  'Orderfrequency' avg(DagenTussenOrdersProduct) for each ProductCategory (ProductCategorie).

My goal is to show the outcome displayed in the 2nd column (see table below), in a straight table which shows per customer all productcategories with the 'total average orderfrequency' in each row.

The dimensions of this straight table are: Customernumber, RepLevel2, RepLevel3 and Productcategorie.

For now I can only get the total of the OrderFrequency, but im interested in the individual values of the first table.

Expression used in straighttable: =avg(TOTAL {1<DebiteurNummer=, RepLevel2=, Replevel3=>} DagenTussenOrdersProduct)

I'm looking forward to your replies.

Thanks in advance!

Regards,

Kristen