I want to add Sub Total using SAQL Query

Question

Region	Sector	Notes	Count of Rows
America	FI	Client Choice	2
		Entry	8
		**Sub Total	10**
	MI	Rotation	45
		Data Source	30
		**Sub Total	75**
	**Sub Total		85**

I have the above table which shows Sub Total by Notes and Sub Total by Region. I want to write a SAQL query in which I could see just "SUB TOTAL BY REGION" in the final output in compare table. (example just I want to see Sub Total as 85 in the output table)

Answer 1

q = load "Issuance1";
q = group q by rollup ('Region','Sector','SalesComments');
q = foreach q generate case when grouping('Region') == 1 then "Total" else 'Region' end as 'Region', 
case when grouping('Sector') == 1 then "Subtotal" else 'Sector' end as 'Sector',
case when grouping('SalesComments') == 1 then "" else 'SalesComments' end as 'SalesComments',
count() as 'count';
q = filter q by ('SalesComments' != "" or 'Sector' =="Subtotal");
q = filter q by 'Region' != "Total";
q = order q by ('Region' asc, 'Sector' asc,'SalesComments' asc);
q = limit q 2000;

This is the answer