Pivot Table with conditional image

[marco_puccetti]

Hello, i need to insert in a pivot table a graphic image that show the trend of two period (if the percentage is >0 upper arrow, if the percentage <0 down arrow).

Can you show me the sintax to use?

Thanks

Marco

[sunny_talwar]

Have a look at the attached picture

I hope this will help.

Best,

Sunny

[sunny_talwar]

Make sure you use a expression like

If(Percentage > 0, Image1, Image2)

Best,

Sunny

[jonathandienst]

1. Use something like this for the expression:

=If(percentage > 0, 'qmem://<bundled>/BuiltIn/arrow_n.png', 'qmem://<bundled>/BuiltIn/arrow_s.png')

(replace the condition with correct expression for your application)

2. Set the Representation for the expression to 'Image' and adjust the Image Formattting options to your taste.

HTH

Jonathan

[jonathandienst]

You can also select coloured arrows if you like, eg green for up and red for down. The built in images are available in the expression editor and you can paste the image's text from there.