Conditional Formatting in Cross-tab to compare across cells.

[acentler]

Don't know if this is possible. Have a cross-tab report where I want to be able to change the color depending on how it compares to the previous entry. Similar to how one can do conditional formatting in excel ( if A2 > A1 then green).

Here is what the cross-tab is setup.

Rows = @Queue_Name

Columns = @Month [past 6 months(2007-01 , 2007-02..etc)
@Escalation [2 entries only (HD,LOB)]

Summarized Fields = Count of Tickets

2007-01 2007-02 2007-03
HD LOB Total HD LOB Total HD LOB Total
queue1 5 6 11 8 4 12 3 8 11
queue2 6 2 8 1 1 2 4 2 6

In this sample the 4 under 2007-02/LOB would be green.. then the 8 under 2007-03/LOB would be Red. Would like to be able to apply it to both HD and LOB fields.

I am using Crystal XI.

If there is a better way to do this then a cross-tab I am open to suggestions.

Thank You
ACE

 

[groggle]

I can't see a way of achieving this with a cross tab.

However, should you replace the cross tab with dynamic formulae for each column, you could then use the highlighting expert to achieve what yo want.

It is a lot more work as each column becomes a formula that needs to contain sufficient code to cope with all permutations but I have created reports that do this. ( A rolling 13 month report springs to mind)

In this scenario, the highlighting expert can apply formatting to a column based on the values in another column, just as you require.

 

[acentler]

So you mean have 13 seperate formulas in month order? When you have a moment can you give me a little more detail?

Thanks for the response!
ACE

 

[lbass]

I think you can do this within the crosstab, but I'm unclear on what two values you are comparing. Can you layout what the formula would be using field names (just for explanation purposes). Then I could help you translate it into crosstab code.

-LB