Aggregation Aggression

[thoracalis]

Hi!

I have problems with getting my aggregates right, looking for help.

Attached to this text is a PDF showing both data and an explanation of the problem.

In short, I have a crosstab with 1 Measure and 2 Dimensions (Date and KPI)
On Columns I have the Date-level "Month"

On rows I want one calculation which is causing me a headache:

I want to calculate the average of KPI 4, 5, 6 for the current month and then divide this value with the average of KPI 41 for the last 12 months.

[bi4u2]

Thoracalis,
One word of advice when trying to do a complicated crosstab: make sure you can create the results you want in a list report first. Once you do that, you can certainly get the crosstab to work out.