Straight table Expression (Image + Text)

[Anonymous]

hi Team,

I have a straight table of Month and ABC as dimension and Fee as Expression.

Month	abc	Fee
Jul 2018	TQ	1,315
Jun 2018	TQ	1,516
May 2018	TQ	1,485
Apr 2018	TQ	1,219
Mar 2018	TQ	1,277
Feb 2018	TQ	1,368

I want the expression to have the value + image saving up or down direction compared to previous month like below:

Proposed Table
Month	abc	Fee
Jul 2018	TQ	1,314
Jun 2018	TQ	1,516
May 2018	TQ	1,484
Apr 2018	TQ	1,218
Mar 2018	TQ	1,276
Feb 2018	TQ	1,367

please help

thanks

Sukhwant

[johnca]

Your images don't show but maybe something like the attached?

Essentially, use Month and abc as dimensions and then these expressions;

Expression 1:

Sum(Fee)

Expression 2: Set Representation to Image

If(Sum(Fee) > Above(Sum(Fee)),'qmem://<bundled>/BuiltIn/arrow_n_g.png',

     If(Sum(Fee) < Above(Sum(Fee)),'qmem://<bundled>/BuiltIn/arrow_s_r.png',

     'qmem://<bundled>/BuiltIn/arrow_e.png'

     ))

For lack of a better sideways arrow showing no change I used the gray right arrow. You can use anything else or omit it.

The sort order seems to have a dramatic effect if you try to sort on the Month. I had to sort on abc in order for it to work.

HTH,

John

[trdandamudi]

One more option where you can use the arrow in the same cell as the value is as below:

Dimensions:

     Month

     abc

Expression:

                         =Sum(Fee) &' ' &If(Sum(Fee) > Above(Sum(Fee)),chr(8593),
                                If(Sum(Fee) < Above(Sum(Fee)),chr(8595),Chr(8596)
                            ))