If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Selected years in columns - Help please

Started by Cognosnewbie14, 21 Mar 2014 03:50:34 AM

Previous topic - Next topic

Cognosnewbie14

Morning all! Hoping someone can help today.  :D

Basically i am creating a crosstab report and i wish to have the timeline in columns and rows as the various measures. Basically the columns represent years and i am trying to figure out how to show years 0-10 as individual years, then a total 10 year column, then finally a column for the 11th year.

Currently I have inserted the Year object twice into columns and set the expression as :

case
   when [Fiscal Year Name] between #$[RelSubToFiscYearName]{  prompt('Submission','token','Current')   } # + '0'and
   #$[RelSubToFiscYearName]{  prompt('Submission','token','Current')   } #  + '10'
   then [Fiscal Year Name]
end

and the 2nd column as:

case
   when [Fiscal Year Name] between #$[RelSubToFiscYearName]{  prompt('Submission','token','Current')   } # + '11'and
   #$[RelSubToFiscYearName]{  prompt('Submission','token','Current')   } #  + '21'
   then [Fiscal Year Name]
end


but when i run the report for some reason it also shows 2 columns with figures which appears to be sum of all years and its column headers are blank? Firstly how do i remove this and then secondly how am i able to insert a total summing years 1-10 which sits after the 10th year and before year 11?

please say if more info is needed and apologies if i've not explained it very well!

thanks in advance

:)