hide column in a matrix

I'm trying to hide a column in a matrix. I have noticed that you can't just
set the columns visibility mode (no such proprty) so I tried the following:
1. set the visibility of the cells and lower level headers to hidden - works
but the upper level header still takes the space of the hidden lower level
column
2. set the column's width - it can't get an expression. and there is no way
of setting it to be 0 (0.03 is the min)
Any ideas?
Thanks,
EfiHello Efi,
Unfortunately, since the Matrix Column is used for show the Matrix data and
it could not be set to hidden.
You may need to use the Dynamic Group in the dataset.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Can you please elaborate on using Dynamic Group in the dataset.
Thanks,
"Wei Lu [MSFT]" wrote:
> Hello Efi,
> Unfortunately, since the Matrix Column is used for show the Matrix data and
> it could not be set to hidden.
> You may need to use the Dynamic Group in the dataset.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello Efi,
For example, you may use the Union All to Union the data set and add a
filter in the Matrix to filter the column.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.