Forum Discussion

RobHess05's avatar
RobHess05
Icon for Helper I rankHelper I
4 years ago
Solved

Selectively removing columns from a Matrix

Good morning.    I'm want to add a new column called Planned to my Matrix

 

I added it to my Values

 

I now see it in the Total column as expected, but I also see it in the weekday breakdown.


How can I remove just the Planned column in the weekday breakdown?   When I click on Exclude, it removes the entire column (Total Hours and Planned for Thursday) 

 

FYI, I played with the fomatting, but the Column subtotals doesn't achieve my goals.

 

Thank you for reading.

 

  • A simple hack is to drag the column's right boundary to the left to "hide" the rogue columns. You do need to turn off  "Word wrap" in the formatting pane though