Totals in the same column

[akvsachin]

I’ve attached a snippet showing my attempt to calculate sub-totals and grand totals in the same column while grouping the data by a specific column and sorting it by the same column.

Could you please suggest if there’s another way to achieve this? I’ve also attached a sample worksheet for reference.

[binuacs]

@akvsachin what are the group-by fields used to calculate the sub-total? do you have the expected result?

[akvsachin]

Have attached a worksheet with output

[binuacs]

@akvsachin This can be done using a batch macro

[akvsachin]

Hi @binuacs 

Thank you for the solution! The problem is resolved.

However, is there a way to achieve this without using batch macros?

[binuacs · Accepted solution]

@akvsachin non- macro solution

[flying008 · Accepted solution]

Hi, @akvsachin 

FYI.

RecordID	Name	ID	Category	Country of Issue	Amount
1	Ashish	232654	Online Shopping	India	85
2	Lily	232654	Cricket Stadium	US	15
3		232654			100
1	Antony	623958	Cricket Stadium	Brazil	51
2	Sujeet	623958	Online Shopping	India	12
3	Pedri	623958	TV	Spain	91
4	Kane	623958	Football Match	US	52
5		623958			206
1	Kunal	846572	Gaming Console	India	95
2	Sachin	846572	Referigerator	India	52
3	Suresh	846572	Grocery	India	63
4	Benzema	846572	Grocery	Spain	97
5	Gavi	846572	Referigerator	Spain	84
6	Marcelo	846572	Football Match	Spain	93
7		846572			484
1	Anjali	953274	Electonics Equipment	India	95
2	Harsh	953274	Laptop & Accessories	India	74
3	Mukesh	953274	TV	India	96
4	Sridhar	953274	Match Arena Turf	United Arab Emirates	12
5		953274			277
					1067