I just developed a table that contacts Accoun...

[Sarens_Nass_Mid]

I just developed a table that contacts Account Head Name, Debit Balance and Credit Balance. Now i want to show Total of Debit and Credit. How should it be done? Can you please help me out?

Thanks.

[Aleksi_Alkio]

There are few ways thow you can do that. You can sum them with the virtual column like SUM(TableName[Debit Balance]) and the same with Credit Balance. When you open the detail view, you can see them. With a bigger screen you are able to see them from the table view as well if needed.

One way is to add a virtual column with the expression like CONCATENATE(“Debit: $”,SUM(TableName[Debit Balance])," Credit: $",SUM(TableName[Credit Balance])) and then group the table view with that column.