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?