Crosstab Subtotals

[mktran]

I have a report with 5 rows and 1 column(GRP), and have surpressed all of the subtotals except for the subtotal for Row 5. So the format of the report looks like the example below. is there a way to have a subtotal for Budget (row 5)or a total Budget Amount for each 'type?'

row1 row2 row3 row4 row5 total column1
type detail_type acct# act.desc budget tot.cost Grp1 Grp2
Reserves Ops Res 123 ops res 3000 4000 2000 2000
Other Res 456 serv res 2000 1000 500 500
SubTotal 5000 2500 2500

 

[lbass]

Instead of adding budget as a rowfield, use it as a summary field. You can go into the customize style tab and set the summaries to horizontal and "show label" and then you can suppress the inner cells and resize to minize the width, leaving just the total for budget.

-LB

 

[mktran]

oh cool!! thanks LB!! you're sooo awesome!!

Since I moved the Budget field into the summarized field, it added another "group" to the report where there are 0's in actual amount, yet there are budgeted numbers in Budget. I had surpressed empty columns so that this column of 0's in actual amount would not show up, but since there is a number in Budget it is showing up on the report. is there a way to surpress this "group" where there are 0's in actual amount with an amount in budget?

 

[lbass]

Why is this occurring? Do you have a conditional formula that you are using for "column1"? If so, what is the formula?

-LB

 

[mktran]

There is no formula. I just used the field "group" field from the database. in this field, there are 4 different values, or 4 different groups, and there are nulls in this field for records that are not allocated to any group. if i dont include Budget in the summary field, i could surpress empty columns which would exclude this null column. but since there is a budgeted amount, it still appears.

 

[lbass]

I guess I'm not seeing why there would be a budget figure for a group containing nulls. But anyway, what kind of summary are you using for the budget amount--maximum? Maybe try this:

if not isnull({table.column1}) then
{table.budget}

Add this as your summary field instead of {table.budget}

Might work.

-LB