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

[mrh]

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

[Reinhard]

Try cutting the column out with Strg+X

[oscarca]

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

[mrh]

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

[oscarca]

You are welcome!