COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: tmccurry on 19 Sep 2013 04:01:49 PM

Title: period over period variance in crosstab
Post by: tmccurry on 19 Sep 2013 04:01:49 PM
I am attempting to create a crosstab with the measure broken into size groups on the horizontal axis on top and time periods on the vertical axis.  I would like to get period over period variance for each size group.  I created a data item using nested IF-statements called "Segment Group" to break the measure into size groups.  I then created a data item called "Measure Variance" using "running-difference( ( measure) for (segment group) )" to use in the crosstab to attempt to get the period over period variance.  When I do this, the output gives me a total variance for that period just in the first column and leaves the rest of the columns blank, rather than giving me a variance for each "segment group" as I wish.  Any ideas on this problem I'm having? Thanks in advance!