How do I create a line chart comparing two column totals?

Applications Grid / Reports
#1

I have a grid that contains the fields Total_Expenses and Total_Revenue. I have totaled them grouped by month and I would like each field to be represented by a horizontal line and each month’s total will be a point on that line. I am currently getting two separate charts. What I want is to have both lines on the same chart so that I can compare the difference between the two over time (Similar to my text illustration below.) How do I accomplish this when my data is in columns? Unless there is a setting I am not understanding, it appears that ScriptCase only allows “rows” (not columns) to be shown as the lines?

  / /         _______________
 / /         /

/ / /
/ _/_____
__/

#2

Re: How do I create a line chart comparing two column totals?

Sumary view is sumarize rows - soo simple answer for your question is “yes” u cant do it in that way

Other solution -rly simple if u got data in columns is use simple grid + (on record calculation with another filed for result - there are some samples in about on record calculations on sc website)

I solved our problem in symilar case by using rows instead of columns for that 2 types of data (in/out cash flow) we simply making expected income with negative value to our income controll table and bank and cash income we inserting with positive value - we grouping that by client and by time soowe know how many money we got now, how much we are expecting and how muych money clients have to pay to us in the future.

I hope that it was helpfull - sorry by mine not excelent english :slight_smile: