COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: pimogo on 29 Mar 2011 04:18:29 PM

Title: Adding calculated row at the end of a crosstab
Post by: pimogo on 29 Mar 2011 04:18:29 PM
Hi. Not sure this is possible, but can i add a row at the end of a crosstab that calculates a percentage growth by using the first and last row of data as the base of the calculation?

Crosstab example (not entire chart but enough to illustrate point)[/i]

row1             4
row2             6
row3             9
row4            10
%growth    150%


p.s. if its easier to have the growth table as its own table, thats fine too.
Title: Re: Adding calculated row at the end of a crosstab
Post by: AussiePete2011 on 29 Mar 2011 06:28:48 PM
Hi there

Not sure if this would work but you could add
1.  Crosstab space without facts
2.  Unlock the padlock in the menu
3.  Select the crosstab and then the cell to allow the content to be defined
4.  Drag a singleton into the cell
5.  Set the singleton to a query that contains the calculation

Just one suggestion.
There are likely more as this looks calculated Summary which could be accomplished by using an MDX statement in place of a total.

Have to have aplay and see
Cheers
Peter B