Running Total Question

I have a parameter field {?Warehouse} that allows for All or single or multiple...

How can I create a Running Total Grand Total based on each one of these selected items in this {?Warehouse} field..

I have 11 Items
'DS'
'HA'
... and so on
I cant get the Report Footer to show Summary for various fields to show by these 11 items
Michael KatzAsked:
Who is Participating?
 
mlmccCommented:
Are you adding all values or is the running total excluding some?

I think the easiest to do is the cross tab idea.  That will work regardless oh how may values there are for Warehouse.  Also you won't get ones where there is no data.

How do you want the report to look?

mlmcc
0
 
peter57rCommented:
Can you be clear about what you are trying to do.

DO you actually want a running total or do you just want a single total for each warehouse?

If you want warehouse totals then can you not group the data by warehouse?
0
 
LinInDenverCommented:
if i understand correctly, you want totals in the report footer for each of the possible 11 items available in the parameter.

2 ideas:
you could create formulas that are manual running totals for each possibility. Insert them into the detail section, and then right click to insert a summary in report footer.
each formula would be similar to:
if {table.field} = 'DS' then {table.amount} else 0 //must compare against table.field, not the parameter field.

You could insert a cross tab in the report footer, which would have the amount field as detail, and the "type" (DS, HA) as columns.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.