Skip to Content
Former Member
Sep 01, 2006 at 04:33 AM

Comparing values in crosstabs


<p>Hi,</p> <p>Example..</p> <p> Let&#39;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&#39;d color the font red if that mont&#39;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 &#39;expenditure&#39; and &#39;previous average expenditure&#39; 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.</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 &#39;manual&#39; crosstab is not an option.</p> <p>&nbsp;</p> <p>Thanks <br /></p>