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

[kmcgilli]

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?

[Cognos_Jan2017]

Try making your calculation as a Singleton.

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