COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: anilkumar on 12 Apr 2009 08:00:21 AM

Title: running-average crosstab report(its very urgent)
Post by: anilkumar on 12 Apr 2009 08:00:21 AM
hi guys
thanks in advance

i have to show every month average say  like below

jan  feb  mar apr may jun jul aug sep oct nov dec     total    thi ismy report
10    20  30   10  40   20  30  20  20  70 40    10      320

if i select JAN  in the prompt     average
                                                 10
               MARCH                        20
                 MAY                          22
IF I SELECT DEC                           26.6

total division by every month


please urgent

thanks and regards
anil kumar