I have a pivot-table and want to optically divide the table with borders at the bottom of a dimension-cell across the whole row. Because I don't know how to exactly explain it, I've attached a image. What I need are the red lines in the image.
When I set a border for the dimension, then the border will only show in the first column.
When I set a border for the formulas, the border is in every row, not only at the bottom of the first dimension.
Another solution for me would be to have alternating background colors based on a dimension, but for the whole row. I've attached another image to illustrate this.
I hope there is a way to do this, because this makes the reading of the table much easier.
