Comparing values in crosstabs
<p>Hi,</p><p>Example..</p><p> Let's say my columns were Months, my rows were Departments and my data cells were expenditures. Now I want to colorize those expenditures based on average expenditures for the previous years... and my dataset already includes this data. So I'd color the font red if that mont's expenditure is higher than its previous average, etc.</p><p>Now, I understand the difficulities in correlating crosstab data. However, Crystal Reports allows me to put both my 'expenditure' and 'previous average expenditure' fields into a single crosstab cell (they are displayed stacked on top of each other)... so the correlation has already been made. When I put a conditional formula on one of those data fields, is there a way to access that other field in the same cell so that I can compare the values for formatting? </p><p>The only options I can find for accessing other data within the crosstab are GridRowColumnValue and CurrentFieldValue.<span><span style="background: highlight none repeat scroll 0% 50%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; color: highlighttext"><span></span></span></span><br /></p><p>If my method is not possible, are there any other suggests for how to do this?</p><p>By the way, this is just a simplified example... a 'manual' crosstab is not an option.</p><p> </p><p>Thanks </p><p> </p><p> </p><p> </p><br />