<p>I have a cross tab that has 3 group bys. The outermost group by, I apply a filter to so that it ends up being only one entry in my group by. Since every cell in my cross tab is part of this group, I want to hide the display of that group. How would I do that? </p><p> </p><p>Here are screenshots to show what I mean:</p><p> </p><p>I want to hide the column on the far left. </p><p><img src='
http://i.imgur.com/tfsvL03.png' alt='Posted Image' class='bbc_img' /></p><p> </p><p>When I click the data element in the cell and select "Visibility" then check the "Hide Element" box, the data element is hidden, but the column still remains.</p><p> </p><p>When I right click the column and select "Show/Hide Group Levels", then uncheck the level in the dialog that pops up, I am no longer allowed to click "Ok". So how would I hide this column but still use it in my group by?</p><p> </p><p>Additionally, how would I prevent the empty boxes above my headers from appearing?</p><p> </p><p>Thanks!</p>
