Cross Tab Formula

[jen9814]

Is there a way to get a month-to-date totals and and a year-to-date totals as a column in a cross tab?

Example: current mtd ytd
variable x 5 10
variable y 2 8
total 7 18

Thanks.

 

[lbass]

You could easily do this with a manual crosstab by creating two formulas to be placed in the details section:

//{@MTD}:
if {table.date} in MonthToDate then 1 //or then {table.amt}

//{@YTD}:
if {table.date} in YearToDate then 1 //or then {table.amt}

Insert a group (that results in X or Y), and then right click on each formula and insert a summary (sum, not count).

Drag the group name to the group footer, and then suppress the details section.

-LB