Thursday, October 17, 2013

How to repeat column values on every row of the grid?

Even though it seems like the most simplest things to do, trust me it is really hard to find the setting that does that.
By default, the attribute column values are not repeated for every row of the grid (snapshot below)


But sometimes you want to see the grid with all the attribute values, like the one below.


It is particularly helpful if you have lot of metric rows for a single attribute. You might have to scroll a page or more to find the related attribute of any metric value. In these cases, it is much useful to have the attribute value repeated for each row. You can do this by changing this particular setting in Desktop Report editor.

Grid -> Merge Row Header Cells

This name seems to be so unlikely for the task it does, that it is super easy to miss it! I did many a times.

4 comments :

  1. Great tip, thanks! For Web users this option is in Tools > Report Options > General

    ReplyDelete
  2. Thanks for the post, very useful. Would like to suggest best training on Microstrategy visit
    MicroStrategy Online Training hyderabad

    ReplyDelete
  3. hey, I have a question. why is my button for " merge row header cell" is greyed out. cannot be selected or unselected.

    ReplyDelete