Summarise data by average in OLAP cube
 

The OLAP cube will only summarise data by COunt, SUm, MIn and MAx and i need
to summarise by average.
I have 500,00 records so using a standard pivot table will not suffice as i
am limited by excel page size.
Any ways to create an OLAP cube that will summarise data by average?

Summarise data by average in OLAP cube
 

Which "OLAP cube" ?
There's 1 implementation out there...

... and can't you divide Sum by Count ?

Tim


"Jonno McCarthy" wrote in message
...
The OLAP cube will only summarise data by COunt, SUm, MIn and MAx and i
need
to summarise by average.
I have 500,00 records so using a standard pivot table will not suffice as
i
am limited by excel page size.
Any ways to create an OLAP cube that will summarise data by average?

Summarise data by average in OLAP cube
 

it is an OLAP cube created from a database query.
I have created a pivot table with SUM and one with COUNT and have divided
these to create a table that is what i want, but i need this to be dynamic so
that when i change the data in the pivot charts, the data in the 'average'
chart also changes.
I was hoping to just create an OLAP cube with the data summarised by average.

thanks

"Tim" wrote:

Which "OLAP cube" ?
There's 1 implementation out there...

... and can't you divide Sum by Count ?

Tim


"Jonno McCarthy" wrote in message
...
The OLAP cube will only summarise data by COunt, SUm, MIn and MAx and i
need
to summarise by average.
I have 500,00 records so using a standard pivot table will not suffice as
i
am limited by excel page size.
Any ways to create an OLAP cube that will summarise data by average?