Crosstab Formula 1

[zmcanally]

I have a crosstab report in the report header based on a single table of financial data. The primary fields of concern are: Classification, Industry, DataType and DataValue. The Classification is the rows while the Industry is the column. The DataType field will either be Plan or Actual with the DataValue field being the dollar value. I need to show both Plan and Actual in the summarized fields as well as the difference in the two (varience). I have done this using 3 seperate formulas, which shoed the correct data but was very clean. I can add the DataType as a second row which looks like I want it to, but I can't figure out how to remove the "Total" field there and add a varience formula. Any suggestions would be appreciated.

 

[lbass]

What version of CR are you using? Are you saying you get the correct data when you insert the three formulas as summaries? If you do, and the issue is that you want appropriate labels for the summaries, create a formula {@aummarylabels}:

whilereadingrecords;
"Plan" + chr(13) + "Actual" + chr(13) + "Variance"

Add {@summarylabels} as your second row field. To eliminate the subtotals that then appear, go to the customize style tab->select your first row field->check "suppress subtotals".

-LB

 

[zmcanally]

That was exactly what I needed - Thank you