Skip to Content
Former Member
Aug 31, 2006 at 12:35 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.<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 &#39;manual&#39; crosstab is not an option.</p><p>&nbsp;</p><p>Thanks </p><p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p><br />