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.
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.