Cash Flow

Comments

• GRFrones

  February 2007 edited February 2007

  I can attach an excel sample of what I'm needing on the binaries newsgroup if it necessary.
  

  Edited wrote:

  Well... actually I can't. I'm having trouble with accessing the newsgroup.

  Best Regards.
• Adam London

  February 2007 edited 2:23PM

  The easiest way to do what I *think* you want to do is to put a summary footer below the CrossTab object & then put a SUM field in the summary footer to show what you want.
  
  However, note that the CrossTab can be made to show summaries itself ... so if you structure it right all the data ought to be right there without further addition, it might just need a bit of thinking about structuring the data that goes into the CrossTab to ensure you have the right columns to enable useful grouping of the data.
  
  Adam
• GRFrones

  February 2007 edited 2:23PM

  Thanks for your help.
  
  However, my CrossTab already does display a "summary" for the tab itself, that contains the sum of every column.
  
  What I'm needing is to subtract the sum of the columns on the CrossTab1 from the respective columns in the CrossTab2 (they will have the same "structure"). So that I get the balance for this column on a new summary row.
  
  Anyway, I'm not sure if the CrossTab is the best bet for what I'm trying to do. It has a slow performance and doesn't display the columns in the correct order. It depends upon the order of the table, I think.
  
  Bets Regards