Up/Down arrow in Table Box

[bhavvibudagam]

Hi Experts,

Can any one please help me on  below requirement.

In a table box I have taken

Quarter as Dimension and Avg(ID) as Measure.

Next I have to calculate the Trend Column.

When the

Current Quarter Avg Count is increased by comparing with previous Quarter Avg count  then the Trend is --Up Arrow

Current Quarter Avg Count is decreased by comparing with previous Quarter Avg count  then the Trend is --Down Arrow

Current Quarter Avg Count is same comparing with previous Quarter Avg count  then the Trend is -- Dash(-)

Thanks in advance

[sunny_talwar · Accepted solution]

May be like this

If(Expression < Above(Expression), Image4DownArrow,

If(Expression > Above(Expression, Image4UpArrow))