How to Each Dealership Name i have to get the total amount in excel sheet

[Srini84 (Srinivas Kadamati)]

@Shravyaganiga9895

Check below post for your reference

How to find and add subtotals of values in the data table

Hi everyone, I keep the table that get from Sql Server as a data table. This data table has ‘expense fields’ and ‘amount’ columns. Is it possible to find the subtotal of each of these expense fields and add them as additional rows to the datatable? For example; if this is my data table; (i am show it for instance in excel file but in the reality it is a data table) [image] i want to find this; (and then i will tranfer it in a excel file) [image] Here is sample data folders ExpenseField…

Hope this may help you

Thanks