Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
| |
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
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
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)
))