How to get sub totals and grand total in Visual Composer

[former_member557670]

Dear All,

I have a requirement like displaying a subtotal and grand total based on field choosen.

Now i am able to display total for each line or end of all lines in model or grand total but unable to get subtotal at end of item.

current output:

line item 10

     sut total - 50

line item 10

     sut total - 50

line item -20

     sub total -100

line item -20

    sub total -100

expected output

    line item 10

    sut total - 100

    line item -20

  sub total -200

grand total - 300

i have tried with group by and calculation we are not able to use both options at a time.

Regards,

Raju

[former_member202465]

Hi Raju,

I tried to create such an example, I hope it's relevant to your case.

The original model:

In Run-Time:

Now I change the model to use the Aggregate Operator. I Group By the text field and also compute the Sub Total of the number field:

Finally I connect a Table and use the Calcolation option on it (in the Configure Panel):

The Run-Time:

Hope it helps,

Thanks,

Udi