New User Question: How to total within a grouping

[Aaron]

How do you total with in a group? When I ask this question, I am referring to a group that has like data within the group, and I need to total or sum that data within that group based off 2 values per record. when I try to sum that specific databand I get my totals at the bottom of the group, what I need is a total within the group per the like data. Let me know if you need more information.

Aaron

[Edward]

Hello Aaron,

Actually we need some more information. Do you need Running total inside the group?

Thank you.

[Aaron]

Edward,
Hello!

I need totals within a group of information. For an example, I have various records that include data for: QTY, Description, Comments, Width, and Height. This Data is summarized by Material (GroupHeader). For the given information there are natural groups (which I have sorted by width then Height) that widths match as well as the heights. I need a subtotal for where the like dimensions are alike (width and depth separately).

Hope this helps!

Thanks,
Aaron

[Jan]

Hello,

You need calculate total for each group ?

Thank you.

[Aaron]

Jan,
I need a sub total within a group.

Thanks,
Aaron

[Jan]

Hello,

You can use following expression to show sum of two fields:

Code: Select all

{DataSource.FieldWidth + DataSource.FieldHeight}

Following expression to calculate total of this expression:

Code: Select all

{Sum(DataSource.FieldWidth + DataSource.FieldHeight)}

Thank you.

[Aaron]

I am not trying to sum the widths and heights. I am looking for a subtotal within the group of the quantities. I showed the width and length on the form to show the natural break. I need a subtotal of the quantities where both the width and height are the same.

[Jan]

Hello,

Use following expression:

Code: Select all

{CountIf(DataSource.FieldWidth == DataSource.FieldHeight)}

Thank you.

[Aaron]

Jan,
If you would, please take a look at the attachment. The Width and Length are not the same, but there is a series of widths that are the same and in the same set of information the Lengths are the same as well. I need this set of information to sum the quantity for this set of information.

Thanks,
Aaron

[Brendan]

It sounds like you may need a 2nd Group Header Band and Group Footer Band.

For the Group header band you could set the group expression to something like {Datasource.CutWidth}_{Datasource.CutHeight} and Set the Group header band height to zero.

Then place a group footer below the databand and drop a field on for {Sum(Datasource.QTY)}