scripting

[sunitha_chellaiah]

Hi All,

I want to get below output using backend  scripting.

Please use attached data to get the output.

Thanks.

[jonathandienst]

May i ask why? It is possible, but the app will not respond in useful ways to user selections.

If you want partial totals, then a pivot table is the object to use. There are no subtotal in a straight table.

[Sergey_Shuklin]

Hello, Sunitha!

Exactly as your output is:

All calculations are done in the script.

PFA.