Compalre current month to previous month in an expression

[brf10043]

In my QV file I have a table where I calculate the percentage of tickets that are resolved within SLA using the following Expression.

count(DISTINCT{<STATUS={4,5},ResolveSLA={'Yes'}>} TICKET_ID_)/count(DISTINCT{<STATUS={4,5}>} TICKET_ID_)

I'm looking for a way to now to compare the previous month's percentage to the current Month's percentage for the entire table of 25 months   I really just need to know if the percentage goes up or down.  I'll then flag the column using Visual Cues (Green & Red).

Any suggestions on how to accomplish this?

Thanks,

Bobby

[sunny_talwar]

May be just use the Above() or Below() function based on your sorting:

Above(Count(DISTINCT {<STATUS={4,5},ResolveSLA={'Yes'}>} TICKET_ID_)/count(DISTINCT{<STATUS={4,5}>} TICKET_ID_))

[sunny_talwar]

[brf10043]

Apologies,  I can see all of your code.  The image was cut off.

[brf10043]

Actually, I did figure out how to see your code.  However, my table is set up a little differently.  As you can see from the image below, by data is running horizontally instead of vertically.  The months run from left to right and the CBS Service demission run from top to bottom.  For each CBS Service I want to know if the SLA percentage went up or down from the previous month.