How to do a sub total of categories?

How do I group and categorize to get subtotals?

Example, I have categories like

Cap Expense 1 - amount 1
Cap Expense 2 - amount 2
Subtotal - amount 1 + amount 2

The data for Cap Expense 1, Cap expense 2 and amounts can be retrieved from the backend.
But category is a static label.

I tried using calculation field but it didn’t work.
Are there any other options?

Hi @gopinathpc -
I don’t understand the exact use case. Could you provide a few records sample of the input data as well as expected output?

hi @gopinathpc

We have not heard back. We’d still like to help. If we do not hear back in the next 7 days, we will archive the question.