Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: tamise on 01 Jul 2014 01:33:28 PM

Title: Crosstab month cumulative
Post by: tamise on 01 Jul 2014 01:33:28 PM
Hello,

I do not manage to create a crosstab with cumulatice amounth.
Indeed, for instance i have create this crosstab with a simple query from report studio :

                    Janv           Feb            Mar         
Account         100           10              20


My aim is to create this crosstab with cumulative amounth :

                    Janv           Feb            Mar        
Account         100           110            130


Can you please give me some clue ?
I have tried to use running-total, ..... but it is not working.

Thanks.
Title: Re: Crosstab month cumulative
Post by: MFGF on 10 Jul 2014 11:41:32 AM
Quote from: tamise on 01 Jul 2014 01:33:28 PM
Hello,

I do not manage to create a crosstab with cumulatice amounth.
Indeed, for instance i have create this crosstab with a simple query from report studio :

                    Janv           Feb            Mar         
Account         100           10              20


My aim is to create this crosstab with cumulative amounth :

                    Janv           Feb            Mar        
Account         100           110            130


Can you please give me some clue ?
I have tried to use running-total, ..... but it is not working.

Thanks.

running-total works fine for me.

MF.
Text only | Text with Images