Adding a single line or double line to a pivot table

[#1]

HI Everyone,

Does anyone know how to add a line or double line to a pivot table.  I need them for some financial apps.  I know you can underline the text but I want the line to go all the way across the pivot table or at least put a line (border) on the bottom of the cell.

See attached.  thank you so much,

[ecolomer]

Yes it is possible.

First you need to put option On the Options Design User in User Preferences

and in the menu of the table select option to change table

[ecolomer]

Sorry, but my QV version is spanish version

[#4]

HI Enrique,

That's fine I figured out what you meant by the pictures.  That won't work for what I'm trying to do - I only need the single/double line under one of the rows, not every row and that's what it is doing.  I was hoping there was a formula that would do this.  Thanks anyways - this is good to know.

[ecolomer]

You can change the lines bottom & Up, and the colour and the cursive, and .....

[#6]

Hi Enrique,

Wow, that would be cool if it would work for my pivot.  See what it's doing?  We just want the lines under the specific rows (Margins) and then it's not working in the Qtr-Year expression correctly.

Trying to insert another file and can't do it.  It's putting the double line under each row and then for the Qtr-year it put the double line to the right of the Qtr-year.

[martynlloyd]

Would you consider changing the background colour of the row instead?

regards,

M.

[#8]

I also tried that but can not change the color in those 2 columns.  I wanted to hide the blank column, which is where the Qtr-Year header is displayed, but could not do that in the pivot.  I thought there would be a formula to add just the color to those cells.

[ecolomer]

That is because you change in all Dimensiones, you can change it only in a single cell

[martynlloyd]

You can use Dimensionality

I tried a little experiement with changing the background colour of a dimension using

if(dimensionality()=0, LightRed(),
if(dimensionality()>=2, LightBlue(),Green()))

Rather tedious if you have a lot of dims or expressions...

regards,

M.