Hi,
I'm trying to do a graph that shows year-to-date totals for each month. I have
SUM themoneyfield
BY thedimensionfield
ACROSS themonthfield COLUMNS 1 AND 2 AND 3...

The dimension field could be something like "cash" or "credit" - I get a vertical stacked bar with some of each value.

I want to show all 12 months, but it will not show "future" months. It works fine in a REPORT, but not for GRAPH. I'm already using a 'driver' table that has all 12 months in it, using a left outer join to my table with the money fields in it. As I said, replacing GRAPH with TABLE makes all 12 months appear.

Any ideas?

This message has been edited. Last edited by: Mike in DeLand,

It seems to work in a simple graph:

GRAPH FILE CAR
SUM
SALES
ACROSS SEATS COLUMNS 1 AND 2 AND 3 AND 4 AND 5 AND 6 AND 7 AND 14
END

I have a BY and an ACROSS. I wonder what the catch is.

Oops, I didn't take the BY into account. Still works though...

GRAPH FILE CAR
SUM
SALES
BY COUNTRY
ACROSS SEATS COLUMNS 1 AND 2 AND 3 AND 4 AND 5 AND 6 AND 7 AND 14
ON GRAPH SET GRMERGE ON
END

I would comment out all the graph styling. If you see all the columns you're expecting, start adding the graph styling one line at a time...

Will give it a shot, thanks.

No help with removing the styling. I ended up creating a dummy record with the month equal to 12 and included that in my dataset. Then it showed all the months up to and including 12.