Hi, I have following report in  Cognos. Where 202402 and 202502 are coming from field "Period", Global is coming from field "Visibility", Sales is coming from field "Sales" and Field "Difference" is a calculated field. Now my requirement is I want to hide/remove field "Difference" from Last Year Period and will show only for current year. Could you please let me how can I do this? Thanks in Advance.

Current Report:

Required Report

Create a prompt that the user chooses in the prompt page with Hide or Show Difference. Then select the Difference field (the whole field) create a Conditional Advance Style where ParamDisplayValue('p_Hide') = 'Hide' and in this condition in the formatting options apply Non-Inline..

GDM

Hi, I have following report in  Cognos. Where 202402 and 202502 are coming from field "Period", Global is coming from field "Visibility", Sales is coming from field "Sales" and Field "Difference" is a calculated field. Now my requirement is I want to hide/remove field "Difference" from Last Year Period and will show only for current year. Could you please let me how can I do this? Thanks in Advance.

Current Report:

Required Report

Thanks for your reply. But I want to hide it for last year only. For example, I have one prompt page where user can enter Period values. If user can enter 202502 then report will show values for 202502 and 202402. Now my requirement is, I want to show the difference for current year 202502 but want to hide/remove for last year which is 202402. How can I implement this?

Create a prompt that the user chooses in the prompt page with Hide or Show Difference. Then select the Difference field (the whole field) create a Conditional Advance Style where ParamDisplayValue('p_Hide') = 'Hide' and in this condition in the formatting options apply Non-Inline..

GDM

Hi, I have following report in  Cognos. Where 202402 and 202502 are coming from field "Period", Global is coming from field "Visibility", Sales is coming from field "Sales" and Field "Difference" is a calculated field. Now my requirement is I want to hide/remove field "Difference" from Last Year Period and will show only for current year. Could you please let me how can I do this? Thanks in Advance.

Current Report:

Required Report

Hi, I have following report in  Cognos. Where 202402 and 202502 are coming from field "Period", Global is coming from field "Visibility", Sales is coming from field "Sales" and Field "Difference" is a calculated field. Now my requirement is I want to hide/remove field "Difference" from Last Year Period and will show only for current year. Could you please let me how can I do this? Thanks in Advance.

Current Report:

Required Report

What sound's quite a simple question is actually quite a tricky problem. This is because you have nested columns within your crosstab.  

I will assume that you have built your crosstab by nesting measures Revenue and Difference under the year.

If I simulate your problem with Go Sales with a relational data source.

Here is the original crosstab in design mode:  

and gives this data :

We want to hide the Difference Column in everything but the last column. I have simulated this by just using a conditional style based on the year. 

You can see in this conditional style that the selected items are only visible. And when this runs it produces :  

This has indeed hidden two of the difference columns! We only have one difference column. But all of the columns have been shifted to the left. The revenue columns are no longer lined up with the year columns! We have three Revenue columns and one difference column.  

And this is why this problem is really complex for nested columns. Whilst we can hide columns, all column get shifted across!

Because of the nesting I don't believe we can solve this problem using the original crosstab design and conditional styles.

But there IS a solution. It's a bit complicated, but it is possible.  

How did I achieve this?

The trick is in the data. Instead of nesting measures, I have nested a data item:  

If I look at the data and pick a country, then the rows of data I get back for this are :

You can see I only get a Difference Row in 2018 - the last year. And this is the trick, you need to get your data looking like this.

You need your query to return a Revenue row for every year, and a difference row for only the last year.

In this example I have achieved this like so:

My crosstab is based on Query 1 :

Query 1 is a union of a Revenue Query, and a Difference Query.  

The revenue query looks like:  

1. You can see it includes all years.
2. The Measure Name column simply contains 'Revenue'
3. The Measure column simply contains the revenue measure.

The difference query looks like:

1. It only contains the last year
2. Measure name is simply 'Difference'
3. The Measure contains the difference calculation.

Obviously these are simple examples and your query for difference will need to do something like Year = Maximum( Year ).

But this is the framework for achieving what you want.  

I have attached this example report.

Hi, I have following report in  Cognos. Where 202402 and 202502 are coming from field "Period", Global is coming from field "Visibility", Sales is coming from field "Sales" and Field "Difference" is a calculated field. Now my requirement is I want to hide/remove field "Difference" from Last Year Period and will show only for current year. Could you please let me how can I do this? Thanks in Advance.

Current Report:

Required Report