Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Have a look at the attached picture
I hope this will help.
Best,
Sunny
Make sure you use a expression like
If(Percentage > 0, Image1, Image2)
Best,
Sunny
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
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.