Can we pass multiple subtotalN parameter for grouping data in template itself?

Aspose.Cells Product Family
1

Hi Team,
I am trying to use smart marker with grouping data in excel template.
In my use case, I am using multilevel grouping and I need to perform summary function upon one column field with respect to the multiple group column. For example - On a column I need sum for amount with all the group column.
I was able to achieve subtotal for one group with this smart marker and formula &=rows.cell7(subtotal9:rows.groupCell1, numeric).
Is that possible if for the same column we can pass multiple subtotal parameter. For ex - &=rows.cell7(subtotal9:rows.groupCell1, subtotal9:rows.groupCell2, numeric).

I am attaching the template and desired output file.
PFA for the same.

Thanks
TEMPLATE FILE - New3gpTemplate.pdf (46.2 KB)

OUTPUT FILE - Screenshot 2021-03-17 at 1.05.28 AM.jpg (284.5 KB)

2

@jjaiswal,
Could you please share a template file created with MS Excel where you are able to use multiple subtotalN parameters. Please zip the files prior attaching. We will analyze it and provide our feedback accordingly.