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.
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.