Pivot table merge expression column ?

[#1]

Hi,

Is it possible to merge two columns expressions?

For example, I have this tab :

I would like this result :

I tried to concat image with value in a same expression but it's doesn't work.

Do you have an idea to do this?

Thanx

[francoiscave]

Hi Mathieu,

You can't merge properly image and expression result.

You can trick with a image column (.png and color background) and tour expression column to "mislead"...

François

[#3]

Hi Beaulieu,

We can not merge two columns because for image we choose Image representation there we can not display text and chart both.but

you can do one thing decrease the cell width and change the data orientation from right to left,then it will look aside to each other.

[PrashantSangle]

Hi,

Yes You can.

Write both expression in one columne use '&' to concat result of two expression.

Like

Expr1 & '    ' &Expr2

Regards

[#5]

Ok,

Is it possible to change the color of this column line ? (red box below) :

Thanx

[#6]

no we can not change the color of column line

[PrashantSangle]

Hi,

Did you try with '&'

Regards

[#8]

Ok, but i haven't two real expressions. I have 1 picture and 1 expression.

I had already tried with " & " and it doesn't work.

[francoiscave]

Hi Mathieu,

Have you try to get Wingdings as Font to have the tumb icon... This the link below:

Use of Icons in Design

That's not possible unfortunately for just one expression. You get to choose only one font for the entire straight table. But it could be useful...

François

[#10]

Do you think i could draw a  picture mask with Gimp and add this to background ?