Creating reports and dashboards | Stimulsoft community forum

How to "DataBand1 Then DataBand1Total" nested in GroupBandFooter?

In other words, how to complete "individuation total" ?

Detail:

GroupBandHeader_Master

DataBand_Master

GroupBandFooter_Master
{
DataBand_Detail_Addition (Relation: DataBand_Master.Column "EmpNo" equals this.Column "EmpNo" )

DataBand_Detail_Addition_Sum1 (i.e. Get Sum of DataBand_Detail_Addition that Column "type" is A)
DataBand_Detail_Addition_Sum2 (i.e. Get Sum of DataBand_Detail_Addition that Column "type" is not A )

DataBand_Detail_Deduction (Relation: DataBand_Master.Column "EmpNo" equals this.Column "EmpNo" )

DataBand_Detail_Deduction_Sum1 (i.e. Get Sum of DataBand_Detail_Deduction that Column "type" is A)
DataBand_Detail_Deduction_Sum2 (i.e. Get Sum of DataBand_Detail_Deduction that Column "type" is not A )

// Note Note Note
// Here insert following
DataBand_Detail_C_Sum1 (i.e. Get Sum of "DataBand_Detail_Deduction and DataBand_Detail_Addtion" that Column "T" is A)
DataBand_Detail_C_Sum2 (i.e. Get Sum of "DataBand_Detail_Deduction and DataBand_Detail_Addtion" that Column "T" is not A )

DataBand_Detail_Tax (Relation: DataBand_Master.Column "EmpNo" equals this.Column "EmpNo" )

DataBand_Detail_Tax_Sum1 (i.e. Get Sum of DataBand_Detail_Tax that Column "type" is A)
DataBand_Detail_Tax_Sum2 (i.e. Get Sum of DataBand_Detail_Tax that Column "type" is not A )

}

Hello.

Sorry, maybe we don't understand your question right.
Could you describe your question more detailed with samples?

Thank you.

HighAley wrote:Hello.

Sorry, maybe we don't understand your question right.
Could you describe your question more detailed with samples?

Thank you.

>>> i reWrite my question. could you help me ?

Hello.

Did you try to use the SumIf() function?
You could read more about this function at the Syntax of Aggregated Functions and Totals with Condition sections of the User Manual.

Thank you.