Skip to Content
0
Jul 02, 2020 at 01:53 PM

How to add/show 1 particular gridline on Cross-Tab

59 Views

On my Cross Tab I have the following:

1 Column (Month)
2 Rows (Customer and Year)
Calculated Member #1 (Change in Rev)
Calculated Member #2 (% Change)

The totals for the rows have been suppressed.

I would like to be able to add a Horizontal GridLine separator after the % Change Calculated Member. This will add separation based on Customer. There are many customers and all the number "blend" together without a separator. I have tried to use the Cross Tab Expert > Format Grid Lines button, but it only allows to me to show ALL horizontal grid lines. Which will not work as it ends up looking like Excel and becomes just as difficult to view and make sense of the numbers.

Any suggestions would greatly be appreciated.

See my image below. The blue line is where I would like to draw the black horizontal separator.

Attachments

192.png (15.8 kB)