Sub Total per Category

[theboss-123]

Hello Everybody ,

In the example below i have the total "sum of value in years column' however i would like to get as results the sub total by Cat_PURCHASE can you help me please 

	year	2017	2018	2019
Cat_Purchase	Type	100	1000
Cat01	TypeA	400	2000	4000
	TypeB	600	3000	5000
	TypeC	790	6000	7000
Cat02	TypeA	300	8900
	TypeB	250
Total		4457	22918	16000

[theboss-123 · Accepted solution]

Hello the issue solved it was just selection of sub total from option