Cross Tab with Date Ranges and Summaries 1

[StephHansen]

I need to create a cross tab that will show the columns, Last Week, Month To Date, Year To Date, based on today's date. What would be ideal is using the formulae: Last7Days, MonthtoDate, YearToDate, but it will not let me use formulas in my cross tab. How would I go about creating the count of these records?

Thanks!

Stephanie

 

[lbass]

I'm not sure that what you describe is a true crosstab, since you can't group on a field to arrive at the column headings, but you can make the report look like one. I would just group on some row field of interest, e.g., {salesperson}, and then write three formulas for the columns:

if {yourdate} in Last7Days then 1 else 0 //or you could substitute an amount, e.g., {sales}, you want to sum for the 1

if {yourdate} in MonthToDate then 1 else 0

if {yourdate} in YearToDate then 1 else 0

You can then insert summaries on these.

-LB