Sub total in AdvancedListPane

[Former Member]

Hi experts,

How can I do to add a sub total row in AdvanceListPane?

I hope you can help me.

Best Regards.

[HorstSchaude · Accepted solution]

Hello Carlos,

You can create a sub total for any columns in a list.

• In the UI Designer goto the Designer tab
• Select the column you want to sum up
• In the Porperties window goto the Misc section
• Set the value of the property "Group Aggregate Function" to "sum"

You can also set the value to

• average
• minimum
• maximum

This will create a new line in the list with a subtotal for all columns with this value in the  "Group Aggregate Function".

HTH,

    Horst

[Former Member · Accepted solution]

This was very useful!!!

Thanks Horst.

Best Regards.

[former_member31710 · Accepted solution]

Hi Horst,

       Thanks for your suggestion.  one following question, I did what you suggested here. but i still do not see the subtotal row.  Do I miss something?

• "Group Aggregate Function" to "sum"

• No sub total value in UI

Thanks.

Chris

[HorstSchaude · Accepted solution]

Hello Chris,

If you click on the header to trigger the grouping you will see the sub total.

I'll ask my colleagues about having this grouping triggered from the beginning.

Bye,

   Horst

[Former Member · Accepted solution]

Hi Chris,

You must activate the GroupShowSubTotals option too:

Finally, you'll have the following:

Best regards,

Carlos.

[former_member31710]

Hi Carlos,

     I am afraid there is no such option in AdvancedListpane. But you can add field in another sectiongroup to use script to calculate the total value for your list.

Thanks.