Monthtodate showing year to date totals

[Former Member]

I have document all designed with crosstab, all i want it month to date totals and year to date totals. i have use existing formulas and the yeartodate one works, however, the monthtodate is displaying year to date totals on the report.

Can someone please help? I am farily new to Crystal.

[Former Member · Accepted solution]

Thank you for responding Ian.

I am confused now, how will I get the Call types across the top if i don't use a cross tab?

Hardware Software Merchandise HR

1 MTD MTD MTD MTD

YTD YTD YTD YTD

2 MTD MTD MTD MTD

YTD YTD YTD YTD

3 MTD MTD MTD MTD

YTD YTD YTD YTD

4 MTD MTD MTD MTD

YTD YTD YTD YTD

This is what i have, but the MTD total is the same as the YTD total.

Or am i way off base?

Nita Kay

[Former Member · Accepted solution]

Using my suggested MthToDate formula.

Just add that to the summarized fields box on the Cross Tab expert

Ian