Matrix Report and its column aggregates

hello everyone,
We have the following scenario, and are struggling to get an efficient
way of doing this...
We have a matrix report that looks something like this
_______________________
| | Column Header |
---
| | Sub Col1 |Sub Col2|
---
| Date | Value Value |
---
We have to evaluate a number of additional attributes - like mean, std
Deviation,max value, min value, etc for each of the columns (the total
sub columns can vary between 1 and 9).
this additional info has to be shown in a seperate table/matrix -
|Statistics |Sub Col1|Sub Col2|
---
|Mean | 1.5 | 2.5 |
---
|S.Deviation | 0.5 | 1.5 |
---
|Max Value | 3.5 | 4.5 |
---
i know that aggregate functions are available to get this info, i am
just not sure how i can show this in the second matrix. Also i want to
avoid calling the stored proc twice as this might slow down the report
(the number of rows can be around 5000).
Any suggestion that would lead to an optimum solution will be swell...On Nov 27, 7:17 pm, Sid <sid.pras...@.gmail.com> wrote:
> hello everyone,
> We have the following scenario, and are struggling to get an efficient
> way of doing this...
> We have a matrix report that looks something like this
> _______________________
> | | Column Header |
> ---
> | | Sub Col1 |Sub Col2|
> ---
> | Date | Value Value |
> ---
> We have to evaluate a number of additional attributes - like mean, std
> Deviation,max value, min value, etc for each of the columns (the total
> sub columns can vary between 1 and 9).
> this additional info has to be shown in a seperate table/matrix -
> |Statistics |Sub Col1|Sub Col2|
> ---
> |Mean | 1.5 | 2.5 |
> ---
> |S.Deviation | 0.5 | 1.5 |
> ---
> |Max Value | 3.5 | 4.5 |
> ---
> i know that aggregate functions are available to get this info, i am
> just not sure how i can show this in the second matrix. Also i want to
> avoid calling the stored proc twice as this might slow down the report
> (the number of rows can be around 5000).
> Any suggestion that would lead to an optimum solution will be swell...
Any suggestions from the experts?