"Hiding" One Column in a Crosstab

[Cognos_Jan2017]

We have a Crosstab with 3 columns (a Query Item, and 2 calculated Data Items).

These 3 Columns will appear under [Fiscal Year] always for only two Fiscal Years.

The problem ... As an example, we will show FY17 and FY16.  Mgmt wants to see all 3 Columns under FY17, but ONLY 2 of those 3 Columns under FY16.  Is there a way to somehow show a Column calculation for ONLY FY17 but NOT for FY16?

We may be able to calculate 5 of those 6 Columns and present them in a List coding the Data Item labels.

Thoughts please.  TIA, Bob

[New_Guy]

Hi,
Please refer to the below post.
http://www.cognoise.com/index.php/topic,33386.0.html
Good luck
New guy

[Cognos_Jan2017]

Thank you New guy.  LOT there for me to learn which I will do.

I wound up writing a List displaying 8 Columns.

I used techniques I learned from Cognoise guys the last few months including ...

1 - SelMMYY = _make_timestamp (extract(year,?p_EndDate?),extract(month,?p_EndDate?),1)

2 - TimeL = _make_timestamp ([Calendar Year],[Calendar Year Month #],1)

3 - LTMonths =_months_between ([SelMMYY],[TimeL])

4 - LatestHours (for Current Fiscal Year)
Case
When (extract(month,?p_EndDate?)=10 and [Q_TPRR].[LTMonths] = 0)  then [Q_TPRR].[Employee and Supervised Contractor Hours]
...
When (extract(month,?p_EndDate?)=9 and [Q_TPRR].[LTMonths] between 0 and 11) then [Q_TPRR].[Employee and Supervised Contractor Hours]
End

Works great as a List.

Thanks to ALL the Cognoise guys who taught me how to do this.