Year To Date-Month To Date-Week To Date Field

[ChiTownDiva]

I should have been more specific. I need to add Year to Date, Month to Date, Week to Date totals to an existing cross-tab report.

Thanks.

 

[kenhamady]

You may not be able to add these totals.
It depends on how the cross-tab is structured.

What are the fields currently used to make the cross-tab? Please give the name, data type and whether each is a row, column or summarized field. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[ChiTownDiva]

Hi Ken. Thanks for responding.

There are three fields on the report:

"State" - Text - Row
"City" - Text - Row
"Campaign_ID" - Text - Column

The Summarized field is "Leads_ID":

Type: Decimal
Precision: 18
Decimal Places: Auto

Thanks

 

[kenhamady]

So I take it that you are counting the leads by location and campaign. And you want YTD/MTD columns after the last campaign column? I don't think you can do this within a true cross-tab. You could create a manual cross-tab with these columns, but that would require manually coding every campaign column as a condition total.

You could have every cell in the cross-tab include total, YTD, MTD and WTD. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[ChiTownDiva]

I tried creating a formula and then using it as a summarized field as a "Count", but it didn't work.

If {tblLeadsTest.Date_Received}in YearToDate Then
{tblLeadsTest.LeadID}
Else
0

 

[kenhamady]

Try:

If {tblLeadsTest.Date_Received}in YearToDate
Then
1
Else
0

Then sum this field in the crosstab

Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[ChiTownDiva]

It worked. You're a genious.

Thanks!!!