Print Page - Crosstab cells shifts when i hide a column with box type none

Title: Crosstab cells shifts when i hide a column with box type none
Post by: mrh on 25 Jan 2019 06:23:41 PM

Hi,

I have dashboard with columns: Year (q1,q2,q3,4) and row (country group, country desc), when i hide country group using box type none the formatting for overall table get's distracted column with q1 values shifts in and q4 becomes blank.

Can anyone help me to fix this:

Thanks

Title: Re: Crosstab cells shifts when i hide a column with box type none
Post by: Reinhard on 28 Jan 2019 08:26:17 AM

Try cutting the column out with Strg+X

Title: Re: Crosstab cells shifts when i hide a column with box type none
Post by: oscarca on 28 Jan 2019 09:05:30 AM

Hey mrh,

Hiding rows and columns can always be a little tricky.
Instead of block type to none, click on the Unlock button in the Analytics toolbar in the top right. The icon should change to an open
lock (unlocked). Now select the <#Country group#> text item (not the whole cell) and delete it.
Select the empty crosstab node left after deleting the text. Change its Padding to 0
pixels in all directions.

Hope this will help you!
Best regards,
Oscar

Title: Re: Crosstab cells shifts when i hide a column with box type none
Post by: mrh on 08 May 2019 01:02:04 PM

Thanks oscarca and Reinhard. This was a low priority on my list and solution worked.

Title: Re: Crosstab cells shifts when i hide a column with box type none
Post by: oscarca on 09 May 2019 07:07:59 AM

You are welcome!

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: mrh on 25 Jan 2019 06:23:41 PM