Help Please: Crosstab Intersection of Average Row, Total Column

[Todd129]

Hello to the gurus! Your wisdom is urgently needed

Background:

I have a crosstab table as follows

1) On the far right, was added 1 summarize column that is "total" of each row.
2) On the very bottom, was added 1 summarize row that is the "average" of each value in the columns above

Problem:

At the intersection cell of these two summaries, on the far bottom right, the cell is showing the "average" of each value in the "average" row. I do not need that. I need to display in this cell the average of the values in the "total" row directly above it.

Any insights? Many thanks to the people who take time from busy schedules to post on this board.

Kind regards, Todd

[raj_aries]

Hi Todd,

Please change 'Define Contents' property to 'Yes' and open the report lock.You can create a dataitem with the required calculation.

Regards
Raj

[Todd129]

Hi guys --

Many thanks for your assistance!

I took the steps listed below, and got an error I have never seen:

1) For my crosstab's TOTAL summary column, I unlocked the cell below, set 'Define Contents' to 'Yes'
2) I defined a data item

AVERAGE ( TOTAL ([Next Workflow Status]) )

To compute the average of the total summary row in this cell. I then received the below error:

OP-ERR-0025
The following OLAPPlanner internal error occurred: 'OPASSERT(p2Set->GetClass() == OPExpression::OP_EXPR_ITEM) in OPValueSet::IssueWarningComplexDetailAggIntersect() at OLAPPlannerValueSet.cpp:3201'

Any further help would be very greatly appreciated!

Kind regards, Todd