header group by

[capriconuser]

i have a data like this

MAIN	SUB	Mode	Sum
		Single	123
		Multiple	123
		Double	123
	A		369
		Single	345
		Multiple	234
		Double	12
	B		591
		Single	575
		Multiple	576
		Double	577
	c		1728
		Single	579
		Multiple	580
		Double	581
	d		1740
		Single	583
		Multiple	584
		Double	585
	e		1752
		Single	587
		Multiple	588
		Double	589
	f		1764
		Single	591
		Multiple	592
		Double	593
	g		1776
abc			19440
		Single	596
		Multiple	597
		Double	598
	A		1791
		Single	600
		Multiple	601
		Double	602
	B		1803
		Single	604
		Multiple	605
		Double	606
	C		1815
		Single	608
		Multiple	609
		Double	610
	D		1827
		Single	612
		Multiple	613
		Double	614
	E		1839
		Single	616
		Multiple	617
		Double	618
	F		1851
		Single	620
		Multiple	621
		Double	622
	G		1863
abc1			25578

i want to group by mode column as header and split every mode like this

this is for single want same for  multiple and double in same table

MAIN	SINGLE
A	123
B	345
C	575
D	579
E	583
F	587
G	591
ABC	3383
A	596
B	600
C	604
D	608
E	612
F	616
G	620
ABC1	4256

how i do this

[capriconuser]

nops

l want every mode with separate table but in 1 table

like this and same for multiple

multiple comes after single and the double comes after multiple

[sunny_talwar]

So you want three charts?

[capriconuser]

yes but in 1 form

[sunny_talwar]

What do you mean when you say 1 form? Can you elaborate?

[sunny_talwar]

Is this what you are trying to make?

group by sum

[capriconuser]

yes exactly..  this is also my question 😕

[sunny_talwar]

This is probably the best you would be able to do...

[thevingo]

Is this fine

For making groups, I've added Key column from the script and on Presentation tab check 'Show partial sum' for MAIN