Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CR9 Charts year over year

Status
Not open for further replies.

bgon1

Technical User
Nov 5, 2005
11
CA
How to make a chart of running totals with year over year information?

I've discovered how to chart two years information on one chart thanks to Ibass. I followed this:

Try using a formula for month for the "on change of" field:

monthname(month({table.date}))

After adding this to the chart expert, highlight it->order and choose specified order, and arrange the months in chronological order.

For "show values" (the lines) use formulas like:

//{@2005}:
if year({table.date}) = 2005 then {table.amt}

//{@2006}:
if year({table.date}) = 2006 then {table.amt}

But now I want to
a:arrange in fiscal year order and
b:use running totals.

I can't figure that part out.

Any help will be appreciated.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top