Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Need create a table to show revenue performance by division. We don't want to use number. We want to use picture. First need compare revenue with target then compare revenue with prior year. If the revenue meet target then Green color and if the revenue is increase vs last year than up arrow.
Division | Revenue | Description |
Division 1 | green up arrow image | Meet target and increase |
Division 2 | red down arrow image | Miss target and decrease |
Division 3 | green left-right arrow image | Meet Target but no increase |
Division 4 | blue left-right arrow image | Exceed target but no increase |
Please help. How can I show those pitures in table .
Any help is greatly appreciated.
Thanks.
D
Hello,
You can use the predefined images from QV. In Edit Expression Window, select image from Image tab and paste the code. Your expression should be as Image in representation field into Display options section of Expressions tab.