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
:)