Print Page - Date calculation in crosstab as column- Want this to be shown but not calc data

Title: Date calculation in crosstab as column- Want this to be shown but not calc data
Post by: kmcgilli on 20 Dec 2019 10:48:40 AM

I have a date calculation - _add_days(cast([Week 1], date ), -21) - that displays the week ending 4 weeks ago. I have added this as a column and want it to display the date as the top column of my crosstab (i.e. Nov, 23rd 2019), but not calculate the the data below... Every time I add this column (above the column I actually want calculating the data) it changes the numbers...

Can you add a crosstab space so it just displays and does not calc the values?

Title: Re: Date calculation in crosstab as column- Want this to be shown but not calc data
Post by: Cognos_Jan2017 on 21 Dec 2019 05:46:41 AM

Try making your calculation as a Singleton.

Then unlock your top column, drag in that Singleton, and lock.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: kmcgilli on 20 Dec 2019 10:48:40 AM