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?